public Result SaveMSTDirectEntry(MSTDirectEntryDTO obj) { try { // DataSet ds = SqlHelper.ExecuteDataset(trans, CommandType.StoredProcedure, "InsertUpdatePreShipmentMaster", sqlParameter); using (DbCommand cmd = Common.dbConn.GetStoredProcCommand("MSTPurchaseBillSave")) { Common.dbConn.AddInParameter(cmd, "@Id", DbType.Int32, obj.Id); Common.dbConn.AddInParameter(cmd, "@SerialBillNo", DbType.String, obj.SerialBillNo); Common.dbConn.AddInParameter(cmd, "@BillNo", DbType.String, obj.BillNo); //Common.dbConn.AddInParameter(cmd, "@Supplier", DbType.Int32, obj.Supplier); Common.dbConn.AddInParameter(cmd, "@Narration", DbType.String, obj.Narration); if (obj.Entrydate == DateTime.MinValue) { Common.dbConn.AddInParameter(cmd, "@Entrydate", DbType.Date, System.DBNull.Value); } else { Common.dbConn.AddInParameter(cmd, "@Entrydate", DbType.Date, obj.Entrydate); } if (obj.BillDate == DateTime.MinValue) { Common.dbConn.AddInParameter(cmd, "@BillDate", DbType.Date, System.DBNull.Value); } else { Common.dbConn.AddInParameter(cmd, "@BillDate", DbType.Date, obj.BillDate); } Common.dbConn.AddInParameter(cmd, "@PurchaseCategy", DbType.Int32, obj.PurchaseCategy); Common.dbConn.AddInParameter(cmd, "@PurchaseType", DbType.Int32, obj.PurchaseType); Common.dbConn.AddInParameter(cmd, "@AccountGroupMasId", DbType.Int32, obj.PurchaseAcc); Common.dbConn.AddInParameter(cmd, "@TotalAmount", DbType.Decimal, obj.TotalAmount); Common.dbConn.AddInParameter(cmd, "@Type", DbType.Int16, 1); // Common.dbConn.AddInParameter(cmd, "@ExciseDuty", DbType.Double, obj.ExciseDuty); //Common.dbConn.ExecuteNonQuery(cmd); DataSet dsResult = Common.dbConn.ExecuteDataSet(cmd); return(new Result { Id = ((dsResult.Tables[0].Rows[0]["Result"])).ToInt(), Message = "Saved", ResultStatus = OperationStatus.SavedSuccessFully }); } } catch (Exception ex) { throw ex; } }
public Result SaveMSTPurchaseBill(ERPDTOBase obj) { MSTDirectEntryDTO account = obj as MSTDirectEntryDTO; return(new DirectEntryDAL().SaveMSTDirectEntry(account)); }