using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data; //Add namespace (Downloaded from Enterprise Library)
namespace nsemployee
{
public class clsempprp
{
public int p_empno { get; set; }
public String p_ename { get; set; }
public String p_eadd { get; set; }
public int p_esal { get; set; }
}
public class clsemp
{
String cs;
public clsemp()
{
cs = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
}
public void save_rec(clsempprp p)
{
Object[] prm = new object[4];
prm[0] = p.p_empno;
prm[1] = p.p_ename;
prm[2] = p.p_eadd;
prm[3] = p.p_esal;
SqlHelper.ExecuteNonQuery(cs, "insemp", prm);
}
public void update_rec(clsempprp p)
{
Object[] prm = new object[4];
prm[0] = p.p_empno;
prm[1] = p.p_ename;
prm[2] = p.p_eadd;
prm[3] = p.p_esal;
SqlHelper.ExecuteNonQuery(cs, "updemp", prm);
}
public void delete_rec(clsempprp p)
{
Object[] prm = new Object[1];
prm[0] = p.p_empno;
SqlHelper.ExecuteNonQuery(cs, "del", prm);
}
public List<clsempprp> disp_rec()
{
SqlDataReader dr;
dr = SqlHelper.ExecuteReader(cs, "dispemp");
List<clsempprp> obj = new List<clsempprp>();
while (dr.Read())
{
clsempprp k = new clsempprp();
k.p_empno = Convert.ToInt32(dr[0]);
k.p_ename = dr[1].ToString();
k.p_eadd = dr[2].ToString();
k.p_esal = Convert.ToInt32(dr[3]);
obj.Add(k);
}
dr.Close();
return obj;
}
}
}
No comments:
Post a Comment