//*******COPY IT TO USE BELOW FUNCTION - INSERT************
//try
//{
// LIBtblmstEmployee objLIBtblmstEmployee = new LIBtblmstEmployee();
// DALtblmstEmployee objDALtblmstEmployee = new DALtblmstEmployee();
// MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
// objLIBtblmstEmployee.ID = txt.Text;
// objLIBtblmstEmployee.EmpID = txt.Text;
// objLIBtblmstEmployee.DOb = txt.Text;
// objLIBtblmstEmployee.Age = txt.Text;
// objLIBtblmstEmployee.DOJ = txt.Text;
// objLIBtblmstEmployee.Gender = txt.Text;
// objLIBtblmstEmployee.Dept = txt.Text;
// objLIBtblmstEmployee.Desig = txt.Text;
// objLIBtblmstEmployee.Grade = txt.Text;
// objLIBtblmstEmployee.Managerid = txt.Text;
// objLIBtblmstEmployee.LatestPerformance = txt.Text;
// objLIBtblmstEmployee.LastPromotion = txt.Text;
// objLIBtblmstEmployee.Grosspay = txt.Text;
// objLIBtblmstEmployee.currency = txt.Text;
// objLIBtblmstEmployee.createdBy = txt.Text;
// objLIBtblmstEmployee.dt = txt.Text;
// objLIBtblmstEmployee.fYear = txt.Text;
// tp.MessagePacket = objLIBtblmstEmployee;
// tp = objDALtblmstEmployee.InserttblmstEmployee(tp);
// if(tp.MessageId > -1)
//{
// string[] strOutParamValues = (string[])tp.MessageResultset;
// MessageBox.Show(strOutParamValues[0].ToString());
// }
// }
//catch(Exception ex)
//{
// MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
//}
/// <summary>
/// Accepts=Packet, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset
/// </summary>
/// <param name="Packet"></param>
/// <returns></returns>
/// <remarks></remarks>
public MyCLS.TransportationPacket InserttblmstEmployee(MyCLS.TransportationPacket Packet)
{
String[] strOutParamValues = new String[10];
List <SqlParameter> objParamList = new List <SqlParameter>();
List <SqlParameter> objParamListOut = new List <SqlParameter>();
MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql();
int Result = 0;
try
{
LIBtblmstEmployee objLIBtblmstEmployee = new LIBtblmstEmployee();
objLIBtblmstEmployee = (LIBtblmstEmployee)Packet.MessagePacket;
objParamList.Add(new SqlParameter("@ID", objLIBtblmstEmployee.ID));
objParamList.Add(new SqlParameter("@EmpID", objLIBtblmstEmployee.EmpID));
objParamList.Add(new SqlParameter("@DOb", objLIBtblmstEmployee.DOb));
objParamList.Add(new SqlParameter("@Age", objLIBtblmstEmployee.Age));
objParamList.Add(new SqlParameter("@DOJ", objLIBtblmstEmployee.DOJ));
objParamList.Add(new SqlParameter("@Gender", objLIBtblmstEmployee.Gender));
objParamList.Add(new SqlParameter("@Dept", objLIBtblmstEmployee.Dept));
objParamList.Add(new SqlParameter("@Desig", objLIBtblmstEmployee.Desig));
objParamList.Add(new SqlParameter("@Grade", objLIBtblmstEmployee.Grade));
objParamList.Add(new SqlParameter("@Managerid", objLIBtblmstEmployee.Managerid));
objParamList.Add(new SqlParameter("@LatestPerformance", objLIBtblmstEmployee.LatestPerformance));
objParamList.Add(new SqlParameter("@LastPromotion", objLIBtblmstEmployee.LastPromotion));
objParamList.Add(new SqlParameter("@Grosspay", objLIBtblmstEmployee.Grosspay));
objParamList.Add(new SqlParameter("@currency", objLIBtblmstEmployee.currency));
objParamList.Add(new SqlParameter("@createdBy", objLIBtblmstEmployee.createdBy));
objParamList.Add(new SqlParameter("@dt", objLIBtblmstEmployee.dt));
objParamList.Add(new SqlParameter("@fYear", objLIBtblmstEmployee.fYear));
objParamList.Add(new SqlParameter("@orgid", objLIBtblmstEmployee.OrgID));
objParamList.Add(new SqlParameter("@status", objLIBtblmstEmployee.Status));
objParamListOut.Add(new SqlParameter("@@ID", SqlDbType.Int));
strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InserttblmstEmployee", objParamList, objParamListOut, ref Result);
Packet.MessageId = Result;
Packet.MessageResultset = strOutParamValues;
}
catch (Exception ex)
{
Packet.MessageId = -1;
Packet.ex = ex;
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
return(Packet);
}
//PUT IT IN LOAD EVENTS
//MyCLS.strConnStringOLEDB = "Initial Catalog=AB;Data Source=127.0.0.1;UID=sa;PWD=sa123;Provider=SQLOLEDB.1";
//MyCLS.strConnStringSQLCLIENT = "Initial Catalog=AB;Data Source=127.0.0.1;UID=sa;PWD=sa123;";
//*******COPY IT TO USE BELOW FUNCTION - SELECT ALL************
//try
//{
// LIBtblmstEmployeeListing objLIBtblmstEmployeeListing = new LIBtblmstEmployeeListing();
// DALtblmstEmployee objDALtblmstEmployee = new DALtblmstEmployee();
// MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
// DataSet ds = new DataSet();
//// txt.Text = objLIBtblmstEmployeeListing[0].ID;
//// txt.Text = objLIBtblmstEmployeeListing[0].EmpID;
//// txt.Text = objLIBtblmstEmployeeListing[0].DOb;
//// txt.Text = objLIBtblmstEmployeeListing[0].Age;
//// txt.Text = objLIBtblmstEmployeeListing[0].DOJ;
//// txt.Text = objLIBtblmstEmployeeListing[0].Gender;
//// txt.Text = objLIBtblmstEmployeeListing[0].Dept;
//// txt.Text = objLIBtblmstEmployeeListing[0].Desig;
//// txt.Text = objLIBtblmstEmployeeListing[0].Grade;
//// txt.Text = objLIBtblmstEmployeeListing[0].Managerid;
//// txt.Text = objLIBtblmstEmployeeListing[0].LatestPerformance;
//// txt.Text = objLIBtblmstEmployeeListing[0].LastPromotion;
//// txt.Text = objLIBtblmstEmployeeListing[0].Grosspay;
//// txt.Text = objLIBtblmstEmployeeListing[0].currency;
//// txt.Text = objLIBtblmstEmployeeListing[0].createdBy;
//// txt.Text = objLIBtblmstEmployeeListing[0].dt;
//// txt.Text = objLIBtblmstEmployeeListing[0].fYear;
// tp = objDALtblmstEmployee.GettblmstEmployeeDetails();
// if(tp.MessageId == 1)
//{
// objLIBtblmstEmployeeListing = (LIBtblmstEmployeeListing)tp.MessageResultset;
// ds = (DataSet)tp.MessageResultsetDS;
// MessageBox.Show(objLIBtblmstEmployeeListing[0].ToString());
// }
//}
//catch(Exception ex)
//{
// MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
//}
/// <summary>
/// Accepts=Nothing, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset
/// </summary>
/// <returns></returns>
/// <remarks></remarks>
public MyCLS.TransportationPacket GettblmstEmployeeDetails()
{
DataSet ds = new DataSet();
LIBtblmstEmployeeListing objLIBtblmstEmployeeListing = new LIBtblmstEmployeeListing();
MyCLS.TransportationPacket Packet = new MyCLS.TransportationPacket();
MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql();
try
{
ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromtblmstEmployee");
if (ds != null)
{
if (ds.Tables != null)
{
if (ds.Tables[0].Rows != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
LIBtblmstEmployee oLIBtblmstEmployee = new LIBtblmstEmployee();
objLIBtblmstEmployeeListing.Add(oLIBtblmstEmployee);
objLIBtblmstEmployeeListing[i].ID = (int)ds.Tables[0].Rows[i]["ID"];
objLIBtblmstEmployeeListing[i].EmpID = ds.Tables[0].Rows[i]["EmpID"].ToString();
objLIBtblmstEmployeeListing[i].DOb = ds.Tables[0].Rows[i]["DOb"].ToString();
objLIBtblmstEmployeeListing[i].Age = (int)ds.Tables[0].Rows[i]["Age"];
objLIBtblmstEmployeeListing[i].DOJ = ds.Tables[0].Rows[i]["DOJ"].ToString();
objLIBtblmstEmployeeListing[i].Gender = ds.Tables[0].Rows[i]["Gender"].ToString();
objLIBtblmstEmployeeListing[i].Dept = ds.Tables[0].Rows[i]["Dept"].ToString();
objLIBtblmstEmployeeListing[i].Desig = ds.Tables[0].Rows[i]["Desig"].ToString();
objLIBtblmstEmployeeListing[i].Grade = ds.Tables[0].Rows[i]["Grade"].ToString();
objLIBtblmstEmployeeListing[i].Managerid = ds.Tables[0].Rows[i]["Managerid"].ToString();
objLIBtblmstEmployeeListing[i].LatestPerformance = ds.Tables[0].Rows[i]["LatestPerformance"].ToString();
objLIBtblmstEmployeeListing[i].LastPromotion = ds.Tables[0].Rows[i]["LastPromotion"].ToString();
objLIBtblmstEmployeeListing[i].Grosspay = (decimal)ds.Tables[0].Rows[i]["Grosspay"];
objLIBtblmstEmployeeListing[i].currency = ds.Tables[0].Rows[i]["currency"].ToString();
objLIBtblmstEmployeeListing[i].createdBy = ds.Tables[0].Rows[i]["createdBy"].ToString();
objLIBtblmstEmployeeListing[i].dt = ds.Tables[0].Rows[i]["dt"].ToString();
objLIBtblmstEmployeeListing[i].fYear = ds.Tables[0].Rows[i]["fYear"].ToString();
}
Packet.MessageId = 1;
}
else
{
Packet.MessageId = -1;
}
}
}
}
Packet.MessageResultsetDS = ds;
Packet.MessageResultset = objLIBtblmstEmployeeListing;
}
catch (Exception ex)
{
Packet.MessageId = -1;
Packet.ex = ex;
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
return(Packet);
}
