Gecko [ vsec.in ]

Name	Size	Permission
.mad-root	0 B	-rw-rw-rw-
BindCategories.cs	3.66 KB	-rw-rw-rw-
BindNews.cs	17.67 KB	-rw-rw-rw-
Class1.cs	2.74 KB	-rw-rw-rw-
DBManager_2.cs	5.21 KB	-rw-rw-rw-
DBmanager.cs	4.64 KB	-rw-rw-rw-
Dal_MediaType.cs	2.06 KB	-rw-rw-rw-
Dal_NewsSource.cs	3.04 KB	-rw-rw-rw-
Dal_PostNews.cs	17.14 KB	-rw-rw-rw-
Dal_Segment.cs	2.96 KB	-rw-rw-rw-
DataSetBill.xsd	15.47 KB	-rw-rw-rw-
DataSetBill.xss	859 B	-rw-rw-rw-
DataSetBill_Report.xsd	16.09 KB	-rw-rw-rw-
DataSetBill_Report.xss	859 B	-rw-rw-rw-
DataSetOnlyId.xsd	6.91 KB	-rw-rw-rw-
DataSetOnlyId.xss	854 B	-rw-rw-rw-
DataSetP_Pres.xsd	6.91 KB	-rw-rw-rw-
DataSetP_Pres.xss	3 B	-rw-rw-rw-
DataSetPatient.xsd	6.92 KB	-rw-rw-rw-
DataSetPatient.xss	3 B	-rw-rw-rw-
Emailsender.cs	1.15 KB	-rw-rw-rw-
GlobalClass.cs	495 B	-rw-rw-rw-
ManageSession.cs	1.24 KB	-rw-rw-rw-
PaymentData.cs	1.16 KB	-rw-rw-rw-
RishiMathod.cs	3.52 KB	-rw-rw-rw-
SMTPEmailSender.cs	1.56 KB	-rw-rw-rw-
ShowSlot.cs	413 B	-rw-rw-rw-
SmsSender.cs	1014 B	-rw-rw-rw-
Sql_Connection.cs	918 B	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
dbconnection.cs	1.19 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-

Code Editor : Dal_MediaType.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Summary description for Dal_MediaType
/// </summary>
public class Dal_MediaType
{
    Sql_Connection con_obj = new Sql_Connection();
    public DataTable Edit(string Id)
    {
        SqlCommand cmd = new SqlCommand("Select * from CNF_MEDIA_TYPE WHERE pk_cnf_mtype_id=@pk_cnf_mtype_id", con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@pk_cnf_mtype_id", Id);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con_obj.DbClose();
        return dt;
    }
    public int Update(string Id, string type_name)
    {
        string query = @"UPDATE CNF_MEDIA_TYPE SET type_name=@type_name WHERE pk_cnf_mtype_id=@pk_cnf_mtype_id";
        SqlCommand cmd = new SqlCommand(query, con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@type_name", type_name);       
        cmd.Parameters.AddWithValue("@pk_cnf_mtype_id", Id);
        int a = cmd.ExecuteNonQuery();
        con_obj.DbClose();
        return a;
    }
    public int Active(string Id)
    {
        string query = @"UPDATE CNF_MEDIA_TYPE SET type_status=1 WHERE pk_cnf_mtype_id=@pk_cnf_mtype_id";
        SqlCommand cmd = new SqlCommand(query, con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@pk_cnf_mtype_id", Id);
        int a = cmd.ExecuteNonQuery();
        con_obj.DbClose();
        return a;
    }
    public int Block(string Id)
    {
        string query = @"UPDATE CNF_MEDIA_TYPE SET type_status=0 WHERE pk_cnf_mtype_id=@pk_cnf_mtype_id";
        SqlCommand cmd = new SqlCommand(query, con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@pk_cnf_mtype_id", Id);
        int a = cmd.ExecuteNonQuery();
        con_obj.DbClose();
        return a;
    }
}

${this.title}

Code Editor : Dal_MediaType.cs