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));
}
