private string dataBaseAction(Common.DataBaseOperation DBAction)
{
string sMsg = string.Empty;
GenericMaster objData = this.Copy <GenericMaster>();
objData.OperationFlag = DBAction;
DataBaseResultSet DBRS = BLL.BllClient.objBllClient.Save <GenericMaster>(Common.DataSourceTypes.GenericMasterSave, objData);
sMsg = CommonModel.GetOperationMessage <GenericMaster>(DBRS, objData);
if (DBRS.ErrorCode == 0)
{
updateList(DBAction, objData);
this.ResetData();
}
return(sMsg);
}
public static string GetOperationMessage <T>(DataBaseResultSet DBRS, T objData) where T : IModel, new()
{
if (ShowDataBaseMsg)
{
return(DBRS.ErrorMessage);
}
else
{
if (DBRS.ErrorCode == 0)
{
return((objData.OperationFlag == DataBaseOperation.Save) ? SaveMsg
: ((objData.OperationFlag == DataBaseOperation.Update) ? UpdateMsg : DeleteMsg));
}
else
{
return(ErrorMessage);
}
}
return(string.Empty);
}
public static T_ErrorDesc GetErrorLog(DataBaseResultSet DBSet, DataSourceTypes DST, string sXmlData)
{
T_ErrorDesc objData = new T_ErrorDesc();
objData.CategoryId = 0;
objData.ClientIPAddress = string.Empty;
objData.EmpNo = string.Empty;
objData.ErrorData = sXmlData;
objData.ErrorDate = DateTime.Now;
objData.ErrorId = DBSet.ErrorCode;
objData.ErrorLineNo = 0;
objData.ErrorMsg = DBSet.ErrorMessage;
objData.ErrorType = "Database Error";
objData.EventCode = 0;
objData.MethodCode = (int)DST;
objData.MethodName = DST.ToString();
objData.MethodTrace = string.Empty;
objData.PageCode = 0;
objData.PageName = string.Empty;
return(objData);
}
public DataBaseResultSet Save(string sQuery, CommandType cmdtype, DbParameter[] parms)
{
DbCommand objCommand = GetDbCommand(sQuery);
DataBaseResultSet DBSet = new DataBaseResultSet();
if (objCommand == null)
{
return(DBSet);
}
objCommand.CommandType = cmdtype;
objCommand.Parameters.AddRange(parms);
objCommand.ExecuteNonQuery();
if (objCommand.Parameters["Message"].Value != null)
{
DBSet.ErrorMessage = objCommand.Parameters["Message"].Value.ToString();
}
if (objCommand.Parameters["ErrorCode"].Value != null)
{
DBSet.ErrorCode = Convert.ToInt32(objCommand.Parameters["ErrorCode"].Value);
}
objConnection.Close();
return(DBSet);
}
public DataBaseResultSet Save <T>(DataSourceTypes DataSourceTypes, T objFilter) where T : class, IModel, new()
{
DataBaseResultSet nResult = new DataBaseResultSet();
switch (DataSourceTypes)
{
case Common.DataSourceTypes.T_ErrorDescSave:
nResult = objDAL.SaveT_ErrorDesc(objFilter);
break;
case Common.DataSourceTypes.T_MstAccountSave:
nResult = objDAL.SaveT_MstAccount(objFilter);
break;
case Common.DataSourceTypes.T_MstAccountMasterSave:
nResult = objDAL.SaveT_MstAccountMaster(objFilter);
break;
case Common.DataSourceTypes.T_MstBrokerSave:
nResult = objDAL.SaveT_MstBroker(objFilter);
break;
case Common.DataSourceTypes.T_MstCheckerSave:
nResult = objDAL.SaveT_MstChecker(objFilter);
break;
case Common.DataSourceTypes.T_MstCompanySave:
nResult = objDAL.SaveT_MstCompany(objFilter);
break;
case Common.DataSourceTypes.T_MstFinancialYearSave:
nResult = objDAL.SaveT_MstFinancialYear(objFilter);
break;
case Common.DataSourceTypes.T_MstGroupSave:
nResult = objDAL.SaveT_MstGroup(objFilter);
break;
case Common.DataSourceTypes.T_MstQualitySave:
nResult = objDAL.SaveT_MstQuality(objFilter);
break;
case Common.DataSourceTypes.T_MstRoleSave:
nResult = objDAL.SaveT_MstRole(objFilter);
break;
case Common.DataSourceTypes.T_MstTransportSave:
nResult = objDAL.SaveT_MstTransport(objFilter);
break;
case Common.DataSourceTypes.T_MstWeaverSave:
nResult = objDAL.SaveT_MstWeaver(objFilter);
break;
case Common.DataSourceTypes.T_TranCashSave:
nResult = objDAL.SaveT_TranCash(objFilter);
break;
case Common.DataSourceTypes.T_TranJournalSave:
nResult = objDAL.SaveT_TranJournal(objFilter);
break;
case Common.DataSourceTypes.T_TranPurchaseOrderSave:
nResult = objDAL.SaveT_TranPurchaseOrder(objFilter);
break;
case Common.DataSourceTypes.T_TranSalesBillSave:
nResult = objDAL.SaveT_TranSalesBill(objFilter);
break;
case Common.DataSourceTypes.T_TranSalesOrderSave:
nResult = objDAL.SaveT_TranSalesOrder(objFilter);
break;
}
if (nResult.ErrorCode != 0)
{
checkAndWriteDatabaseException <T>(objFilter, nResult, DataSourceTypes);
}
return(nResult);
}
private void checkAndWriteDatabaseException <T>(T objData, DataBaseResultSet DBSet, DataSourceTypes DST) where T : class, IModel, new()
{
T_ErrorDesc objErrorData = WriteServiceErrorLog.GetErrorLog(DBSet, DST, objData.GetXmlString());
string sMsg = string.Empty;
DataBaseResultSet DBSetSaveError = objDAL.SaveT_ErrorDesc(objData);
}
public DataBaseResultSet Save <T>(DataSourceTypes DataSourceTypes, T objFilter) where T : class, IModel, new()
{
DataBaseResultSet nResult = new DataBaseResultSet();
switch (DataSourceTypes)
{
case Common.DataSourceTypes.SalesDetailSave:
nResult = objDAL.SaveSalesDetail(objFilter);
break;
case Common.DataSourceTypes.AreaMasterSave:
nResult = objDAL.SaveAreaMaster(objFilter);
break;
case Common.DataSourceTypes.oVatDetailSave:
nResult = objDAL.SaveoVatDetail(objFilter);
break;
case Common.DataSourceTypes.AutoSetupSave:
nResult = objDAL.SaveAutoSetup(objFilter);
break;
case Common.DataSourceTypes.CustomerMasterSave:
nResult = objDAL.SaveCustomerMaster(objFilter);
break;
case Common.DataSourceTypes.ErrorDescSave:
nResult = objDAL.SaveErrorDesc(objFilter);
break;
case Common.DataSourceTypes.DoctorMasterSave:
nResult = objDAL.SaveDoctorMaster(objFilter);
break;
case Common.DataSourceTypes.FirmMasterSave:
nResult = objDAL.SaveFirmMaster(objFilter);
break;
case Common.DataSourceTypes.DiseaseDetailSave:
nResult = objDAL.SaveDiseaseDetail(objFilter);
break;
case Common.DataSourceTypes.AdjDetailSave:
nResult = objDAL.SaveAdjDetail(objFilter);
break;
case Common.DataSourceTypes.ShiftMasterSave:
nResult = objDAL.SaveShiftMaster(objFilter);
break;
case Common.DataSourceTypes.DiseaseMasterSave:
nResult = objDAL.SaveDiseaseMaster(objFilter);
break;
case Common.DataSourceTypes.CrDrDetailSave:
nResult = objDAL.SaveCrDrDetail(objFilter);
break;
case Common.DataSourceTypes.VatDetailSave:
nResult = objDAL.SaveVatDetail(objFilter);
break;
case Common.DataSourceTypes.GroupMasterSave:
nResult = objDAL.SaveGroupMaster(objFilter);
break;
case Common.DataSourceTypes.MapProductSave:
nResult = objDAL.SaveMapProduct(objFilter);
break;
case Common.DataSourceTypes.OldBillMasterSave:
nResult = objDAL.SaveOldBillMaster(objFilter);
break;
case Common.DataSourceTypes.XDetailSave:
nResult = objDAL.SaveXDetail(objFilter);
break;
case Common.DataSourceTypes.OrderDetailSave:
nResult = objDAL.SaveOrderDetail(objFilter);
break;
case Common.DataSourceTypes.DeletedDetailSave:
nResult = objDAL.SaveDeletedDetail(objFilter);
break;
case Common.DataSourceTypes.TallyMasterSave:
nResult = objDAL.SaveTallyMaster(objFilter);
break;
case Common.DataSourceTypes.OBillMasterSave:
nResult = objDAL.SaveOBillMaster(objFilter);
break;
case Common.DataSourceTypes.BranchStockSave:
nResult = objDAL.SaveBranchStock(objFilter);
break;
case Common.DataSourceTypes.XMasterSave:
nResult = objDAL.SaveXMaster(objFilter);
break;
case Common.DataSourceTypes.oBatchMasterSave:
nResult = objDAL.SaveoBatchMaster(objFilter);
break;
case Common.DataSourceTypes.AccountMasterSave:
nResult = objDAL.SaveAccountMaster(objFilter);
break;
case Common.DataSourceTypes.CityMasterSave:
nResult = objDAL.SaveCityMaster(objFilter);
break;
case Common.DataSourceTypes.OrderMasterSave:
nResult = objDAL.SaveOrderMaster(objFilter);
break;
case Common.DataSourceTypes.CompanyDetailSave:
nResult = objDAL.SaveCompanyDetail(objFilter);
break;
case Common.DataSourceTypes.MiscRcptPmtSave:
nResult = objDAL.SaveMiscRcptPmt(objFilter);
break;
case Common.DataSourceTypes.CategoryMasterSave:
nResult = objDAL.SaveCategoryMaster(objFilter);
break;
case Common.DataSourceTypes.CompanyMasterSave:
nResult = objDAL.SaveCompanyMaster(objFilter);
break;
case Common.DataSourceTypes.PurDetailSave:
nResult = objDAL.SavePurDetail(objFilter);
break;
case Common.DataSourceTypes.ConfigSave:
nResult = objDAL.SaveConfig(objFilter);
break;
case Common.DataSourceTypes.GenericMasterSave:
nResult = objDAL.SaveGenericMaster(objFilter);
break;
case Common.DataSourceTypes.SalesManMasterSave:
nResult = objDAL.SaveSalesManMaster(objFilter);
break;
case Common.DataSourceTypes.BillMasterSave:
nResult = objDAL.SaveBillMaster(objFilter);
break;
case Common.DataSourceTypes.ProductMasterSave:
nResult = objDAL.SaveProductMaster(objFilter);
break;
case Common.DataSourceTypes.OtherAddSave:
nResult = objDAL.SaveOtherAdd(objFilter);
break;
case Common.DataSourceTypes.PatientMasterSave:
nResult = objDAL.SavePatientMaster(objFilter);
break;
case Common.DataSourceTypes.BatchMasterSave:
nResult = objDAL.SaveBatchMaster(objFilter);
break;
case Common.DataSourceTypes.PreFormatSave:
nResult = objDAL.SavePreFormat(objFilter);
break;
case Common.DataSourceTypes.UserMasterSave:
nResult = objDAL.SaveUserMaster(objFilter);
break;
case Common.DataSourceTypes.PrintFormatSave:
nResult = objDAL.SavePrintFormat(objFilter);
break;
case Common.DataSourceTypes.ReceivePaymentSave:
nResult = objDAL.SaveReceivePayment(objFilter);
break;
case Common.DataSourceTypes.AddressBookSave:
nResult = objDAL.SaveAddressBook(objFilter);
break;
}
if (nResult.ErrorCode != 0)
{
checkAndWriteDatabaseException <T>(objFilter, nResult, DataSourceTypes);
}
return(nResult);
}
