public bool UpdateRecord(mdlTown ObjTown) { return ObjdalTown.UpdateRecord(ObjTown); }
public bool UpdateRecord(mdlTown ObjTown) { bool Update = false; try { if (con.State == ConnectionState.Open) { con.Close(); } SqlCommand cmd = new SqlCommand("stp_ERP_Town_Crud", con); cmd.Parameters.Clear(); cmd.Parameters.Add("@pk_Townid", SqlDbType.VarChar, 7).Value = ObjTown.pk_Townid; cmd.Parameters.Add("@TownName", SqlDbType.VarChar, 25).Value = ObjTown.TownName; cmd.Parameters.Add("@TownType", SqlDbType.VarChar, 25).Value = ObjTown.TownType; cmd.Parameters.Add("@Adduser", SqlDbType.VarChar, 25).Value = ObjTown.AddUser; cmd.Parameters.Add("@Description", SqlDbType.VarChar, 100).Value = ObjTown.Description; cmd.Parameters.Add("@IsDeleted", SqlDbType.Bit).Value = ObjTown.IsDeleted; cmd.Parameters.Add("@LoginComputer", SqlDbType.VarChar, 25).Value = ObjTown.LoginComputer; 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(mdlTown ObjTown) { return ObjdalTown.SaveRecord(ObjTown); }