public void ProcucerprocurementImport(BOLRateChart rateBO)
{
try
{
using (con = DBaccess.GetConnection())
{
string sql = "update_producerprocurementImport_sessions";
SqlCommand cmd = new SqlCommand();
cmd.CommandTimeout = 200;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
SqlParameter p, c, fd, ses;
p = cmd.Parameters.Add("@plantcode", SqlDbType.VarChar, 50);
c = cmd.Parameters.Add("@companycode", SqlDbType.VarChar, 50);
fd = cmd.Parameters.Add("@frdate", SqlDbType.Date);
ses = cmd.Parameters.Add("@sess", SqlDbType.VarChar, 15);
p.Value = rateBO.Plantcode;
c.Value = rateBO.Companycode;
fd.Value = rateBO.Fromdate;
ses.Value = rateBO.Sess;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
}
}
public void deleteimport(BOLRateChart rateBO, string sql)
{
try
{
using (con = DBaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
cmd.CommandTimeout = 200;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
SqlParameter p, c, fd, td;
p = cmd.Parameters.Add("@plantcode", SqlDbType.VarChar, 50);
c = cmd.Parameters.Add("@companycode", SqlDbType.VarChar, 50);
fd = cmd.Parameters.Add("@frdate", SqlDbType.Date);
td = cmd.Parameters.Add("@todate", SqlDbType.Date);
p.Value = rateBO.Plantcode;
c.Value = rateBO.Companycode;
fd.Value = rateBO.Fromdate;
td.Value = rateBO.Todate;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
}
}
public void actualdeleteimportsess(BOLRateChart rateBO)
{
try
{
string sql = "update_actualprocurementImport_sessions";
impdbDA.importsess(rateBO, sql);
}
catch
{
}
}
public void EditUpdateRatechart(BOLRateChart rateBOL, string sql)
{
using (con = dbaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter ptid, pchartname, pfromvale, ptovalue, prate, pcommissionamount, pbonusamount, pcompanycode, pplantcode;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = con;
int inser1;
ptid = cmd.Parameters.Add("@tid", SqlDbType.Int);
pchartname = cmd.Parameters.Add("@chartname", SqlDbType.NVarChar, 30);
pfromvale = cmd.Parameters.Add("@fromvale", SqlDbType.Float);
ptovalue = cmd.Parameters.Add("@tovalue", SqlDbType.Float);
prate = cmd.Parameters.Add("@rate", SqlDbType.Float);
pcommissionamount = cmd.Parameters.Add("@commissionamount", SqlDbType.Float);
pbonusamount = cmd.Parameters.Add("@bonusamount", SqlDbType.Float);
pcompanycode = cmd.Parameters.Add("@companycode", SqlDbType.NVarChar, 30);
pplantcode = cmd.Parameters.Add("@plantcode", SqlDbType.NVarChar, 30);
ptid.Value = rateBOL.Tid;
pchartname.Value = rateBOL.Chartname;
pfromvale.Value = rateBOL.Fromrangevalue;
ptovalue.Value = rateBOL.Torangrvalue;
prate.Value = rateBOL.Rate;
pcommissionamount.Value = rateBOL.Commissionamount;
pbonusamount.Value = rateBOL.Bonusamount;
pcompanycode.Value = rateBOL.Companycode;
pplantcode.Value = rateBOL.Plantcode;
inser1 = cmd.ExecuteNonQuery();
if (inser1 == 1)
{
i++;
}
else
{
i++;
}
}
}
public void DeleteRow(BOLRateChart rateBOL, string sql)
{
using (con = dbaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter ptid, pchartname, pflag, pcompanycode, pplantcode;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = con;
int inser;
ptid = cmd.Parameters.Add("@tid", SqlDbType.Int);
pchartname = cmd.Parameters.Add("@chartname", SqlDbType.NVarChar, 30);
pflag = cmd.Parameters.Add("@Flag", SqlDbType.Int);
pcompanycode = cmd.Parameters.Add("@companycode", SqlDbType.NVarChar, 30);
pplantcode = cmd.Parameters.Add("@plantcode", SqlDbType.NVarChar, 30);
ptid.Value = rateBOL.Tid;
pchartname.Value = rateBOL.Chartname;
pflag.Value = rateBOL.Flag;
pplantcode.Value = rateBOL.Plantcode;
pcompanycode.Value = rateBOL.Companycode;
inser = cmd.ExecuteNonQuery();
if (inser == 1)
{
i++;
// WebMsgBox.Show("RateChart Delete Successfully...");
}
else
{
i++;
}
}
}
public void InsertData(BOLRateChart rateBOL, string Sql)
{
using (con = dbaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter ptid, pcharttype, pmilknature, pstateid, pminfat, pminsnf, pfromdate, ptodate, pchartname, pfromvale, ptovalue, prate, pcommissionamount, pbonusamount, pcompanycode, pplantcode;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = Sql;
cmd.Connection = con;
int inser;
ptid = cmd.Parameters.Add("@tid", SqlDbType.Int);
pcharttype = cmd.Parameters.Add("@charttype", SqlDbType.NVarChar, 30);
pmilknature = cmd.Parameters.Add("@milknature", SqlDbType.NVarChar, 30);
pstateid = cmd.Parameters.Add("@stateid", SqlDbType.Int);
pminfat = cmd.Parameters.Add("@minfat", SqlDbType.Float);
pminsnf = cmd.Parameters.Add("@minsnf", SqlDbType.Float);
pfromdate = cmd.Parameters.Add("@fromdate", SqlDbType.DateTime);
ptodate = cmd.Parameters.Add("@todate", SqlDbType.DateTime);
pchartname = cmd.Parameters.Add("@chartname", SqlDbType.NVarChar, 30);
pfromvale = cmd.Parameters.Add("@fromvale", SqlDbType.Float);
ptovalue = cmd.Parameters.Add("@tovalue", SqlDbType.Float);
prate = cmd.Parameters.Add("@rate", SqlDbType.Float);
pcommissionamount = cmd.Parameters.Add("@commissionamount", SqlDbType.Float);
pbonusamount = cmd.Parameters.Add("@bonusamount", SqlDbType.Float);
pcompanycode = cmd.Parameters.Add("@companycode", SqlDbType.NVarChar, 30);
pplantcode = cmd.Parameters.Add("@plantcode", SqlDbType.NVarChar, 30);
ptid.Value = rateBOL.Tid;
pcharttype.Value = rateBOL.Charttype;
pmilknature.Value = rateBOL.Milknature;
pstateid.Value = rateBOL.Stateid;
pminfat.Value = rateBOL.Minfat;
pminsnf.Value = rateBOL.Minsnf;
pfromdate.Value = rateBOL.Fromdate;
ptodate.Value = rateBOL.Todate;
pchartname.Value = rateBOL.Chartname;
pfromvale.Value = rateBOL.Fromrangevalue;
ptovalue.Value = rateBOL.Torangrvalue;
prate.Value = rateBOL.Rate;
pcommissionamount.Value = rateBOL.Commissionamount;
pbonusamount.Value = rateBOL.Bonusamount;
pplantcode.Value = rateBOL.Plantcode;
pcompanycode.Value = rateBOL.Companycode;
inser = cmd.ExecuteNonQuery();
if (inser == 1)
{
i++;
}
else
{
i++;
}
}
}
public void DlelteRow(BOLRateChart ratechartBOL)
{
Sqlstr = "Delete_Ratechart";
ratechartDAL.DeleteRow(ratechartBOL, Sqlstr);
}
public void EditUpdateRatechart(BOLRateChart ratechartBOL)
{
Sqlstr = "Udate_EditRatechart";
ratechartDAL.EditUpdateRatechart(ratechartBOL, Sqlstr);
}
public void InsertRatechartData(BOLRateChart ratechartBOL)
{
Sqlstr = "Insert_Ratechart";
ratechartDAL.InsertData(ratechartBOL, Sqlstr);
}
public void deleteimport(BOLRateChart rateBO)
{
string sql = "update_procurementImport";
impdbDA.deleteimport(rateBO, sql);
}
