public bool AddMeasurementUnit(MeasurementUnitBO measurementUnit) { DBEgine objDbAccess = new DBEgine(); bool result = false; try { SqlParameter[] parms = new SqlParameter[4]; SqlParameter parmUnitID = new SqlParameter(); parmUnitID.Value = measurementUnit.UnitID; parmUnitID.SqlDbType = SqlDbType.Int; parmUnitID.Direction = ParameterDirection.Input; parmUnitID.ParameterName = "@UnitID"; parms[0] = parmUnitID; SqlParameter parmUnitDescription = new SqlParameter(); parmUnitDescription.Value = measurementUnit.UnitDescription; parmUnitDescription.SqlDbType = SqlDbType.VarChar; parmUnitDescription.Direction = ParameterDirection.Input; parmUnitDescription.ParameterName = "@UnitDescription"; parms[1] = parmUnitDescription; SqlParameter parmIsActive = new SqlParameter(); parmIsActive.Value = measurementUnit.IsActive; parmIsActive.SqlDbType = SqlDbType.Bit; parmIsActive.Direction = ParameterDirection.Input; parmIsActive.ParameterName = "@IsActive"; parms[2] = parmIsActive; SqlParameter parmCreatedUser = new SqlParameter(); parmCreatedUser.Value = measurementUnit.CreatedUser; parmCreatedUser.SqlDbType = SqlDbType.Int; parmCreatedUser.Direction = ParameterDirection.Input; parmCreatedUser.ParameterName = "@CreatedUser"; parms[3] = parmCreatedUser; objDbAccess.DBOpen(); if (objDbAccess.ExecNonQueryStoredProc("Inventory.SaveMeasurementUnit", parms) > 0) { result = true; } return result; } catch (Exception ex) { throw ex; } finally { objDbAccess.DBClose(); } }
private void buttonSave_Click(object sender, EventArgs e) { try { if (MeasuringUnit > 0 && !ScreenFunctions.Update) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_020"), false); return; } var measurementUnit = new MeasurementUnitBO(); measurementUnit.UnitID = MeasuringUnit; measurementUnit.UnitDescription = textBoxMesurementUnit.Text.Trim(); measurementUnit.IsActive = true; measurementUnit.CreatedUser = Common.User.UserId; var result = new MeasurementUnitDAL().AddMeasurementUnit(measurementUnit); if (result) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_011"), false); } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_010"), false); } } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_010"), true); } }