SqlParameter[] GetParameters(System.Int32 argTransactionType, DateTime DtFrom, DateTime DtTill, Workshop wrk, Office off, AssessmentType argAssessmentType, Model argModel) { //@Action int = 0 OUTPUT, //@BillId int = 0, //@BillNo varchar (10) = '', //@DtBill datetime = '20070101', //@Total real = 0, //@ServiceTaxRate real = 0, //@ServiceTax decimal = 0, //@EducationCessRate real = 0, //@EducationCess decimal = 0, //@GrandTotal real = 0, //@AssessmentId int = 0, //@WorkshopId int = 0, //@OfficeId int = 0, //@ModelId int = 0, //@AssessmentTypeId int = 0, //@DtFrom datetime ='20070101 00:00', //@DtTill datetime ='20080101 00:00' SqlParameter[] parrSP = new SqlParameter[26]; parrSP[0] = new SqlParameter("@Action", argTransactionType); parrSP[1] = new SqlParameter("@BillId", BillId); parrSP[2] = new SqlParameter("@BillNo", BillNo); parrSP[3] = new SqlParameter("@DtBill", DtBill); parrSP[4] = new SqlParameter("@Total", Total); parrSP[5] = new SqlParameter("@ServiceTaxRate", ServiceTaxRate); parrSP[6] = new SqlParameter("@ServiceTax", ServiceTax); parrSP[7] = new SqlParameter("@EducationCessRate", EducationCessRate); parrSP[8] = new SqlParameter("@EducationCess", EducationCess); parrSP[9] = new SqlParameter("@GrandTotal", GrandTotal); parrSP[10] = new SqlParameter("@AssessmentId", Assessment.AssessmentId); parrSP[11] = new SqlParameter("@WorkshopId", wrk == null ? 0 : wrk.WorkshopId); parrSP[12] = new SqlParameter("@OfficeId", off == null ? 0 : off.OfficeId); parrSP[13] = new SqlParameter("@ModelId", argModel == null ? 0 : argModel.ModelId); parrSP[14] = new SqlParameter("@AssessmentTypeId", argAssessmentType == null ? 0 : argAssessmentType.AssessmentTypeId); parrSP[15] = new SqlParameter("@DtFrom", DtFrom); parrSP[16] = new SqlParameter("@DtTill", DtTill); parrSP[17] = new SqlParameter("@StateCode", StateCode == null ? "0" : StateCode); parrSP[18] = new SqlParameter("@SGST", SGST); parrSP[19] = new SqlParameter("@SGSTRate", SGSTRate); parrSP[20] = new SqlParameter("@CGST", CGST); parrSP[21] = new SqlParameter("@CGSTRate", CGSTRate); parrSP[22] = new SqlParameter("@UGST", UGST); parrSP[23] = new SqlParameter("@UGSTRate", UGSTRate); parrSP[24] = new SqlParameter("@IGST", IGST); parrSP[25] = new SqlParameter("@IGSTRate", IGSTRate); return(parrSP); }
SqlParameter[] GetParameters(System.Int32 argTransactionType, DateTime DtFrom, DateTime DtTill, Workshop wrk, Office off, AssessmentType argAssessmentType, Model argModel) { SqlParameter[] parrSP = new SqlParameter[32]; parrSP[0] = new SqlParameter("@Action", argTransactionType); parrSP[1] = new SqlParameter("@ReceiptId", ReceiptId); parrSP[2] = new SqlParameter("@DtCheque", DtCheque); parrSP[3] = new SqlParameter("@Bank", Bank); parrSP[4] = new SqlParameter("@SlipNo", SlipNo); parrSP[5] = new SqlParameter("@DtSlip", DtSlip); parrSP[6] = new SqlParameter("@ChequeNo", ChequeNo); parrSP[7] = new SqlParameter("@TotalReceipt", NetReceipt); parrSP[8] = new SqlParameter("@ServiceTax", ServiceTax); parrSP[9] = new SqlParameter("@EducationTax", EducationTax); parrSP[10] = new SqlParameter("@ChequeAmount", ChequeAmount); parrSP[11] = new SqlParameter("@BillId", Bill.BillId); parrSP[12] = new SqlParameter("@AssessmentId", Assessment.AssessmentId); parrSP[13] = new SqlParameter("@TDS", TDS); parrSP[14] = new SqlParameter("@WorkshopId", wrk == null ? 0 : wrk.WorkshopId); parrSP[15] = new SqlParameter("@OfficeId", off == null ? 0 : off.OfficeId); parrSP[16] = new SqlParameter("@ModelId", argModel == null ? 0 : argModel.ModelId); parrSP[17] = new SqlParameter("@AssessmentTypeId", argAssessmentType == null ? 0 : argAssessmentType.AssessmentTypeId); parrSP[18] = new SqlParameter("@DtFrom", DtFrom); parrSP[19] = new SqlParameter("@DtTill", DtTill); parrSP[20] = new SqlParameter("@EduCessRate", mEduCessRate); parrSP[21] = new SqlParameter("@ServiceTaxRate", mServiceTaxRate); parrSP[22] = new SqlParameter("@TDSRate", mTDSRate); parrSP[23] = new SqlParameter("@TotalFeePaid", mTotalFeePaid); parrSP[24] = new SqlParameter("@CGST", mCGST); parrSP[25] = new SqlParameter("@CGSTRate", mCGSTRate); parrSP[27] = new SqlParameter("@SGST", mSGST); parrSP[26] = new SqlParameter("@SGSTRate", mSGSTRate); parrSP[28] = new SqlParameter("@IGST", mIGST); parrSP[29] = new SqlParameter("@IGSTRate", mIGSTRate); parrSP[30] = new SqlParameter("@UGST", mUGST); parrSP[31] = new SqlParameter("@UGSTRate", mUGSTRate); return(parrSP); }
public System.Data.DataTable Items(DateTime DtFrom, DateTime DtTill, Workshop wrk, Office off, AssessmentType argAssessmentType, Model argModel) { try { SqlParameter[] parrSP = GetParameters(4, DtFrom, DtTill, wrk, off, argAssessmentType, argModel); 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 PartEstimate(Estimate estimate, Workshop workshop, AssessmentParts assessmentParts) { this.Estimate = estimate; this.Workshop = workshop; this.AssessmentParts = assessmentParts; }
public LabourEstimate(Estimate estimate, Workshop workshop, AssessmentLabours assessmentParts) { this.Estimate = estimate; this.Workshop = workshop; this.AssessmentLabours = assessmentParts; }