//*******COPY IT TO USE BELOW FUNCTION - INSERT************ //try //{ // LIBtblmstContact objLIBtblmstContact = new LIBtblmstContact(); // DALtblmstContact objDALtblmstContact = new DALtblmstContact(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // objLIBtblmstContact.id = txt.Text; // objLIBtblmstContact.Name = txt.Text; // objLIBtblmstContact.Email = txt.Text; // objLIBtblmstContact.phone = txt.Text; // objLIBtblmstContact.designation = txt.Text; // objLIBtblmstContact.OrgName = txt.Text; // objLIBtblmstContact.dt = txt.Text; // tp.MessagePacket = objLIBtblmstContact; // tp = objDALtblmstContact.InserttblmstContact(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 InserttblmstContact(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 { LIBtblmstContact objLIBtblmstContact = new LIBtblmstContact(); objLIBtblmstContact = (LIBtblmstContact)Packet.MessagePacket; objParamList.Add(new SqlParameter("@id", objLIBtblmstContact.id)); objParamList.Add(new SqlParameter("@Name", objLIBtblmstContact.Name)); objParamList.Add(new SqlParameter("@Email", objLIBtblmstContact.Email)); objParamList.Add(new SqlParameter("@phone", objLIBtblmstContact.phone)); objParamList.Add(new SqlParameter("@designation", objLIBtblmstContact.designation)); objParamList.Add(new SqlParameter("@OrgName", objLIBtblmstContact.OrgName)); objParamList.Add(new SqlParameter("@INTREST", objLIBtblmstContact.INTREST)); objParamList.Add(new SqlParameter("@dt", objLIBtblmstContact.dt)); objParamListOut.Add(new SqlParameter("@@id", SqlDbType.Int)); strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InserttblmstContact", 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); }
//*******COPY IT TO USE BELOW FUNCTION - INSERT************ //try //{ // LIBtblOrgNatureofBussiness objLIBtblOrgNatureofBussiness = new LIBtblOrgNatureofBussiness(); // DALtblOrgNatureofBussiness objDALtblOrgNatureofBussiness = new DALtblOrgNatureofBussiness(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // objLIBtblOrgNatureofBussiness.id = txt.Text; // objLIBtblOrgNatureofBussiness.orgid = txt.Text; // objLIBtblOrgNatureofBussiness.natureid = txt.Text; // objLIBtblOrgNatureofBussiness.createdBy = txt.Text; // objLIBtblOrgNatureofBussiness.dt = txt.Text; // tp.MessagePacket = objLIBtblOrgNatureofBussiness; // tp = objDALtblOrgNatureofBussiness.InserttblOrgNatureofBussiness(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 InserttblOrgNatureofBussiness(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 { LIBtblOrgNatureofBussiness objLIBtblOrgNatureofBussiness = new LIBtblOrgNatureofBussiness(); objLIBtblOrgNatureofBussiness = (LIBtblOrgNatureofBussiness)Packet.MessagePacket; objParamList.Add(new SqlParameter("@id", objLIBtblOrgNatureofBussiness.id)); objParamList.Add(new SqlParameter("@orgid", objLIBtblOrgNatureofBussiness.orgid)); objParamList.Add(new SqlParameter("@natureid", objLIBtblOrgNatureofBussiness.natureid)); objParamList.Add(new SqlParameter("@createdBy", objLIBtblOrgNatureofBussiness.createdBy)); objParamList.Add(new SqlParameter("@dt", objLIBtblOrgNatureofBussiness.dt)); objParamListOut.Add(new SqlParameter("@@id", SqlDbType.Int)); strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InserttblOrgNatureofBussiness", 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); }
//*******COPY IT TO USE BELOW FUNCTION - INSERT************ //try //{ // LIBtblmstPerformance objLIBtblmstPerformance = new LIBtblmstPerformance(); // DALtblmstPerformance objDALtblmstPerformance = new DALtblmstPerformance(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // objLIBtblmstPerformance.id = txt.Text; // objLIBtblmstPerformance.orgid = txt.Text; // objLIBtblmstPerformance.LatestPerformance = txt.Text; // objLIBtblmstPerformance.PerLevel = txt.Text; // tp.MessagePacket = objLIBtblmstPerformance; // tp = objDALtblmstPerformance.InserttblmstPerformance(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 InserttblmstPerformance(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 { LIBtblmstPerformance objLIBtblmstPerformance = new LIBtblmstPerformance(); objLIBtblmstPerformance = (LIBtblmstPerformance)Packet.MessagePacket; objParamList.Add(new SqlParameter("@id", objLIBtblmstPerformance.id)); objParamList.Add(new SqlParameter("@orgid", objLIBtblmstPerformance.orgid)); objParamList.Add(new SqlParameter("@LatestPerformance", objLIBtblmstPerformance.LatestPerformance)); objParamList.Add(new SqlParameter("@PerLevel", objLIBtblmstPerformance.PerLevel)); objParamListOut.Add(new SqlParameter("@@id", SqlDbType.Int)); strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InserttblmstPerformance", 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); }
//*******COPY IT TO USE BELOW FUNCTION - INSERT************ //try //{ // LIBtblmstInstruction objLIBtblmstInstruction = new LIBtblmstInstruction(); // DALtblmstInstruction objDALtblmstInstruction = new DALtblmstInstruction(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // objLIBtblmstInstruction.ID = txt.Text; // objLIBtblmstInstruction.DOb/Age = txt.Text; // objLIBtblmstInstruction.currency = txt.Text; // tp.MessagePacket = objLIBtblmstInstruction; // tp = objDALtblmstInstruction.InserttblmstInstruction(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 InserttblmstInstruction(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 { LIBtblmstInstruction objLIBtblmstInstruction = new LIBtblmstInstruction(); objLIBtblmstInstruction = (LIBtblmstInstruction)Packet.MessagePacket; objParamList.Add(new SqlParameter("@ID", objLIBtblmstInstruction.ID)); objParamList.Add(new SqlParameter("@DOB", objLIBtblmstInstruction.DOb_Age)); objParamList.Add(new SqlParameter("@currency", objLIBtblmstInstruction.currency)); objParamListOut.Add(new SqlParameter("@@ID", SqlDbType.Int)); strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InserttblmstInstruction", 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); }
//*******COPY IT TO USE BELOW FUNCTION - SELECT BY ID************ //try //{ // LIBtblmstOrgInfoListing objLIBtblmstOrgInfoListing = new LIBtblmstOrgInfoListing(); // DALtblmstOrgInfo objDALtblmstOrgInfo = new DALtblmstOrgInfo(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // DataSet ds = new DataSet(); //// txt.Text = objLIBtblmstOrgInfoListing[0].id = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].orgid = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].year = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].turnover = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].HeadCount = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].Profit = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].WageBill = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].Attrtion = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].createdBy = ""; //// txt.Text = objLIBtblmstOrgInfoListing[0].dt = ""; // tp.MessagePacket = 1; //ID to be Passed // tp = objDALtblmstOrgInfo.GettblmstOrgInfoDetails(tp); // if(tp.MessageId == 1) //{ // objLIBtblmstOrgInfoListing = (LIBtblmstOrgInfoListing)tp.MessageResultset; // ds = (DataSet)tp.MessageResultsetDS; // MessageBox.Show(objLIBtblmstOrgInfoListing[0].ToString()); // } // } //catch(Exception ex) // { // MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true); // } /// <summary> /// Accepts=TransportationPacket, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset /// </summary> /// <returns></returns> /// <remarks></remarks> public MyCLS.TransportationPacket GettblmstOrgInfoDetails(MyCLS.TransportationPacket Packet) { DataSet ds = new DataSet(); List <SqlParameter> objParamList = new List <SqlParameter>(); LIBtblmstOrgInfoListing objLIBtblmstOrgInfoListing = new LIBtblmstOrgInfoListing(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@Id", Packet.MessagePacket)); ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromtblmstOrgInfoById", objParamList); 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++) { LIBtblmstOrgInfo oLIBtblmstOrgInfo = new LIBtblmstOrgInfo(); objLIBtblmstOrgInfoListing.Add(oLIBtblmstOrgInfo); objLIBtblmstOrgInfoListing[i].id = (int)ds.Tables[0].Rows[i]["id"]; objLIBtblmstOrgInfoListing[i].orgid = (int)ds.Tables[0].Rows[i]["orgid"]; objLIBtblmstOrgInfoListing[i].year = ds.Tables[0].Rows[i]["year"].ToString(); objLIBtblmstOrgInfoListing[i].turnover = (decimal)ds.Tables[0].Rows[i]["turnover"]; objLIBtblmstOrgInfoListing[i].HeadCount = (decimal)ds.Tables[0].Rows[i]["HeadCount"]; objLIBtblmstOrgInfoListing[i].Profit = (decimal)ds.Tables[0].Rows[i]["Profit"]; objLIBtblmstOrgInfoListing[i].WageBill = (decimal)ds.Tables[0].Rows[i]["WageBill"]; objLIBtblmstOrgInfoListing[i].Attrtion = (decimal)ds.Tables[0].Rows[i]["Attrtion"]; objLIBtblmstOrgInfoListing[i].createdBy = ds.Tables[0].Rows[i]["createdBy"].ToString(); objLIBtblmstOrgInfoListing[i].dt = ds.Tables[0].Rows[i]["dt"].ToString(); } Packet.MessageId = 1; } else { Packet.MessageId = -1; } } } } Packet.MessageResultsetDS = ds; Packet.MessageResultset = objLIBtblmstOrgInfoListing; } catch (Exception ex) { Packet.MessageId = -1; Packet.ex = ex; MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true); } return(Packet); }
//*******COPY IT TO USE BELOW FUNCTION - SELECT BY ID************ //try //{ // LIBErLogListing objLIBErLogListing = new LIBErLogListing(); // DALErLog objDALErLog = new DALErLog(); // TransportationPacket tp = new TransportationPacket(); // Dateset ds = new Dataset(); // tp.MessagePacket = 1; //ID to be Passed //// txt.Text = objLIBErLogListing[0].Id = ""; //// txt.Text = objLIBErLogListing[0].Dt = ""; //// txt.Text = objLIBErLogListing[0].StackTrace = ""; //// txt.Text = objLIBErLogListing[0].MethodName = ""; //// txt.Text = objLIBErLogListing[0].Username = ""; //// txt.Text = objLIBErLogListing[0].Msg = ""; //// txt.Text = objLIBErLogListing[0].Source = ""; //// txt.Text = objLIBErLogListing[0].TargetSite = ""; //// txt.Text = objLIBErLogListing[0].Data = ""; //// txt.Text = objLIBErLogListing[0].FullMsg = ""; // tp = objDALErLog.GetErLogDetails(tp); // if(tp.MessageId == 1) //{ // objLIBErLogListing = (LIBErLogListing)tp.MessageResultset; // ds = (Dateset)tp.MessageResultsetDS; // MessageBox.Show(objLIBErLogListing[0].ToString()); // } // } //catch(Exception ex) // { // MessageBox.Show(ex.Message); // } /// <summary> /// Accepts=TransportationPacket, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset /// </summary> /// <returns></returns> /// <remarks></remarks> public TransportationPacket GetErLogDetails(TransportationPacket Packet) { DataSet ds = new DataSet(); List <SqlParameter> objParamList = new List <SqlParameter>(); LIBErLogListing objLIBErLogListing = new LIBErLogListing(); clsExecuteStoredProcSql clsESPSql = new clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@Id", Packet.MessagePacket)); ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromErLogById", objParamList); 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++) { LIBErLog oLIBErLog = new LIBErLog(); objLIBErLogListing.Add(oLIBErLog); objLIBErLogListing[i].Id = (int)ds.Tables[0].Rows[i]["Id"]; objLIBErLogListing[i].Dt = (DateTime)ds.Tables[0].Rows[i]["Dt"]; objLIBErLogListing[i].StackTrace = ds.Tables[0].Rows[i]["StackTrace"].ToString(); objLIBErLogListing[i].MethodName = ds.Tables[0].Rows[i]["MethodName"].ToString(); objLIBErLogListing[i].Username = ds.Tables[0].Rows[i]["Username"].ToString(); objLIBErLogListing[i].Msg = ds.Tables[0].Rows[i]["Msg"].ToString(); objLIBErLogListing[i].Source = ds.Tables[0].Rows[i]["Source"].ToString(); objLIBErLogListing[i].TargetSite = ds.Tables[0].Rows[i]["TargetSite"].ToString(); objLIBErLogListing[i].Data = ds.Tables[0].Rows[i]["Data"].ToString(); objLIBErLogListing[i].InnerEx = ds.Tables[0].Rows[i]["InnerEx"].ToString(); objLIBErLogListing[i].FullMsg = ds.Tables[0].Rows[i]["FullMsg"].ToString(); } Packet.MessageId = 1; } else { Packet.MessageId = -1; } } } } Packet.MessageResultsetDS = ds; Packet.MessageResultset = objLIBErLogListing; } catch (Exception ex) { Packet.MessageId = -1; clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), false); } return(Packet); }
//*******COPY IT TO USE BELOW FUNCTION - SELECT BY ID************ //try //{ // LIBtblOrgBasicInfoListing objLIBtblOrgBasicInfoListing = new LIBtblOrgBasicInfoListing(); // DALtblOrgBasicInfo objDALtblOrgBasicInfo = new DALtblOrgBasicInfo(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // DataSet ds = new DataSet(); //// txt.Text = objLIBtblOrgBasicInfoListing[0].id = ""; //// txt.Text = objLIBtblOrgBasicInfoListing[0].username = ""; //// txt.Text = objLIBtblOrgBasicInfoListing[0].Name = ""; //// txt.Text = objLIBtblOrgBasicInfoListing[0].Email = ""; //// txt.Text = objLIBtblOrgBasicInfoListing[0].phone = ""; //// txt.Text = objLIBtblOrgBasicInfoListing[0].designation = ""; //// txt.Text = objLIBtblOrgBasicInfoListing[0].OrgName = ""; //// txt.Text = objLIBtblOrgBasicInfoListing[0].industry = ""; //// txt.Text = objLIBtblOrgBasicInfoListing[0].dt = ""; // tp.MessagePacket = 1; //ID to be Passed // tp = objDALtblOrgBasicInfo.GettblOrgBasicInfoDetails(tp); // if(tp.MessageId == 1) //{ // objLIBtblOrgBasicInfoListing = (LIBtblOrgBasicInfoListing)tp.MessageResultset; // ds = (DataSet)tp.MessageResultsetDS; // MessageBox.Show(objLIBtblOrgBasicInfoListing[0].ToString()); // } // } //catch(Exception ex) // { // MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true); // } /// <summary> /// Accepts=TransportationPacket, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset /// </summary> /// <returns></returns> /// <remarks></remarks> public MyCLS.TransportationPacket GettblOrgBasicInfoDetails(MyCLS.TransportationPacket Packet) { DataSet ds = new DataSet(); List <SqlParameter> objParamList = new List <SqlParameter>(); LIBtblOrgBasicInfoListing objLIBtblOrgBasicInfoListing = new LIBtblOrgBasicInfoListing(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@Id", Packet.MessagePacket)); ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromtblOrgBasicInfoById", objParamList); 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++) { LIBtblOrgBasicInfo oLIBtblOrgBasicInfo = new LIBtblOrgBasicInfo(); objLIBtblOrgBasicInfoListing.Add(oLIBtblOrgBasicInfo); objLIBtblOrgBasicInfoListing[i].id = (int)ds.Tables[0].Rows[i]["id"]; objLIBtblOrgBasicInfoListing[i].username = ds.Tables[0].Rows[i]["username"].ToString(); objLIBtblOrgBasicInfoListing[i].Name = ds.Tables[0].Rows[i]["Name"].ToString(); objLIBtblOrgBasicInfoListing[i].Email = ds.Tables[0].Rows[i]["Email"].ToString(); objLIBtblOrgBasicInfoListing[i].phone = ds.Tables[0].Rows[i]["phone"].ToString(); objLIBtblOrgBasicInfoListing[i].designation = ds.Tables[0].Rows[i]["designation"].ToString(); objLIBtblOrgBasicInfoListing[i].OrgName = ds.Tables[0].Rows[i]["OrgName"].ToString(); objLIBtblOrgBasicInfoListing[i].industry = ds.Tables[0].Rows[i]["industry"].ToString(); objLIBtblOrgBasicInfoListing[i].dt = ds.Tables[0].Rows[i]["dt"].ToString(); } Packet.MessageId = 1; } else { Packet.MessageId = -1; } } } } Packet.MessageResultsetDS = ds; Packet.MessageResultset = objLIBtblOrgBasicInfoListing; } catch (Exception ex) { Packet.MessageId = -1; Packet.ex = ex; MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true); } return(Packet); }
//*******COPY IT TO USE BELOW FUNCTION - SELECT BY ID************ //try //{ // LIBtblmstBenchmarkListing objLIBtblmstBenchmarkListing = new LIBtblmstBenchmarkListing(); // DALtblmstBenchmark objDALtblmstBenchmark = new DALtblmstBenchmark(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // DataSet ds = new DataSet(); //// txt.Text = objLIBtblmstBenchmarkListing[0].id = ""; //// txt.Text = objLIBtblmstBenchmarkListing[0].industryid = ""; //// txt.Text = objLIBtblmstBenchmarkListing[0].bm1_1 = ""; //// txt.Text = objLIBtblmstBenchmarkListing[0].bm1_2 = ""; //// txt.Text = objLIBtblmstBenchmarkListing[0].bm2_1 = ""; //// txt.Text = objLIBtblmstBenchmarkListing[0].bm2_2 = ""; //// txt.Text = objLIBtblmstBenchmarkListing[0].bm3_1 = ""; //// txt.Text = objLIBtblmstBenchmarkListing[0].bm3_2 = ""; //// txt.Text = objLIBtblmstBenchmarkListing[0].currency = ""; // tp.MessagePacket = 1; //ID to be Passed // tp = objDALtblmstBenchmark.GettblmstBenchmarkDetails(tp); // if(tp.MessageId == 1) //{ // objLIBtblmstBenchmarkListing = (LIBtblmstBenchmarkListing)tp.MessageResultset; // ds = (DataSet)tp.MessageResultsetDS; // MessageBox.Show(objLIBtblmstBenchmarkListing[0].ToString()); // } // } //catch(Exception ex) // { // MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true); // } /// <summary> /// Accepts=TransportationPacket, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset /// </summary> /// <returns></returns> /// <remarks></remarks> public MyCLS.TransportationPacket GettblmstBenchmarkDetails(MyCLS.TransportationPacket Packet) { DataSet ds = new DataSet(); List <SqlParameter> objParamList = new List <SqlParameter>(); LIBtblmstBenchmarkListing objLIBtblmstBenchmarkListing = new LIBtblmstBenchmarkListing(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@Id", Packet.MessagePacket)); ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromtblmstBenchmarkById", objParamList); 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++) { LIBtblmstBenchmark oLIBtblmstBenchmark = new LIBtblmstBenchmark(); objLIBtblmstBenchmarkListing.Add(oLIBtblmstBenchmark); objLIBtblmstBenchmarkListing[i].id = (int)ds.Tables[0].Rows[i]["id"]; objLIBtblmstBenchmarkListing[i].industryid = (int)ds.Tables[0].Rows[i]["industryid"]; objLIBtblmstBenchmarkListing[i].bm1_1 = (decimal)ds.Tables[0].Rows[i]["bm1_1"]; objLIBtblmstBenchmarkListing[i].bm1_2 = (decimal)ds.Tables[0].Rows[i]["bm1_2"]; objLIBtblmstBenchmarkListing[i].bm2_1 = (decimal)ds.Tables[0].Rows[i]["bm2_1"]; objLIBtblmstBenchmarkListing[i].bm2_2 = (decimal)ds.Tables[0].Rows[i]["bm2_2"]; objLIBtblmstBenchmarkListing[i].bm3_1 = (decimal)ds.Tables[0].Rows[i]["bm3_1"]; objLIBtblmstBenchmarkListing[i].bm3_2 = (decimal)ds.Tables[0].Rows[i]["bm3_2"]; objLIBtblmstBenchmarkListing[i].currency = ds.Tables[0].Rows[i]["currency"].ToString(); } Packet.MessageId = 1; } else { Packet.MessageId = -1; } } } } Packet.MessageResultsetDS = ds; Packet.MessageResultset = objLIBtblmstBenchmarkListing; } catch (Exception ex) { Packet.MessageId = -1; Packet.ex = ex; MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true); } return(Packet); }
//*******COPY IT TO USE BELOW FUNCTION - SELECT BY ID************ //try //{ // LIBtblOrgNatureofBussinessListing objLIBtblOrgNatureofBussinessListing = new LIBtblOrgNatureofBussinessListing(); // DALtblOrgNatureofBussiness objDALtblOrgNatureofBussiness = new DALtblOrgNatureofBussiness(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // DataSet ds = new DataSet(); //// txt.Text = objLIBtblOrgNatureofBussinessListing[0].id = ""; //// txt.Text = objLIBtblOrgNatureofBussinessListing[0].orgid = ""; //// txt.Text = objLIBtblOrgNatureofBussinessListing[0].natureid = ""; //// txt.Text = objLIBtblOrgNatureofBussinessListing[0].createdBy = ""; //// txt.Text = objLIBtblOrgNatureofBussinessListing[0].dt = ""; // tp.MessagePacket = 1; //ID to be Passed // tp = objDALtblOrgNatureofBussiness.GettblOrgNatureofBussinessDetails(tp); // if(tp.MessageId == 1) //{ // objLIBtblOrgNatureofBussinessListing = (LIBtblOrgNatureofBussinessListing)tp.MessageResultset; // ds = (DataSet)tp.MessageResultsetDS; // MessageBox.Show(objLIBtblOrgNatureofBussinessListing[0].ToString()); // } // } //catch(Exception ex) // { // MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true); // } /// <summary> /// Accepts=TransportationPacket, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset /// </summary> /// <returns></returns> /// <remarks></remarks> public MyCLS.TransportationPacket GettblOrgNatureofBussinessDetails(MyCLS.TransportationPacket Packet) { DataSet ds = new DataSet(); List <SqlParameter> objParamList = new List <SqlParameter>(); LIBtblOrgNatureofBussinessListing objLIBtblOrgNatureofBussinessListing = new LIBtblOrgNatureofBussinessListing(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@Id", Packet.MessagePacket)); ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromtblOrgNatureofBussinessById", objParamList); 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++) { LIBtblOrgNatureofBussiness oLIBtblOrgNatureofBussiness = new LIBtblOrgNatureofBussiness(); objLIBtblOrgNatureofBussinessListing.Add(oLIBtblOrgNatureofBussiness); objLIBtblOrgNatureofBussinessListing[i].id = (int)ds.Tables[0].Rows[i]["id"]; objLIBtblOrgNatureofBussinessListing[i].orgid = (int)ds.Tables[0].Rows[i]["orgid"]; objLIBtblOrgNatureofBussinessListing[i].natureid = (int)ds.Tables[0].Rows[i]["natureid"]; objLIBtblOrgNatureofBussinessListing[i].createdBy = ds.Tables[0].Rows[i]["createdBy"].ToString(); objLIBtblOrgNatureofBussinessListing[i].dt = ds.Tables[0].Rows[i]["dt"].ToString(); } Packet.MessageId = 1; } else { Packet.MessageId = -1; } } } } Packet.MessageResultsetDS = ds; Packet.MessageResultset = objLIBtblOrgNatureofBussinessListing; } 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 //{ // LIBtblmstContactListing objLIBtblmstContactListing = new LIBtblmstContactListing(); // DALtblmstContact objDALtblmstContact = new DALtblmstContact(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // DataSet ds = new DataSet(); //// txt.Text = objLIBtblmstContactListing[0].id; //// txt.Text = objLIBtblmstContactListing[0].Name; //// txt.Text = objLIBtblmstContactListing[0].Email; //// txt.Text = objLIBtblmstContactListing[0].phone; //// txt.Text = objLIBtblmstContactListing[0].designation; //// txt.Text = objLIBtblmstContactListing[0].OrgName; //// txt.Text = objLIBtblmstContactListing[0].dt; // tp = objDALtblmstContact.GettblmstContactDetails(); // if(tp.MessageId == 1) //{ // objLIBtblmstContactListing = (LIBtblmstContactListing)tp.MessageResultset; // ds = (DataSet)tp.MessageResultsetDS; // MessageBox.Show(objLIBtblmstContactListing[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 GettblmstContactDetails() { DataSet ds = new DataSet(); LIBtblmstContactListing objLIBtblmstContactListing = new LIBtblmstContactListing(); MyCLS.TransportationPacket Packet = new MyCLS.TransportationPacket(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromtblmstContact"); 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++) { LIBtblmstContact oLIBtblmstContact = new LIBtblmstContact(); objLIBtblmstContactListing.Add(oLIBtblmstContact); objLIBtblmstContactListing[i].id = (int)ds.Tables[0].Rows[i]["id"]; objLIBtblmstContactListing[i].Name = ds.Tables[0].Rows[i]["Name"].ToString(); objLIBtblmstContactListing[i].Email = ds.Tables[0].Rows[i]["Email"].ToString(); objLIBtblmstContactListing[i].phone = ds.Tables[0].Rows[i]["phone"].ToString(); objLIBtblmstContactListing[i].designation = ds.Tables[0].Rows[i]["designation"].ToString(); objLIBtblmstContactListing[i].OrgName = ds.Tables[0].Rows[i]["OrgName"].ToString(); objLIBtblmstContactListing[i].dt = ds.Tables[0].Rows[i]["dt"].ToString(); } Packet.MessageId = 1; } else { Packet.MessageId = -1; } } } } Packet.MessageResultsetDS = ds; Packet.MessageResultset = objLIBtblmstContactListing; } 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 //{ // LIBtblmstPerformanceListing objLIBtblmstPerformanceListing = new LIBtblmstPerformanceListing(); // DALtblmstPerformance objDALtblmstPerformance = new DALtblmstPerformance(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // DataSet ds = new DataSet(); //// txt.Text = objLIBtblmstPerformanceListing[0].id; //// txt.Text = objLIBtblmstPerformanceListing[0].orgid; //// txt.Text = objLIBtblmstPerformanceListing[0].LatestPerformance; //// txt.Text = objLIBtblmstPerformanceListing[0].PerLevel; // tp = objDALtblmstPerformance.GettblmstPerformanceDetails(); // if(tp.MessageId == 1) //{ // objLIBtblmstPerformanceListing = (LIBtblmstPerformanceListing)tp.MessageResultset; // ds = (DataSet)tp.MessageResultsetDS; // MessageBox.Show(objLIBtblmstPerformanceListing[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 GettblmstPerformanceDetails() { DataSet ds = new DataSet(); LIBtblmstPerformanceListing objLIBtblmstPerformanceListing = new LIBtblmstPerformanceListing(); MyCLS.TransportationPacket Packet = new MyCLS.TransportationPacket(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromtblmstPerformance"); 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++) { LIBtblmstPerformance oLIBtblmstPerformance = new LIBtblmstPerformance(); objLIBtblmstPerformanceListing.Add(oLIBtblmstPerformance); objLIBtblmstPerformanceListing[i].id = (int)ds.Tables[0].Rows[i]["id"]; objLIBtblmstPerformanceListing[i].orgid = (int)ds.Tables[0].Rows[i]["orgid"]; objLIBtblmstPerformanceListing[i].LatestPerformance = ds.Tables[0].Rows[i]["LatestPerformance"].ToString(); objLIBtblmstPerformanceListing[i].PerLevel = (int)ds.Tables[0].Rows[i]["PerLevel"]; } Packet.MessageId = 1; } else { Packet.MessageId = -1; } } } } Packet.MessageResultsetDS = ds; Packet.MessageResultset = objLIBtblmstPerformanceListing; } catch (Exception ex) { Packet.MessageId = -1; Packet.ex = ex; MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true); } return(Packet); }
//*******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); }
public DataSet FillData(string whrCon, string procedureName) { DataSet ds = new DataSet(); List <SqlParameter> objParamList = new List <SqlParameter>(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@whrCon", whrCon)); ds = clsESPSql.ExecuteSPDataSet(procedureName, objParamList); return(ds); } catch (Exception ex) { return(null); } }
//*******COPY IT TO USE BELOW FUNCTION - INSERT************ //try //{ // LIBtblmstOrgInfo objLIBtblmstOrgInfo = new LIBtblmstOrgInfo(); // DALtblmstOrgInfo objDALtblmstOrgInfo = new DALtblmstOrgInfo(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // objLIBtblmstOrgInfo.id = txt.Text; // objLIBtblmstOrgInfo.orgid = txt.Text; // objLIBtblmstOrgInfo.year = txt.Text; // objLIBtblmstOrgInfo.turnover = txt.Text; // objLIBtblmstOrgInfo.HeadCount = txt.Text; // objLIBtblmstOrgInfo.Profit = txt.Text; // objLIBtblmstOrgInfo.WageBill = txt.Text; // objLIBtblmstOrgInfo.Attrtion = txt.Text; // objLIBtblmstOrgInfo.createdBy = txt.Text; // objLIBtblmstOrgInfo.dt = txt.Text; // tp.MessagePacket = objLIBtblmstOrgInfo; // tp = objDALtblmstOrgInfo.InserttblmstOrgInfo(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 InserttblmstOrgInfo(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 { LIBtblmstOrgInfo objLIBtblmstOrgInfo = new LIBtblmstOrgInfo(); objLIBtblmstOrgInfo = (LIBtblmstOrgInfo)Packet.MessagePacket; objParamList.Add(new SqlParameter("@id", objLIBtblmstOrgInfo.id)); objParamList.Add(new SqlParameter("@orgid", objLIBtblmstOrgInfo.orgid)); objParamList.Add(new SqlParameter("@year", objLIBtblmstOrgInfo.year)); objParamList.Add(new SqlParameter("@turnover", objLIBtblmstOrgInfo.turnover)); objParamList.Add(new SqlParameter("@HeadCount", objLIBtblmstOrgInfo.HeadCount)); objParamList.Add(new SqlParameter("@Profit", objLIBtblmstOrgInfo.Profit)); objParamList.Add(new SqlParameter("@WageBill", objLIBtblmstOrgInfo.WageBill)); objParamList.Add(new SqlParameter("@Attrtion", objLIBtblmstOrgInfo.Attrtion)); objParamList.Add(new SqlParameter("@createdBy", objLIBtblmstOrgInfo.createdBy)); objParamList.Add(new SqlParameter("@dt", objLIBtblmstOrgInfo.dt)); objParamList.Add(new SqlParameter("@Currency", objLIBtblmstOrgInfo.Currency)); objParamList.Add(new SqlParameter("@industry", objLIBtblmstOrgInfo.Industry)); objParamListOut.Add(new SqlParameter("@@id", SqlDbType.Int)); strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InserttblmstOrgInfo", 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); }
public DataSet ExQuery(string Query) { DataSet ds = new DataSet(); int rCount = 0; List <SqlParameter> objParamList = new List <SqlParameter>(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@Query", Query)); ds = clsESPSql.ExecuteSPDataSet("SP_QueryExec", objParamList); } catch (Exception ex) { } return(ds); }
public int DeleteSYData(string AppId, string tableNm) { DataSet ds = new DataSet(); int rCount = 0; List <SqlParameter> objParamList = new List <SqlParameter>(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@whrCon", AppId)); objParamList.Add(new SqlParameter("@tableName", tableNm)); rCount = clsESPSql.ExecuteSPNonQuery("Sp_DeleteTableData", objParamList); } catch (Exception ex) { } return(rCount); }
//*******COPY IT TO USE BELOW FUNCTION - INSERT************ //try //{ // LIBErLog objLIBErLog = new LIBErLog(); // DALErLog objDALErLog = new DALErLog(); // TransportationPacket tp = new TransportationPacket(); // objLIBErLog.Id = txt.Text; // objLIBErLog.Dt = txt.Text; // objLIBErLog.StackTrace = txt.Text; // objLIBErLog.MethodName = txt.Text; // objLIBErLog.Username = txt.Text; // objLIBErLog.Msg = txt.Text; // objLIBErLog.Source = txt.Text; // objLIBErLog.TargetSite = txt.Text; // objLIBErLog.Data = txt.Text; // objLIBErLog.FullMsg = txt.Text; // tp.MessagePacket = objLIBErLog; // tp = objDALErLog.InsertErLog(tp); // if(tp.MessageId > -1) //{ // string[] strOutParamValues = (string[])tp.MessageResultset; // MessageBox.Show(strOutParamValues[0].ToString()); // } // } //catch(Exception ex) //{ // MessageBox.Show(ex.Message); //} /// <summary> /// Accepts=Packet, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset /// </summary> /// <param name="Packet"></param> /// <returns></returns> /// <remarks></remarks> public TransportationPacket InsertErLog(TransportationPacket Packet) { String[] strOutParamValues = new String[10]; List <SqlParameter> objParamList = new List <SqlParameter>(); List <SqlParameter> objParamListOut = new List <SqlParameter>(); clsExecuteStoredProcSql clsESPSql = new clsExecuteStoredProcSql(); int Result = 0; try { LIBErLog objLIBErLog = new LIBErLog(); objLIBErLog = (LIBErLog)Packet.MessagePacket; objParamList.Add(new SqlParameter("@Id", objLIBErLog.Id)); //objParamList.Add(new SqlParameter("@Dt", objLIBErLog.Dt)); objParamList.Add(new SqlParameter("@StackTrace", objLIBErLog.StackTrace)); objParamList.Add(new SqlParameter("@MethodName", objLIBErLog.MethodName)); objParamList.Add(new SqlParameter("@Username", objLIBErLog.Username)); objParamList.Add(new SqlParameter("@Msg", objLIBErLog.Msg)); objParamList.Add(new SqlParameter("@Source", objLIBErLog.Source)); objParamList.Add(new SqlParameter("@TargetSite", objLIBErLog.TargetSite)); objParamList.Add(new SqlParameter("@Data", objLIBErLog.Data)); objParamList.Add(new SqlParameter("@InnerEx", objLIBErLog.InnerEx)); objParamList.Add(new SqlParameter("@FullMsg", objLIBErLog.FullMsg)); objParamListOut.Add(new SqlParameter("@@Id", SqlDbType.Int)); //strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InsertErLog", objParamList, objParamListOut); strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InsertErLog", objParamList, objParamListOut, ref Result); //Result = clsESPSql.ExecuteSPNonQuery("SP_InsertErLog", objParamList); Packet.MessageId = Result; Packet.MessageResultset = strOutParamValues; } catch (Exception ex) { Packet.MessageId = -1; clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), false); } return(Packet); }
public DataSet importComboDataFill(string _IdField, string _Desc, string _tableNm, string _whrCon) { DataSet ds = new DataSet(); List <SqlParameter> objParamList = new List <SqlParameter>(); MyCLS.clsExecuteStoredProcSql clsESPSql = new MyCLS.clsExecuteStoredProcSql(); try { objParamList.Add(new SqlParameter("@IdField", _IdField)); objParamList.Add(new SqlParameter("@FieldDESC", _Desc)); objParamList.Add(new SqlParameter("@tableName", _tableNm)); objParamList.Add(new SqlParameter("@whrCon", _whrCon)); ds = clsESPSql.ExecuteSPDataSet("importComboData", objParamList); } catch (Exception ex) { return(null); } return(ds); }
//*******COPY IT TO USE BELOW FUNCTION - INSERT************ //try //{ // LIBtblmstBenchmark objLIBtblmstBenchmark = new LIBtblmstBenchmark(); // DALtblmstBenchmark objDALtblmstBenchmark = new DALtblmstBenchmark(); // MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket(); // objLIBtblmstBenchmark.id = txt.Text; // objLIBtblmstBenchmark.industryid = txt.Text; // objLIBtblmstBenchmark.bm1_1 = txt.Text; // objLIBtblmstBenchmark.bm1_2 = txt.Text; // objLIBtblmstBenchmark.bm2_1 = txt.Text; // objLIBtblmstBenchmark.bm2_2 = txt.Text; // objLIBtblmstBenchmark.bm3_1 = txt.Text; // objLIBtblmstBenchmark.bm3_2 = txt.Text; // objLIBtblmstBenchmark.currency = txt.Text; // tp.MessagePacket = objLIBtblmstBenchmark; // tp = objDALtblmstBenchmark.InserttblmstBenchmark(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 InserttblmstBenchmark(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 { LIBtblmstBenchmark objLIBtblmstBenchmark = new LIBtblmstBenchmark(); objLIBtblmstBenchmark = (LIBtblmstBenchmark)Packet.MessagePacket; objParamList.Add(new SqlParameter("@id", objLIBtblmstBenchmark.id)); objParamList.Add(new SqlParameter("@industryid", objLIBtblmstBenchmark.industryid)); objParamList.Add(new SqlParameter("@bm1_1", objLIBtblmstBenchmark.bm1_1)); objParamList.Add(new SqlParameter("@bm1_2", objLIBtblmstBenchmark.bm1_2)); objParamList.Add(new SqlParameter("@bm2_1", objLIBtblmstBenchmark.bm2_1)); objParamList.Add(new SqlParameter("@bm2_2", objLIBtblmstBenchmark.bm2_2)); objParamList.Add(new SqlParameter("@bm3_1", objLIBtblmstBenchmark.bm3_1)); objParamList.Add(new SqlParameter("@bm3_2", objLIBtblmstBenchmark.bm3_2)); objParamList.Add(new SqlParameter("@currency", objLIBtblmstBenchmark.currency)); objParamList.Add(new SqlParameter("@metric", objLIBtblmstBenchmark.metric)); objParamListOut.Add(new SqlParameter("@@id", SqlDbType.Int)); strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InserttblmstBenchmark", 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); }