public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[6];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@FIRId", FIRId);
parrSP[2] = new SqlParameter("@HasBeenReported", HasBeenReported);
parrSP[3] = new SqlParameter("@PoliceStation", PoliceStation);
parrSP[4] = new SqlParameter("@StationDiaryNo", StationDiaryNo);
parrSP[5] = new SqlParameter("@DtStationDiary", DtStationDiary);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspFIR", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[7];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@ModelVersionId", ModelVersionId);
parrSP[2] = new SqlParameter("@ModelId", Model.ModelId);
parrSP[3] = new SqlParameter("@ModelVersion", Default);
parrSP[4] = new SqlParameter("@EngineCapacity", EngineCapacity);
parrSP[5] = new SqlParameter("@FuelCategory", FuelCategory);
parrSP[6] = new SqlParameter("@Excess", Excess);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspModelVersion", parrSP);
ds.Tables[0].TableName = "ModelVersion";
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mBillId = this.Identity.New();
}
SqlParameter[] parrSP = GetParameters(pTransactionType);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspBill", parrSP);
if (BillDetails.IsDirty)
{
foreach (BillDetail fss in this.BillDetails.Values)
{
fss.Bill = this;
fss.Transaction(pTransactionType);
}
}
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[7];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@FeeScheduleSlabId", FeeScheduleSlabId);
parrSP[2] = new SqlParameter("@FeeScheduleId", FeeSchedule.FeeScheduleId);
parrSP[3] = new SqlParameter("@SlabFrom", SlabFrom);
parrSP[4] = new SqlParameter("@SlabUpto", SlabUpto);
parrSP[5] = new SqlParameter("@Fee", Fee);
parrSP[6] = new SqlParameter("@ReInspectionFee", ReInspectionFee);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspFeeScheduleSlab", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mVehicleCategoryId = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[3];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@VehicleCategoryId", VehicleCategoryId);
parrSP[2] = new SqlParameter("@VehicleCategory", Default);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspVehicleCategory", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (mPartRateId <= 0)
{
mPartRateId = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[5];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@PartRateId", PartRateId);
parrSP[2] = new SqlParameter("@PartId", Part.PartId);
parrSP[3] = new SqlParameter("@Rate", Rate);
parrSP[4] = new SqlParameter("@DtWEF", DtWEF);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspPartRate", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mAccidentId = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[7];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@AccidentId", AccidentId);
parrSP[2] = new SqlParameter("@DtAccident", DtAccident);
parrSP[3] = new SqlParameter("@PlaceOfAccident", PlaceOfAccident);
parrSP[4] = new SqlParameter("@DtInstructions", DtInstructions);
parrSP[5] = new SqlParameter("@DtSurvey", DtSurvey);
parrSP[6] = new SqlParameter("@DtReceiptSSR", DtReceiptSSR);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspAccident", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[7];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@AccidentId", AccidentId);
parrSP[2] = new SqlParameter("@DtAccident", DtAccident);
parrSP[3] = new SqlParameter("@PlaceOfAccident", PlaceOfAccident);
parrSP[4] = new SqlParameter("@DtInstructions", DtInstructions);
parrSP[5] = new SqlParameter("@DtSurvey", DtSurvey);
parrSP[6] = new SqlParameter("@DtReceiptSSR", DtReceiptSSR);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspAccident", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[10];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@DriverId", DriverId);
parrSP[2] = new SqlParameter("@Driver", Default);
parrSP[3] = new SqlParameter("@DtLicenseIssue", DtLicenseIssue);
parrSP[4] = new SqlParameter("@LicenseNo", LicenseNo);
parrSP[5] = new SqlParameter("@DtValidLicense", DtValidLicense);
parrSP[6] = new SqlParameter("@IssuingAuthority", IssuingAuthority);
parrSP[7] = new SqlParameter("@LicenseTypeId", LicenseType.LicenseTypeId);
parrSP[8] = new SqlParameter("@BadgeNo", BadgeNo);
parrSP[9] = new SqlParameter("@StatusDL", StatusDL);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspDriver", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[6];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@FeeScheduleId", FeeScheduleId);
parrSP[2] = new SqlParameter("@InsuranceCompanyId", InsuranceCompany.InsuranceCompanyId);
parrSP[3] = new SqlParameter("@AssessmentTypeId", AssessmentType.AssessmentTypeId);
parrSP[4] = new SqlParameter("@DtWEF", DtWEF);
parrSP[5] = new SqlParameter("@IsEstimateBased", IsEstimateBased);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspFeeSchedule", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[3];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@InjuriesId", InjuriesId);
parrSP[2] = new SqlParameter("@Injuries", Default);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspInjuries", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mFIRId = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[6];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@FIRId", FIRId);
parrSP[2] = new SqlParameter("@HasBeenReported", HasBeenReported);
parrSP[3] = new SqlParameter("@PoliceStation", PoliceStation);
parrSP[4] = new SqlParameter("@StationDiaryNo", StationDiaryNo);
parrSP[5] = new SqlParameter("@DtStationDiary", DtStationDiary);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspFIR", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[6];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@DepreciationScheduleId", DepreciationScheduleId);
parrSP[2] = new SqlParameter("@MonthAgeFrom", MonthAgeFrom);
parrSP[3] = new SqlParameter("@MonthAgeTill", MonthAgeTill);
parrSP[4] = new SqlParameter("@DepreciationRate", DepreciationRate);
parrSP[5] = new SqlParameter("@PartCategoryId", PartCategory.PartCategoryId);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspDepreciationSchedule", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[9];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@ID", ID);
parrSP[2] = new SqlParameter("@Title", Title);
parrSP[3] = new SqlParameter("@AccountName", AccountName);
parrSP[4] = new SqlParameter("@MICR", MICR);
parrSP[5] = new SqlParameter("@Bank", Bank);
parrSP[6] = new SqlParameter("@IFSC", IFSC);
parrSP[7] = new SqlParameter("mAccountType", AccountType);
parrSP[8] = new SqlParameter("mAccountNumber", AccountNumber);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspBankAccount", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[12];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@WorkshopId", WorkshopId);
parrSP[2] = new SqlParameter("@Workshop", Default);
parrSP[3] = new SqlParameter("@Address", Address);
parrSP[4] = new SqlParameter("@Milestone", Milestone);
parrSP[5] = new SqlParameter("@City", City);
parrSP[6] = new SqlParameter("@Phone1", Phone1);
parrSP[7] = new SqlParameter("@Phone2", Phone2);
parrSP[8] = new SqlParameter("@Contact", Contact);
parrSP[9] = new SqlParameter("@ContactRank", ContactRank);
parrSP[10] = new SqlParameter("@ContactEmail", ContactEmail);
parrSP[11] = new SqlParameter("@ContactMobile", ContactMobile);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspWorkshop", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mOfficeGSTID = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[7];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@StateCode", StateCode);
parrSP[2] = new SqlParameter("@SGSTRate", SGSTRate);
parrSP[3] = new SqlParameter("@CGSTRate", CGSTRate);
parrSP[4] = new SqlParameter("@UGSTRate", UGSTRate);
parrSP[5] = new SqlParameter("@IGSTRate", IGSTRate);
parrSP[6] = new SqlParameter("@OfficeGSTID", OfficeGSTID);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspOfficeGST", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
}
return("Transaction failed");
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[6];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@InsuredReminderId", InsuredReminderId);
parrSP[2] = new SqlParameter("@FirstReminder", FirstReminder);
parrSP[3] = new SqlParameter("@SecondReminder", SecondReminder);
parrSP[4] = new SqlParameter("@ThirdReminder", ThirdReminder);
parrSP[5] = new SqlParameter("@AssessmentId", Assessment.AssessmentId);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspInsuredReminder", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mInsuredReminderId = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[6];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@InsuredReminderId", InsuredReminderId);
parrSP[2] = new SqlParameter("@FirstReminder", FirstReminder);
parrSP[3] = new SqlParameter("@SecondReminder", SecondReminder);
parrSP[4] = new SqlParameter("@ThirdReminder", ThirdReminder);
parrSP[5] = new SqlParameter("@AssessmentId", Assessment.AssessmentId);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspInsuredReminder", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[12];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@BillDetailId", BillDetailId);
parrSP[2] = new SqlParameter("@Item", Item);
parrSP[3] = new SqlParameter("@Fee", Fee);
parrSP[4] = new SqlParameter("@FeeUnit", FeeUnit);
parrSP[5] = new SqlParameter("@ReFee", ReFee);
parrSP[6] = new SqlParameter("@ReFeeUnit", ReInspectionFeeUnit);
parrSP[7] = new SqlParameter("@Description", Description);
parrSP[8] = new SqlParameter("@BillId", Bill.BillId);
parrSP[9] = new SqlParameter("@SAC", SAC);
parrSP[10] = new SqlParameter("@Amount", Amount);
parrSP[11] = new SqlParameter("@Head", Head);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspBillDetail", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mVehicleId = this.Identity.New();
}
if (PaintType.PaintTypeId == 0)
{
PaintType = new PaintType(Connection, -1);
}
SqlParameter[] parrSP = new SqlParameter[26];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@VehicleId", VehicleId);
parrSP[2] = new SqlParameter("@RegistrationNo", RegistrationNo);
parrSP[3] = new SqlParameter("@DtRegistration", DtRegistration);
parrSP[4] = new SqlParameter("@DtPurchase", DtPurchase);
parrSP[5] = new SqlParameter("@RegisteredOwner", RegisteredOwner);
parrSP[6] = new SqlParameter("@ModelVersionId", ModelVersion.ModelVersionId);
parrSP[7] = new SqlParameter("@TypeOfBody", TypeOfBody);
parrSP[8] = new SqlParameter("@ClassOfVehice", ClassOfVehice);
parrSP[9] = new SqlParameter("@PreAccidentCondition", PreAccidentCondition);
parrSP[10] = new SqlParameter("@RegisteredLadenWeight", RegisteredLadenWeight);
parrSP[11] = new SqlParameter("@UnladenWeight", UnladenWeight);
parrSP[12] = new SqlParameter("@FitnessCertificateNo", FitnessCertificateNo);
parrSP[13] = new SqlParameter("@DtValidFitnessCertificate", DtValidFitnessCertificate);
parrSP[14] = new SqlParameter("@DtTaxPaidUpto", DtTaxPaidUpto);
parrSP[15] = new SqlParameter("@RoutePermitNo", RoutePermitNo);
parrSP[16] = new SqlParameter("@DtValidRoutePermit", DtValidRoutePermit);
parrSP[17] = new SqlParameter("@TypeOfPermit", TypeOfPermit);
parrSP[18] = new SqlParameter("@RouteArea", RouteArea);
parrSP[19] = new SqlParameter("@StatusRC", StatusRC);
parrSP[20] = new SqlParameter("@PaintTypeId", PaintType.PaintTypeId);
parrSP[21] = new SqlParameter("@ChassisNo", ChassisNo);
parrSP[22] = new SqlParameter("@EngineNo", EngineNo);
parrSP[23] = new SqlParameter("@IDV", IDV);
parrSP[24] = new SqlParameter("@DtRegistrationRemarks", DtRegistrationRemarks);
parrSP[25] = new SqlParameter("@DoPrintDOP", DoPrintDOP);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspVehicle", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(ex.ToString());
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mBillDetailId = this.Identity.New();
}
if (pTransactionType == enumDBTransaction.spEdit)
{
if (mBillDetailId <= 0)
{
pTransactionType = enumDBTransaction.spAdd;
mBillDetailId = this.Identity.New();
}
else
{
if (!IsDirty)
{
pTransactionType = enumDBTransaction.spDelete;
}
}
}
SqlParameter[] parrSP = new SqlParameter[12];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@BillDetailId", BillDetailId);
parrSP[2] = new SqlParameter("@Item", Item);
parrSP[3] = new SqlParameter("@Fee", Fee);
parrSP[4] = new SqlParameter("@FeeUnit", FeeUnit);
parrSP[5] = new SqlParameter("@ReFee", ReFee);
parrSP[6] = new SqlParameter("@ReFeeUnit", ReInspectionFeeUnit);
parrSP[7] = new SqlParameter("@Description", Description);
parrSP[8] = new SqlParameter("@BillId", Bill.BillId);
parrSP[9] = new SqlParameter("@SAC", SAC);
parrSP[10] = new SqlParameter("@Amount", Amount);
parrSP[11] = new SqlParameter("@Head", Head);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspBillDetail", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
SqlParameter[] parrSP = new SqlParameter[9];
if (argTransactionType == enumDBTransaction.spAdd)
{
mID = this.Identity.New();
}
parrSP[0] = new SqlParameter("@Action", argTransactionType);
parrSP[1] = new SqlParameter("@ID", ID);
parrSP[2] = new SqlParameter("@Title", Title);
parrSP[3] = new SqlParameter("@AccountName", AccountName);
parrSP[4] = new SqlParameter("@MICR", MICR);
parrSP[5] = new SqlParameter("@Bank", Bank);
parrSP[6] = new SqlParameter("@IFSC", IFSC);
parrSP[7] = new SqlParameter("@AccountType", AccountType);
parrSP[8] = new SqlParameter("@AccountNumber", AccountNumber);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspBankAccount", parrSP);
return(null);
//enumDBTransaction pTransactionType = argTransactionType;
//if (pTransactionType == enumDBTransaction.spAdd)
//{
// mBillId = this.Identity.New();
//}
//SqlParameter[] parrSP = GetParameters(pTransactionType);
//SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspBill", parrSP);
//if (BillDetails.IsDirty)
//{
// foreach (BillDetail fss in this.BillDetails.Values)
// {
// fss.Bill = this;
// fss.Transaction(pTransactionType);
// }
//}
// return null;
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = enumDBTransaction.spNull;
if (TransactionType != enumDBTransaction.spNull)
{
pTransactionType = TransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mAssemblyId = this.Identity.New();
}
}
else
{
pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mAssemblyId = this.Identity.New();
}
else if ((pTransactionType == enumDBTransaction.spEdit) && (mAssemblyId <= 0))
{
pTransactionType = enumDBTransaction.spAdd;
mAssemblyId = this.Identity.New();
}
}
SqlParameter[] parrSP = new SqlParameter[5];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@AssemblyId", AssemblyId);
parrSP[2] = new SqlParameter("@Assembly", Default);
parrSP[3] = new SqlParameter("@Remarks", Remarks);
parrSP[4] = new SqlParameter("@AssessmentId", Assessment.AssessmentId);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspAssembly", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mFeeScheduleSlabId = this.Identity.New();
}
if (pTransactionType == enumDBTransaction.spEdit)
{
if (mFeeScheduleSlabId <= 0)
{
pTransactionType = enumDBTransaction.spAdd;
mFeeScheduleSlabId = this.Identity.New();
}
else
{
if (!IsDirty)
{
pTransactionType = enumDBTransaction.spDelete;
}
}
}
SqlParameter[] parrSP = new SqlParameter[7];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@FeeScheduleSlabId", FeeScheduleSlabId);
parrSP[2] = new SqlParameter("@FeeScheduleId", FeeSchedule.FeeScheduleId);
parrSP[3] = new SqlParameter("@SlabFrom", SlabFrom);
parrSP[4] = new SqlParameter("@SlabUpto", SlabUpto);
parrSP[5] = new SqlParameter("@Fee", Fee);
parrSP[6] = new SqlParameter("@ReInspectionFee", ReInspectionFee);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspFeeScheduleSlab", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mDepreciationScheduleId = this.Identity.New();
}
if (pTransactionType == enumDBTransaction.spEdit)
{
if (mDepreciationScheduleId <= 0)
{
pTransactionType = enumDBTransaction.spAdd;
mDepreciationScheduleId = this.Identity.New();
}
else
{
if (!IsDirty)
{
pTransactionType = enumDBTransaction.spDelete;
}
}
}
SqlParameter[] parrSP = new SqlParameter[6];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@DepreciationScheduleId", DepreciationScheduleId);
parrSP[2] = new SqlParameter("@MonthAgeFrom", MonthAgeFrom);
parrSP[3] = new SqlParameter("@MonthAgeTill", MonthAgeTill);
parrSP[4] = new SqlParameter("@DepreciationRate", DepreciationRate);
parrSP[5] = new SqlParameter("@PartCategoryId", PartCategory.PartCategoryId);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspDepreciationSchedule", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mOfficeId = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[18];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@OfficeId", OfficeId);
parrSP[2] = new SqlParameter("@Office", Default);
parrSP[3] = new SqlParameter("@Address", Address);
parrSP[4] = new SqlParameter("@Milestone", Milestone);
parrSP[5] = new SqlParameter("@City", City);
parrSP[6] = new SqlParameter("@Phone1", Phone1);
parrSP[7] = new SqlParameter("@Phone2", Phone2);
parrSP[8] = new SqlParameter("@Contact", Contact);
parrSP[9] = new SqlParameter("@ContactRank", ContactRank);
parrSP[10] = new SqlParameter("@ContactEmail", ContactEmail);
parrSP[11] = new SqlParameter("@ContactMobile", ContactMobile);
parrSP[12] = new SqlParameter("@InsuranceCompanyId", InsuranceCompany.InsuranceCompanyId);
parrSP[13] = new SqlParameter("@OfficeTypeId", OfficeType.OfficeTypeId);
parrSP[14] = new SqlParameter("@OfficeCode", OfficeCode);
//parrSP[15] = new SqlParameter("@StateCode", OfficeGST.StateCode);
//parrSP[16] = new SqlParameter("@SGSTRate", OfficeGST.SGSTRate);
//parrSP[17] = new SqlParameter("@CGSTRate", OfficeGST.CGSTRate);
//parrSP[18] = new SqlParameter("@UGSTRate", OfficeGST.UGSTRate);
//parrSP[19] = new SqlParameter("@IGSTRate", OfficeGST.IGSTRate);
parrSP[15] = new SqlParameter("@OfficeGSTID", OfficeGSTID);
parrSP[16] = new SqlParameter("@GSTNo", GSTNo);
parrSP[17] = new SqlParameter("@CompanyCode", CompanyCode);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspOffice", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[26];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@VehicleId", VehicleId);
parrSP[2] = new SqlParameter("@RegistrationNo", RegistrationNo);
parrSP[3] = new SqlParameter("@DtRegistration", DtRegistration);
parrSP[4] = new SqlParameter("@DtPurchase", DtPurchase);
parrSP[5] = new SqlParameter("@RegisteredOwner", RegisteredOwner);
parrSP[6] = new SqlParameter("@ModelVersionId", ModelVersion.ModelVersionId);
parrSP[7] = new SqlParameter("@TypeOfBody", TypeOfBody);
parrSP[8] = new SqlParameter("@ClassOfVehice", ClassOfVehice);
parrSP[9] = new SqlParameter("@PreAccidentCondition", PreAccidentCondition);
parrSP[10] = new SqlParameter("@RegisteredLadenWeight", RegisteredLadenWeight);
parrSP[11] = new SqlParameter("@UnladenWeight", UnladenWeight);
parrSP[12] = new SqlParameter("@FitnessCertificateNo", FitnessCertificateNo);
parrSP[13] = new SqlParameter("@DtValidFitnessCertificate", DtValidFitnessCertificate);
parrSP[14] = new SqlParameter("@DtTaxPaidUpto", DtTaxPaidUpto);
parrSP[15] = new SqlParameter("@RoutePermitNo", RoutePermitNo);
parrSP[16] = new SqlParameter("@DtValidRoutePermit", DtValidRoutePermit);
parrSP[17] = new SqlParameter("@TypeOfPermit", TypeOfPermit);
parrSP[18] = new SqlParameter("@RouteArea", RouteArea);
parrSP[19] = new SqlParameter("@StatusRC", StatusRC);
parrSP[20] = new SqlParameter("@PaintTypeId", PaintType.PaintTypeId);
parrSP[21] = new SqlParameter("@ChassisNo", ChassisNo);
parrSP[22] = new SqlParameter("@EngineNo", EngineNo);
parrSP[23] = new SqlParameter("@IDV", IDV);
parrSP[24] = new SqlParameter("@DtRegistrationRemarks", DtRegistrationRemarks);
parrSP[25] = new SqlParameter("@DoPrintDOP", DoPrintDOP);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspVehicle", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
try
{
conTransaction = new SqlConnection(Connection);
conTransaction.Open();
trsTransaction = conTransaction.BeginTransaction();
enumDBTransaction pTransactionType = argTransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mPartId = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[7];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@PartId", PartId);
parrSP[2] = new SqlParameter("@Part", Default);
parrSP[3] = new SqlParameter("@PartCategoryId", PartCategory.PartCategoryId);
parrSP[4] = new SqlParameter("@VatRate", VatRate);
parrSP[5] = new SqlParameter("@Code", Code);
parrSP[6] = new SqlParameter("@IsIMT23Applicable", IsIMT23Applicable);
SqlHelper.ExecuteNonQuery(trsTransaction, CommandType.StoredProcedure, "uspPart", parrSP);
//foreach (Insurance.Surveyor.LabourSchdPT var in this.LabourSchdPTs.Values)
//{
// var.Transaction(enumDBTransaction.spAdd);
//}
this.PartCategoryCompanies.Save(this);
trsTransaction.Commit();
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
//trsTransaction.Rollback();
return("Transaction failed");
}
finally
{
conTransaction.Close();
}
}
public string Transaction(enumDBTransaction argTransactionType)
{
enumDBTransaction pTransactionType;
try
{
pTransactionType =
(TransactionType == enumDBTransaction.spNull) ? argTransactionType : TransactionType;
if (pTransactionType == enumDBTransaction.spAdd)
{
mAssessmentLabourId = this.Identity.New();
}
SqlParameter[] parrSP = new SqlParameter[16];
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@AssessmentLabourId", AssessmentLabourId);
parrSP[2] = new SqlParameter("@AssessmentId", Assessment.AssessmentId);
parrSP[3] = new SqlParameter("@SrNo", SrNo);
parrSP[4] = new SqlParameter("@DescClaimed", DescClaimed);
parrSP[5] = new SqlParameter("@Claimed", Claimed);
parrSP[6] = new SqlParameter("@PartId", Part.PartId);
parrSP[7] = new SqlParameter("@DescAssessed", DescAssessed);
parrSP[8] = new SqlParameter("@AssessedRR", AssessedRR);
parrSP[9] = new SqlParameter("@AssessedDB", AssessedDB);
parrSP[10] = new SqlParameter("@PaintTypeId", PaintType.PaintTypeId);
parrSP[11] = new SqlParameter("@AssessedPT", AssessedPT);
parrSP[12] = new SqlParameter("@ClaimId", ClaimId);
parrSP[13] = new SqlParameter("@NetAssessed", NetAssessed);
parrSP[14] = new SqlParameter("@WorkshopId", Workshop.WorkshopId);
parrSP[15] = new SqlParameter("@EstimateId", this.Estimate.EstimateId);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "uspAssessmentLabour", parrSP);
return(null);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "Communique";
//StringBuilder sb = new StringBuilder();
//sb.Append("public bool Transaction(enumDBTransaction argTransactionType)");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return("Transaction failed");
}
}
public System.Data.DataTable Items()
{
try
{
SqlParameter[] parrSP = new SqlParameter[18];
enumDBTransaction pTransactionType = enumDBTransaction.spSelect;
parrSP[0] = new SqlParameter("@Action", pTransactionType);
parrSP[1] = new SqlParameter("@OfficeId", OfficeId);
parrSP[2] = new SqlParameter("@Office", Default);
parrSP[3] = new SqlParameter("@Address", Address);
parrSP[4] = new SqlParameter("@Milestone", Milestone);
parrSP[5] = new SqlParameter("@City", City);
parrSP[6] = new SqlParameter("@Phone1", Phone1);
parrSP[7] = new SqlParameter("@Phone2", Phone2);
parrSP[8] = new SqlParameter("@Contact", Contact);
parrSP[9] = new SqlParameter("@ContactRank", ContactRank);
parrSP[10] = new SqlParameter("@ContactEmail", ContactEmail);
parrSP[11] = new SqlParameter("@ContactMobile", ContactMobile);
parrSP[12] = new SqlParameter("@InsuranceCompanyId", InsuranceCompany.InsuranceCompanyId);
parrSP[13] = new SqlParameter("@OfficeTypeId", OfficeType.OfficeTypeId);
parrSP[14] = new SqlParameter("@OfficeCode", OfficeCode);
//parrSP[15] = new SqlParameter("@StateCode", OfficeGST.StateCode);
//parrSP[16] = new SqlParameter("@SGSTRate", OfficeGST.SGSTRate);
//parrSP[17] = new SqlParameter("@CGSTRate", OfficeGST.CGSTRate);
//parrSP[18] = new SqlParameter("@UGSTRate", OfficeGST.UGSTRate);
//parrSP[19] = new SqlParameter("@IGSTRate", OfficeGST.IGSTRate);
parrSP[15] = new SqlParameter("@OfficeGSTID", OfficeGSTID);
parrSP[16] = new SqlParameter("@GSTNo", GSTNo);
parrSP[17] = new SqlParameter("@CompanyCode", CompanyCode);
DataSet ds = SqlHelper.ExecuteDataset(Connection, "uspOffice", parrSP);
return(ds.Tables[0]);
}
catch (Exception ex)
{
//OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper();
//appLog.Source = "";
//StringBuilder sb = new StringBuilder();
//sb.Append("public System.Data.DataTable Items()");
//sb.Append("Exception=" + ex.Message);
//appLog.WriteEntry(sb.ToString());
return(new DataTable());
}
}
