//*******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 - 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);
}
protected int AddOrgInfo(string fyear, decimal turnover, decimal headcount, decimal profit, decimal wagebill, decimal attrtion, string industry)
{
int ret = 0;
try
{
LIBtblmstOrgInfo objLIBtblmstOrgInfo = new LIBtblmstOrgInfo();
DALtblmstOrgInfo objDALtblmstOrgInfo = new DALtblmstOrgInfo();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblmstOrgInfo.id = -1;
objLIBtblmstOrgInfo.orgid = Convert.ToInt32(Session["orgid"].ToString());
objLIBtblmstOrgInfo.year = fyear;
objLIBtblmstOrgInfo.turnover = turnover;
objLIBtblmstOrgInfo.HeadCount = headcount;
objLIBtblmstOrgInfo.Profit = profit;
objLIBtblmstOrgInfo.WageBill = wagebill;
objLIBtblmstOrgInfo.Attrtion = attrtion;
objLIBtblmstOrgInfo.createdBy = User.Identity.Name;
objLIBtblmstOrgInfo.dt = DateTime.Now.ToShortDateString();
objLIBtblmstOrgInfo.Currency = ddlCurrency.SelectedItem.Text;
objLIBtblmstOrgInfo.Industry = industry;
tp.MessagePacket = objLIBtblmstOrgInfo;
tp = objDALtblmstOrgInfo.InserttblmstOrgInfo(tp);
Session["cur"] = ddlCurrency.SelectedItem.Text;
if (tp.MessageId > -1)
{
string[] strOutParamValues = (string[])tp.MessageResultset;
ret = 1;
}
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
return(ret);
}
