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