public UnitOfMeasure AddUnitOfMeasure(UnitOfMeasure oUnitOfMeasure) { try { int operationType = Convert.ToInt32(oUnitOfMeasure.UnitID == 0 ? OperationType.Insert : OperationType.Update); using (IDbConnection con = new SqlConnection(AppSettings.ConnectionStrings)) { if (con.State == ConnectionState.Closed) { con.Open(); } var oUnitOfMeasureList = con.Query <UnitOfMeasure>("sp_UnitOfMeasure", _unitOfMeasure.SetParameters(oUnitOfMeasure, operationType), commandType: CommandType.StoredProcedure); if (oUnitOfMeasureList != null && oUnitOfMeasureList.Count() > 0) { _unitOfMeasure = oUnitOfMeasureList.FirstOrDefault(); } } } catch (Exception ex) { _psgc.Message = ex.Message; } return(_unitOfMeasure); }
public UnitOfMeasure GetUnitOfMeasure(int unitId) { _unitOfMeasure = new UnitOfMeasure() { UnitID = unitId }; try { int operationType = Convert.ToInt32(OperationType.SelectSpecific); using (IDbConnection con = new SqlConnection(AppSettings.ConnectionStrings)) { if (con.State == ConnectionState.Closed) { con.Open(); } var oUnitOfMeasure = con.Query <UnitOfMeasure>("sp_UnitOfMeasure", _unitOfMeasure.SetParameters(_unitOfMeasure, operationType), commandType: CommandType.StoredProcedure).ToList(); if (oUnitOfMeasure != null && oUnitOfMeasure.Count() > 0) { _unitOfMeasure = oUnitOfMeasure.SingleOrDefault(); } } } catch (Exception ex) { _psgc.Message = ex.Message; } return(_unitOfMeasure); }
public string Delete(int unitId) { string message = ""; try { _unitOfMeasure = new UnitOfMeasure() { UnitID = unitId }; using (IDbConnection con = new SqlConnection(AppSettings.ConnectionStrings)) { if (con.State == ConnectionState.Closed) { con.Open(); } var oUnitOfMeasure = con.Query <UnitOfMeasure>("sp_UnitOfMeasure", _unitOfMeasure.SetParameters(_unitOfMeasure, (int)OperationType.Delete), commandType: CommandType.StoredProcedure); if (oUnitOfMeasure != null && oUnitOfMeasure.Count() > 0) { _unitOfMeasure = oUnitOfMeasure.FirstOrDefault(); message = "Data Deleted!"; } } } catch (Exception ex) { message = ex.Message; } return(message); }