public bool UpdateRecord(mdlTerritory ObjTerrority) { return ObjdalTerrority.UpdateRecord(ObjTerrority); }
public bool UpdateRecord(mdlTerritory ObjTerritory) { bool Update = false; try { if (con.State == ConnectionState.Open) { con.Close(); } SqlCommand cmd = new SqlCommand("stp_ERP_Territory_Crud", con); cmd.Parameters.Add("@pk_TerritoryId", SqlDbType.VarChar, 7).Value = ObjTerritory.pk_TerritoryId; cmd.Parameters.Add("@Description", SqlDbType.VarChar, 100).Value = ObjTerritory.Description; cmd.Parameters.Add("@TerritoryName", SqlDbType.VarChar, 25).Value = ObjTerritory.TerritoryName; cmd.Parameters.Add("@IsDeleted", SqlDbType.Bit).Value = ObjTerritory.IsDeleted; cmd.Parameters.Add("@Adduser", SqlDbType.VarChar, 25).Value = ObjTerritory.AddUser; cmd.Parameters.Add("@Fk_FMID", SqlDbType.VarChar, 9).Value = ObjTerritory.Fk_Fmid; cmd.Parameters.Add("@LoginComputer", SqlDbType.VarChar, 25).Value = ObjTerritory.LoginComp; cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 7).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 SaveRecord(mdlTerritory ObjTerrority) { return ObjdalTerrority.SaveRecord(ObjTerrority); }