public Result Save(PartyWiseItemRateDTO obj) { try { using (DbCommand cmd = Common.dbConn.GetStoredProcCommand("DETPartyWiseItemRateAdd")) { Common.dbConn.AddInParameter(cmd, "Id", DbType.Int32, obj.Id); Common.dbConn.AddInParameter(cmd, "AccountGroupMasId", DbType.Int32, obj.PartyName); Common.dbConn.AddInParameter(cmd, "ItemName", DbType.String, obj.ItemName); Common.dbConn.AddInParameter(cmd, "ItemCode", DbType.Int32, obj.ItemCode); Common.dbConn.AddInParameter(cmd, "PackingRate", DbType.Double, obj.PackingRate); Common.dbConn.AddInParameter(cmd, "PONo", DbType.String, obj.PONo); Common.dbConn.AddInParameter(cmd, "AmendmentNo", DbType.Int32, obj.AmendmentNo); if (obj.PODate == DateTime.MinValue) { Common.dbConn.AddInParameter(cmd, "PODate", DbType.Date, System.DBNull.Value); } else { Common.dbConn.AddInParameter(cmd, "PODate", DbType.Date, obj.PODate); } if (obj.AmendmentDate == DateTime.MinValue) { Common.dbConn.AddInParameter(cmd, "AmendmentDate", DbType.Date, System.DBNull.Value); } else { Common.dbConn.AddInParameter(cmd, "AmendmentDate", DbType.Date, obj.AmendmentDate); } Common.dbConn.AddInParameter(cmd, "PartNo", DbType.String, obj.PartNo); Common.dbConn.AddInParameter(cmd, "ToolSupplyForQty", DbType.Double, obj.ToolSupplyForQty); Common.dbConn.AddInParameter(cmd, "ToolRate", DbType.Double, obj.ToolRate); Common.dbConn.AddInParameter(cmd, "Tax", DbType.Double, obj.Tax); Common.dbConn.AddInParameter(cmd, "ToolNarr", DbType.String, obj.ToolNarr); Common.dbConn.AddInParameter(cmd, "ProcessName", DbType.String, obj.ProcessName); Common.dbConn.ExecuteNonQuery(cmd); return(new Result { Id = 1, Message = "Saved", ResultStatus = OperationStatus.SavedSuccessFully }); } } catch (Exception ex) { throw ex; } }
public Result Save(ERPDTOBase obj) { PartyWiseItemRateDTO account = obj as PartyWiseItemRateDTO; return(new PartyWiseItemRateDAL().Save(account)); }