public Result SaveSaleOrderReceivingEntryDTOMst(MSTSaleOrderReceivingEntryDTO obj)
{
try
{
using (DbCommand cmd = Common.dbConn.GetStoredProcCommand("MSTSaleOrderReceivingSave"))
{
Common.dbConn.AddInParameter(cmd, "ID", 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, "PartyName", DbType.Int32, obj.PartyName);
Common.dbConn.AddInParameter(cmd, "Remarks", DbType.String, obj.Remarks);
Common.dbConn.AddInParameter(cmd, "Active", DbType.Boolean, obj.Active);
Common.dbConn.AddInParameter(cmd, "Total", DbType.Double, obj.Total);
//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 SaveSaleOrderReceivingEntryDTOMst(ERPDTOBase obj)
{
MSTSaleOrderReceivingEntryDTO account = obj as MSTSaleOrderReceivingEntryDTO;
return(new SaleOrderReceivingEntryDAL().SaveSaleOrderReceivingEntryDTOMst(account));
}
