public void insertStatemaster(BOLStateMaster statemasterBO, string sql)
{
using (con = DBaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter parstateid, parstatename, parplantcode, parcompanycode;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
parstateid = cmd.Parameters.Add("@state_Id", SqlDbType.Int);
parstatename = cmd.Parameters.Add("@state_Name", SqlDbType.NVarChar, 25);
// parplantcode = cmd.Parameters.Add("@Plant_Code", SqlDbType.Int);
parcompanycode = cmd.Parameters.Add("@Company_Code", SqlDbType.Int);
parstateid.Value = statemasterBO.stateId;
parstatename.Value = statemasterBO.stateName;
// parplantcode.Value = statemasterBO.Plantcode;
parcompanycode.Value = statemasterBO.Companycode;
cmd.ExecuteNonQuery();
}
}
public void insertstatemaster(BOLStateMaster statemasterBO)
{
string sql = "Insert_StateMaster";
statemasterDA.insertStatemaster(statemasterBO, sql);
}
