public bool UpdateTeam(mdlTeam obj_mdlTeam)
{
return obj_dalTeam.UpdateTeam(obj_mdlTeam);
}
public bool UpdateTeam(mdlTeam obj_mdlTeam)
{
bool Update = false;
try
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
SqlCommand cmd = new SqlCommand("stp_ERP_Team_CRUD", con);
cmd.Parameters.Add("@pk_TeamID", SqlDbType.VarChar, 9).Value = obj_mdlTeam.Team_ID;
cmd.Parameters.Add("@Fk_GroupID", SqlDbType.VarChar, 20).Value = obj_mdlTeam.GroupID;
cmd.Parameters.Add("@Team_Name", SqlDbType.VarChar, 20).Value = obj_mdlTeam.TeamName;
cmd.Parameters.Add("@Description", SqlDbType.VarChar, 100).Value = obj_mdlTeam.Description;
cmd.Parameters.Add("@IsDiscontinue", SqlDbType.Bit).Value = obj_mdlTeam.IsDiscontinue;
cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 20).Value = obj_mdlTeam.AddUser;
cmd.Parameters.Add("@AddComputer", SqlDbType.VarChar, 20).Value = obj_mdlTeam.LoginComputer;
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 10).Value = "Update";
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
Update = true;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
Update = false;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return Update;
}
public bool SaveTeam(mdlTeam obj_mdlTeam)
{
return obj_dalTeam.SaveTeam(obj_mdlTeam);
}
