public string insertroutmaster(BOLroutmaster routmasterBO)
{
string mes = string.Empty;
string sql = "insert_Routmaster";
mes = routmasterDA.insertRoutmaster(routmasterBO, sql);
return(mes);
}
public string insertRoutmaster(BOLroutmaster routmasterBO, string sql)
{
using (con = DBaccess.GetConnection())
{
string message = String.Empty;
int result = 0;
SqlCommand cmd = new SqlCommand();
SqlParameter parroutid, parroutname, partotdistance, paraddeddate, parstatus, parcompanyid, parplantid, parmess, parresult, parlstatus, parphoneno;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
parroutid = cmd.Parameters.Add("@route_Id", SqlDbType.Int);
parroutname = cmd.Parameters.Add("@route_Name", SqlDbType.NVarChar, 50);
partotdistance = cmd.Parameters.Add("@tot_Distance", SqlDbType.Int);
paraddeddate = cmd.Parameters.Add("@added_Date", SqlDbType.DateTime);
parstatus = cmd.Parameters.Add("@status", SqlDbType.Bit);
parlstatus = cmd.Parameters.Add("@Lstatus", SqlDbType.Bit);
parphoneno = cmd.Parameters.Add("@phoneno", SqlDbType.NVarChar, 15);
parcompanyid = cmd.Parameters.Add("@Company_Code", SqlDbType.Int);
parplantid = cmd.Parameters.Add("@Plant_Code", SqlDbType.Int);
parmess = cmd.Parameters.Add("@mess", SqlDbType.Char, 500);
cmd.Parameters["@mess"].Direction = ParameterDirection.Output;
parresult = cmd.Parameters.Add("@res", SqlDbType.Int);
cmd.Parameters["@res"].Direction = ParameterDirection.Output;
parroutid.Value = routmasterBO.routId;
parroutname.Value = routmasterBO.routName;
partotdistance.Value = routmasterBO.totDistance;
paraddeddate.Value = routmasterBO.addedDate;
parstatus.Value = routmasterBO.status;
parlstatus.Value = routmasterBO.status;
parcompanyid.Value = routmasterBO.Companyid;
parplantid.Value = routmasterBO.Plantid;
parphoneno.Value = routmasterBO.Phoneno;
cmd.ExecuteNonQuery();
message = (string)cmd.Parameters["@mess"].Value;
result = (int)cmd.Parameters["@res"].Value;
con.Close();
if (result == 1)
{
//WebMsgBox.Show(message);
return(message);
}
else
{
//WebMsgBox.Show(message);
return(message);
}
return(message);
}
}
public void deleteRoutmaster(BOLroutmaster routmasterBO, string sql)
{
using (con = DBaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter parroutid;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = con;
parroutid = cmd.Parameters.Add("@rout_id", SqlDbType.Int);
parroutid.Value = routmasterBO.routId;
cmd.ExecuteNonQuery();
}
}
public void deleteroutmaster(BOLroutmaster routmasterBO)
{
string sql = "delete_Routmaster";
routmasterDA.deleteRoutmaster(routmasterBO, sql);
}
