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_Segment.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Summary description for Segment
/// </summary>
public class Dal_Segment
{
    Sql_Connection con_obj = new Sql_Connection();
   
    public int Insert(string segment, string icon, string insby)
    {
        string query = @"INSERT INTO CNF_SEGMENT_MASTER (segment_name,segment_icon,segment_status,ins_by,ins_date) VALUES(@segment_name,@segment_icon,@segment_status,@ins_by,@ins_date)";
        SqlCommand cmd = new SqlCommand(query, con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@segment_name", segment);
        cmd.Parameters.AddWithValue("@segment_icon", icon);
        cmd.Parameters.AddWithValue("@segment_status", 1);
        cmd.Parameters.AddWithValue("@ins_by", insby);
        cmd.Parameters.AddWithValue("@ins_date", DateTime.Now);
        int a = cmd.ExecuteNonQuery();
        con_obj.DbClose();
        return a;
    }
    public DataTable Edit(string Id)
    {
        SqlCommand cmd = new SqlCommand("Select * from CNF_SEGMENT_MASTER WHERE pk_cnf_segment_id=@pk_cnf_segment_id", con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@pk_cnf_segment_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 segment, string icon)
    {
        string query = @"UPDATE CNF_SEGMENT_MASTER SET segment_name=@segment_name,segment_icon=@segment_icon WHERE pk_cnf_segment_id=@pk_cnf_segment_id";
        SqlCommand cmd = new SqlCommand(query, con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@segment_name", segment);
        cmd.Parameters.AddWithValue("@segment_icon", icon);
        cmd.Parameters.AddWithValue("@pk_cnf_segment_id", Id);
        int a = cmd.ExecuteNonQuery();
        con_obj.DbClose();
        return a;
    }
    public int Active(string Id)
    {
        string query = @"UPDATE CNF_SEGMENT_MASTER SET segment_status=1 WHERE pk_cnf_segment_id=@pk_cnf_segment_id";
        SqlCommand cmd = new SqlCommand(query, con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@pk_cnf_segment_id", Id);
        int a = cmd.ExecuteNonQuery();
        con_obj.DbClose();
        return a;
    }
    public int Block(string Id)
    {
        string query = @"UPDATE CNF_SEGMENT_MASTER SET segment_status=0 WHERE pk_cnf_segment_id=@pk_cnf_segment_id";
        SqlCommand cmd = new SqlCommand(query, con_obj.DbConnect());
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@pk_cnf_segment_id", Id);
        int a = cmd.ExecuteNonQuery();
        con_obj.DbClose();
        return a;
    }
}

${this.title}

Code Editor : Dal_Segment.cs