public Result SaveMSTIssueUser(MSTIssueMasterDTO obj) { try { // DataSet ds = SqlHelper.ExecuteDataset(trans, CommandType.StoredProcedure, "InsertUpdatePreShipmentMaster", sqlParameter); using (DbCommand cmd = Common.dbConn.GetStoredProcCommand("MSTIssueMasterSave")) { Common.dbConn.AddInParameter(cmd, "@OrderId", DbType.Int32, obj.Id); Common.dbConn.AddInParameter(cmd, "@OrderNo", DbType.String, obj.OrderNo); if (obj.Orderdate == DateTime.MinValue) { Common.dbConn.AddInParameter(cmd, "@Orderdate", DbType.Date, System.DBNull.Value); } else { Common.dbConn.AddInParameter(cmd, "@Orderdate", DbType.Date, obj.Orderdate); } Common.dbConn.AddInParameter(cmd, "@Remarks", DbType.String, obj.Remarks); Common.dbConn.AddInParameter(cmd, "@IssueTo", DbType.Int32, obj.IssueTo); // Common.dbConn.AddInParameter(cmd, "@ExciseDuty", DbType.Double, obj.ExciseDuty); //Common.dbConn.ExecuteNonQuery(cmd); DataSet dsResult = Common.dbConn.ExecuteDataSet(cmd); Result res = new Result { Id = ((dsResult.Tables[0].Rows[0]["Result"])).ToInt(), Message = "Saved", ResultStatus = OperationStatus.SavedSuccessFully }; res.Message = res.Id.ToString(); using (DbCommand cmdUpdateSno = Common.dbConn.GetStoredProcCommand("UpdateOrderSno")) { Common.dbConn.AddInParameter(cmdUpdateSno, "@OrderId", DbType.Int32, res.Id); Common.dbConn.AddInParameter(cmdUpdateSno, "@OrderNo", DbType.String, res.Message); Common.dbConn.ExecuteNonQuery(cmdUpdateSno); } return(res); } } catch (Exception ex) { throw ex; } }
public Result SaveMSTIssueUser(ERPDTOBase obj) { MSTIssueMasterDTO account = obj as MSTIssueMasterDTO; return(new IssueMasterDAL().SaveMSTIssueUser(account)); }