public bool UpdateRecord(mdlBricks ObjBricks) { return ObjdalBricks.UpdateRecord(ObjBricks); }
public bool UpdateRecord(mdlBricks ObjBricks) { bool Update = false; try { if (con.State == ConnectionState.Open) { con.Close(); } SqlCommand cmd = new SqlCommand("stp_ERP_Bricks_Crud", con); cmd.Parameters.Add("@pk_Brickid", SqlDbType.VarChar, 7).Value = ObjBricks.pk_Brickid; cmd.Parameters.Add("@Fk_TownId", SqlDbType.VarChar, 7).Value = ObjBricks.Fk_TownId; cmd.Parameters.Add("@Description", SqlDbType.VarChar, 100).Value = ObjBricks.Description; cmd.Parameters.Add("@BrickName", SqlDbType.VarChar, 25).Value = ObjBricks.BrickName; cmd.Parameters.Add("@IsDeleted", SqlDbType.Bit).Value = ObjBricks.IsDeleted; cmd.Parameters.Add("@Adduser", SqlDbType.VarChar, 25).Value = ObjBricks.AddUser; cmd.Parameters.Add("@LoginComputer", SqlDbType.VarChar, 25).Value = ObjBricks.LoginComp; cmd.Parameters.Add("@Fk_TerritoryID", SqlDbType.VarChar, 9).Value = ObjBricks.FkTerritoryID; 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(mdlBricks ObjBricks) { return ObjdalBricks.SaveRecord(ObjBricks); }