public void EditLoginfo(BOLLoinfo LoginfoBO, string sql)
{
using (con = DBaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter parloginId, parpassword, parcompanyid, parplantid;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
parloginId = cmd.Parameters.Add("@User_LoginId", SqlDbType.NVarChar, 50);
parpassword = cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 50);
parcompanyid = cmd.Parameters.Add("@Company_ID", SqlDbType.Int);
parplantid = cmd.Parameters.Add("@plant_Id", SqlDbType.Int);
parloginId.Value = LoginfoBO.userloginID;
parpassword.Value = LoginfoBO.Password;
parcompanyid.Value = LoginfoBO.CompanyId;
parplantid.Value = LoginfoBO.PlantId;
cmd.ExecuteNonQuery();
}
}
public void editloginfo(BOLLoinfo loginfoBO)
{
string sql = "Edit_Loginfo";
loginfoDA.EditLoginfo(loginfoBO, sql);
}
public void insertloginfo(BOLLoinfo loginfoBO)
{
string sql = "Insert_Loginfo";
loginfoDA.InsertLoginfo(loginfoBO, sql);
}
