public ssmtbl_DeliveryChallanModel getDispacthNODetails(string dispatch_no) { ssmtbl_DeliveryChallanModel objModel = new ssmtbl_DeliveryChallanModel(); try { string sqlstr = "select auto_id," + " isnull( dispatch_char,'') as dispatch_char," + " isnull( dispatch_id,0) as dispatch_id," + " isnull( dispatch_no,0) as dispatch_no," + " isnull( delivery_challan_type,'') as delivery_challan_type," + " isnull( customer_name,'') as customer_name," + " isnull( customer_id,'') as customer_id," + " isnull( customerpono,'') as customerpono," + " isnull( po_qty,'') as po_qty," + " isnull( hsncode,'')as hsncode, " + " isnull( customer_part_no,'')as customer_part_no, " + " isnull( vendor_id,'')as vendor_id, " + " isnull( vendor_name,'')as vendor_name, " + " isnull( die_no,'')as die_no," + " isnull( remark,'')as remark," + " isnull( process,'')as process," + " isnull( vendor_po_no,'')as vendor_po_no," + " isnull( expected_date,'')as expected_date," + " isnull( type_of_testing,'')as type_of_testing," + " isnull( heat_code,'')as heat_code," + " isnull( expected_report_date,'')as expected_report_date, " + " isnull( material_grade,'')as material_grade, " + " isnull( section,'')as section, " + " isnull(returnable_type,'')as returnable_type," + " isnull( part_description,'') as part_description, " + " isnull( cgst_perc,0)as cgst_perc," + " isnull( cgst_amt,0) as cgst_amt," + " isnull( sgst_perc,0) as sgst_perc," + " isnull( sgst_amt,0) as sgst_amt," + " isnull( igst_perc,0) as igst_perc," + " isnull( igst_amt,0) as igst_amt, " + " isnull( total,0) as total," + " isnull( grand_total,0) as grand_total," + " isnull( createdby,'') as createdby," + " isnull( createdon,'') as createdon," + " isnull( updatedby,'') as updatedby," + " isnull( updatedon,'') as updatedon" + " from ssmtbl_deliverychallan where dispatch_no=@dispatch_no"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@dispatch_no", dispatch_no); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objModel.dispatch_char = Convert.ToString(sdr["dispatch_char"]); objModel.dispatch_id = Convert.ToInt32(sdr["dispatch_id"]); objModel.dispatch_no = Convert.ToString(sdr["dispatch_no"]); objModel.delivery_challan_type = Convert.ToString(sdr["delivery_challan_type"]); objModel.customer_name = Convert.ToString(sdr["customer_name"]); objModel.customer_id = Convert.ToInt32(sdr["customer_id"]); objModel.CustomerPONo = Convert.ToString(sdr["CustomerPONo"]); objModel.po_qty = Convert.ToString(sdr["po_qty"]); objModel.HSNCode = Convert.ToString(sdr["HSNCode"]); objModel.Customer_part_no = Convert.ToString(sdr["Customer_part_no"]); objModel.vendor_id = Convert.ToInt32(sdr["vendor_id"]); objModel.vendor_name = Convert.ToString(sdr["vendor_name"]); objModel.die_no = Convert.ToString(sdr["die_no"]); objModel.remark = Convert.ToString(sdr["remark"]); objModel.process = Convert.ToString(sdr["process"]); objModel.vendor_po_no = Convert.ToString(sdr["vendor_po_no"]); objModel.expected_date = Convert.ToDateTime(sdr["expected_date"]); objModel.type_of_testing = Convert.ToString(sdr["type_of_testing"]); objModel.heat_code = Convert.ToString(sdr["heat_code"]); objModel.expected_report_date = Convert.ToDateTime(sdr["expected_report_date"]); objModel.material_grade = Convert.ToString(sdr["material_grade"]); objModel.section = Convert.ToString(sdr["section"]); objModel.returnable_type = Convert.ToString(sdr["returnable_type"]); objModel.part_description = Convert.ToString(sdr["part_description"]); objModel.cgst_perc = Convert.ToDecimal(sdr["cgst_perc"]); objModel.cgst_amt = Convert.ToDecimal(sdr["cgst_amt"]); objModel.sgst_perc = Convert.ToDecimal(sdr["sgst_perc"]); objModel.sgst_amt = Convert.ToDecimal(sdr["sgst_amt"]); objModel.igst_perc = Convert.ToDecimal(sdr["igst_perc"]); objModel.igst_amt = Convert.ToDecimal(sdr["igst_amt"]); objModel.total = Convert.ToDecimal(sdr["total"]); objModel.grand_total = Convert.ToInt32(sdr["grand_total"]); objModel.CreatedBy = Convert.ToString(sdr["CreatedBy"]); objModel.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"]); objModel.UpdatedBy = Convert.ToString(sdr["UpdatedBy"]); objModel.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"]); } sdr.Close(); List <ssmtbl_DeliveryChallan_DetailsModel> objVPO_DetList = new List <ssmtbl_DeliveryChallan_DetailsModel>(); sqlstr = "SELECT dc_det_auto_id," + " isnull( wo,'') as wo," + " isnull( dispatch_no,0)as dispatch_no," + " isnull( material_grade,'') as material_grade," + " isnull( section,'') as section," + " isnull( cut_weight,'')as cut_weight," + " isnull( hardness,'')as hardness," + " isnull( finish_weight,'')as finish_weight, " + " isnull( heat_code,'')as heat_code," + " isnull( wo_balance,0)as wo_balance ," + " isnull( description,'')as description, " + " isnull( hsn_sac_code,'')as hsn_sac_code, " + " isnull( qty,0)as qty," + " isnull( units,'')as units," + " isnull( taxable_value,0)as taxable_value" + " FROM ssmtbl_DeliveryChallan_Details where dispatch_no=@dispatch_no"; cmd.Connection = connection; cmd.CommandText = sqlstr; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@dispatch_no", dispatch_no); sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_DeliveryChallan_DetailsModel tempdata = new ssmtbl_DeliveryChallan_DetailsModel(); tempdata.dc_det_auto_id = Convert.ToInt32(sdr["dc_det_auto_id"]); tempdata.dispatch_no = Convert.ToString(sdr["dispatch_no"]); tempdata.wo = Convert.ToString(sdr["wo"]); tempdata.material_grade = Convert.ToString(sdr["material_grade"]); tempdata.section = Convert.ToString(sdr["section"]); tempdata.cut_weight = Convert.ToString(sdr["cut_weight"]); tempdata.hardness = Convert.ToString(sdr["hardness"]); tempdata.finish_weight = Convert.ToString(sdr["finish_weight"]); tempdata.heat_code = Convert.ToString(sdr["heat_code"]); tempdata.wo_balance = Convert.ToDecimal(sdr["wo_balance"]); tempdata.description = Convert.ToString(sdr["description"]); tempdata.hsn_sac_code = Convert.ToString(sdr["hsn_sac_code"]); tempdata.qty = Convert.ToDecimal(sdr["qty"]); tempdata.units = Convert.ToString(sdr["units"]); tempdata.taxable_value = Convert.ToDecimal(sdr["taxable_value"]); objVPO_DetList.Add(tempdata); } sdr.Close(); objModel.ssmtbl_DeliveryChallan_DetailsModelList = objVPO_DetList; List <ssmtbl_TermsNCondtionModel> objVPO_TnCList = new List <ssmtbl_TermsNCondtionModel>(); sqlstr = "select id, isnull(TermsNConditionID,0) as TermsNConditionID, isnull(TermsNConditionContent,'') as TermsNConditionContent " + " from ssmtbl_VendorPurchaseOrderTermsNCondtion where ISNULL(po_no,'')=@po_no "; cmd.Connection = connection; cmd.CommandText = sqlstr; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@po_no", objModel.vendor_po_no); sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_TermsNCondtionModel tempdata = new ssmtbl_TermsNCondtionModel(); tempdata.id = Convert.ToInt32(sdr["id"].ToString()); tempdata.TermsNConditionID = Convert.ToInt32(sdr["TermsNConditionID"].ToString()); tempdata.TermsNConditionContent = sdr["TermsNConditionContent"].ToString(); objVPO_TnCList.Add(tempdata); } objModel.ssmtbl_TermsNCondtionModel = objVPO_TnCList; connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objModel); }
public ssmtbl_QuotationModel GetOneQuotationForApproval(string QuotationId) { ssmtbl_QuotationModel objQuot = new ssmtbl_QuotationModel(); try { var connection = gConnection.Connection(); connection.Open(); string sqlstr = "uspGetOneQuotationForApproval"; SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "GetOneQuotationForApproval"); cmd.Parameters.AddWithValue("@QuotationId", QuotationId); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objQuot.id = Convert.ToInt32(sdr["id"].ToString()); objQuot.InquiryNo = Convert.ToInt32(sdr["InquiryNo"].ToString()); objQuot.QuotationNo = sdr["QuotationNo"].ToString(); objQuot.CustomerName = sdr["CustomerName"].ToString(); objQuot.PartDescription = sdr["PartDescription"].ToString(); objQuot.PartNo = sdr["PartNo"].ToString(); objQuot.HeatTreatmentText = sdr["HeatTreatment"].ToString(); objQuot.Material = sdr["Material"].ToString(); objQuot.VersionNo = sdr["VersionNo"].ToString(); objQuot.Section = sdr["Section"].ToString(); objQuot.MachainedWeight = sdr["MachainedWeight"].ToString(); objQuot.GrossWeight = Convert.ToDecimal(sdr["GrossWeight"].ToString()); objQuot.CutWeight = Convert.ToDecimal(sdr["CutWeight"].ToString()); objQuot.NetWeight = Convert.ToDecimal(sdr["NetWeight"].ToString()); objQuot.ForgingCostBased = sdr["ForgingCostBased"].ToString(); objQuot.MPICostBasedOn = sdr["MPICostBasedOn"].ToString(); objQuot.SteelCost = Convert.ToDecimal(sdr["SteelCost"].ToString()); objQuot.Transportation = Convert.ToDecimal(sdr["Transportation"].ToString()); objQuot.Total = Convert.ToDecimal(sdr["Total"].ToString()); objQuot.TotalRowMaterialCost = Convert.ToDecimal(sdr["TotalRowMaterialCost"].ToString()); objQuot.CuttingSquare1 = (sdr["CuttingSquare1"].ToString()); objQuot.CuttingSquare2 = (sdr["CuttingSquare2"].ToString()); objQuot.Forging1 = (sdr["Forging1"].ToString()); objQuot.Forging2 = (sdr["Forging2"].ToString()); objQuot.HeatTreatment1 = (sdr["HeatTreatment1"].ToString()); objQuot.HeatTreatment2 = (sdr["HeatTreatment2"].ToString()); objQuot.ShotBlasting1 = (sdr["ShotBlasting1"].ToString()); objQuot.ShotBlasting2 = (sdr["ShotBlasting2"].ToString()); objQuot.MPI1 = (sdr["MPI1"].ToString()); objQuot.MPI2 = (sdr["MPI2"].ToString()); objQuot.Grinding1 = (sdr["Grinding1"].ToString()); objQuot.Grinding2 = (sdr["Grinding2"].ToString()); objQuot.ColdCoining1 = (sdr["ColdCoining1"].ToString()); objQuot.ColdCoining2 = (sdr["ColdCoining2"].ToString()); objQuot.Machining1 = (sdr["Machining1"].ToString()); objQuot.Machining2 = (sdr["Machining2"].ToString()); objQuot.DieMaintenance1 = (sdr["DieMaintenance1"].ToString()); objQuot.DieMaintenance2 = (sdr["DieMaintenance2"].ToString()); objQuot.TotalConverstionCost = Convert.ToDecimal(sdr["TotalConverstionCost"].ToString()); objQuot.TotalComponentCost = Convert.ToDecimal(sdr["TotalComponentCost"].ToString()); objQuot.InitialDieCost = Convert.ToDecimal(sdr["InitialDieCost"].ToString()); objQuot.PoNo = sdr["PoNo"].ToString(); objQuot.FileStatus = sdr["FileStatus"].ToString(); objQuot.Comment = sdr["Comment"].ToString(); objQuot.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString()); objQuot.ApprovedBy = sdr["ApprovedBy"].ToString(); objQuot.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString()); objQuot.Createdby = sdr["Createdby"].ToString(); objQuot.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"].ToString()); objQuot.UpdatedBy = sdr["UpdatedBy"].ToString(); objQuot.VersionNo = sdr["VersionNo"].ToString(); objQuot.new_Version_No = Convert.ToInt32(sdr["new_Version_No"].ToString()); objQuot.UserComment = sdr["UserComment"].ToString(); objQuot.hardnessmin = sdr["hardnessmin"].ToString(); objQuot.hardnessmax = sdr["hardnessmax"].ToString(); objQuot.hardnessunits = sdr["hardnessunits"].ToString(); objQuot.address = sdr["address"].ToString(); objQuot.iccoverhadrm = sdr["Iccoverhead"].ToString(); // sdr["Iccoverhead"] as decimal? ?? default(decimal); objQuot.totaliccoverhadrm = sdr["Iccoverheadtotal"].ToString(); //Convert.ToDecimal(sdr["Iccoverheadtotal"].ToString()); objQuot.profitonconversion = sdr["Profitconversion"].ToString(); //Convert.ToDecimal(sdr["Profitconversion"].ToString()); objQuot.totalprofitonconversion = sdr["TotalProfitconversion"].ToString(); //Convert.ToDecimal(sdr["TotalProfitconversion"].ToString()); objQuot.rejection = sdr["Rejection"].ToString(); //Convert.ToDecimal(sdr["Rejection"].ToString()); objQuot.totalrejection = sdr["TotalRejection"].ToString(); //Convert.ToDecimal(sdr["TotalRejection"].ToString()); objQuot.packingtransport = sdr["Packing"].ToString(); //Convert.ToDecimal(sdr["Packing"].ToString()); objQuot.totalpackingtransport = sdr["TotalPacking"].ToString(); //Convert.ToDecimal(sdr["TotalPacking"].ToString()); objQuot.totallycost = sdr["TotallyCost"].ToString(); } sdr.Close(); List <ssmtbl_TermsNCondtionModel> objTCList = new List <ssmtbl_TermsNCondtionModel>(); sqlstr = "Select id, Isnull(QuotationID,0) As QuotationID, Isnull(TermsNConditionID,0) As TermsNConditionID, " + " Isnull(TermsNConditionContent,'') As TermsNConditionContent From ssmtbl_TermsNCondtion where QuotationID=@id and flag = 1"; // Sharad // + " Isnull(TermsNConditionContent,'') As TermsNConditionContent From ssmtbl_TermsNCondtion where id=@id"; // Sharad cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@id", objQuot.id); sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_TermsNCondtionModel tempobj = new ssmtbl_TermsNCondtionModel(); tempobj.id = Convert.ToInt32(sdr["id"].ToString()); tempobj.QuotationID = Convert.ToInt32(sdr["QuotationID"].ToString()); tempobj.TermsNConditionID = Convert.ToInt32(sdr["TermsNConditionID"].ToString()); tempobj.TermsNConditionContent = sdr["TermsNConditionContent"].ToString(); objTCList.Add(tempobj); } objQuot.ssmtbl_TermsNCondtionModel = objTCList; // Sharad connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objQuot); }
public ssmtbl_VendorPurchaseOrderModel GetOneVendorPurchaseOrder(string po_no) { ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel(); try { //string sqlstr = "select auto_id, isnull(po_char,'') as po_char, isnull(po_id,0) as po_id, isnull(VPO.po_no,'') as po_no, " //+ " isnull(quotation_ref_no,'') as quotation_ref_no, isnull(quotation_ref_date,'') as quotation_ref_date," //+ " isnull(vendor_id,0) as vendor_id, isnull(vendor_name,'') as vendor_name, isnull(vendor_email,'') as vendor_email, " //+ " isnull(vendor_mobile,'') as vendor_mobile, isnull(contact_person_id,0) as contact_person_id," //+ " isnull(po_date,'') as po_date, isnull(valid_date,'') as valid_date, isnull(VPO.contact_person,'') as contact_person," //+ " isnull(contact_person_email,'') as contact_person_email, isnull(contact_person_mobile,'') as contact_person_mobile," //+ " isnull(vendor_po_type,'') as vendor_po_type, isnull(vendor_po_status,'') as vendor_po_status, isnull(Comment,'') as Comment," //+ " isnull(file_path,'') as file_path, isnull(total,0) as total, isnull(cgst_perc,0) as cgst_perc, isnull(cgst_amt,0) as cgst_amt," //+ " isnull(sgst_perc,0) as sgst_perc, isnull(sgst_amt,0) as sgst_amt, ISNULL(igst_perc,0) as igst_perc, isnull(igst_amt,0) as igst_amt," //+ " isnull(grand_total,0) as grand_total, isnull(CreatedBy,'') as CreatedBy, isnull(CreatedOn,'') as CreatedOn," //+ " isnull(UpdatedBy,'') as UpdatedBy, isnull(UpdatedOn,'') as UpdatedOn, isnull(ApprovalDate,'') as ApprovalDate," //+ " isnull(for_all_dia,'') as for_all_dia, isnull(dia_no,'') as dia_no," //+ " isnull(ApprovedBy,'') as ApprovedBy, Isnull(GSTIN,'') as GSTIN, Isnull(PAN,'') As PAN from ssmtbl_VendorPurchaseOrder VPO , " //+ " CustomerVendorMaster_Tb CT where VPO.vendor_id=CT.Id and ISNULL(po_no,'')=@po_no"; //var connection = gConnection.Connection(); //connection.Open(); //SqlCommand cmd = new SqlCommand(sqlstr, connection); //cmd.Parameters.AddWithValue("@po_no", po_no); var connection = gConnection.Connection(); connection.Open(); string sqlstr = "uspGetVendorPO"; SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "fetchVPOConsumableEditSingle"); cmd.Parameters.AddWithValue("@po_no", po_no.Trim()); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objModel.po_char = sdr["po_char"].ToString(); objModel.po_id = Convert.ToInt32(sdr["po_id"].ToString()); objModel.auto_id = Convert.ToInt32(sdr["auto_id"].ToString()); objModel.po_no = sdr["po_no"].ToString(); objModel.quotation_ref_no = sdr["quotation_ref_no"].ToString(); objModel.quotation_ref_date = Convert.ToDateTime(sdr["quotation_ref_date"]); objModel.vendor_id = Convert.ToInt32(sdr["vendor_id"].ToString()); objModel.vendor_name = sdr["vendor_name"].ToString(); objModel.vendor_email = sdr["vendor_email"].ToString(); objModel.vendor_mobile = sdr["vendor_mobile"].ToString(); objModel.po_date = Convert.ToDateTime(sdr["po_date"]); objModel.valid_date = Convert.ToDateTime(sdr["valid_date"]); objModel.contact_person = sdr["contact_person"].ToString(); objModel.contact_person_id = Convert.ToInt32(sdr["contact_person_id"].ToString()); objModel.contact_person_email = sdr["contact_person_email"].ToString(); objModel.contact_person_mobile = sdr["contact_person_mobile"].ToString(); objModel.vendor_po_type = sdr["vendor_po_type"].ToString(); objModel.vendor_po_status = sdr["vendor_po_status"].ToString(); objModel.Comment = sdr["Comment"].ToString(); objModel.file_path = sdr["file_path"].ToString(); objModel.total = Convert.ToDecimal(sdr["total"].ToString()); objModel.cgst_perc = Convert.ToDecimal(sdr["cgst_perc"].ToString()); objModel.cgst_amt = Convert.ToDecimal(sdr["cgst_amt"].ToString()); objModel.sgst_perc = Convert.ToDecimal(sdr["sgst_perc"].ToString()); objModel.sgst_amt = Convert.ToDecimal(sdr["sgst_amt"].ToString()); objModel.igst_perc = Convert.ToDecimal(sdr["igst_perc"].ToString()); objModel.igst_amt = Convert.ToDecimal(sdr["igst_amt"].ToString()); objModel.grand_total = Convert.ToDecimal(sdr["grand_total"].ToString()); objModel.CreatedBy = sdr["CreatedBy"].ToString(); objModel.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"]); objModel.UpdatedBy = sdr["UpdatedBy"].ToString(); objModel.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"]); objModel.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"]); objModel.ApprovedBy = sdr["ApprovedBy"].ToString(); objModel.for_all_dia = Convert.ToBoolean(sdr["for_all_dia"].ToString()); objModel.dia_no = sdr["dia_no"].ToString(); objModel.GSTIN = sdr["GSTIN"].ToString(); objModel.PAN = sdr["PAN"].ToString(); objModel.Address = sdr["Address"].ToString(); objModel.VersionNo = Convert.ToInt32(sdr["VersionNo"]); } sdr.Close(); connection.Close(); List <ssmtbl_VendorPurchaseOrder_DetailsModel> objVPO_DetList = new List <ssmtbl_VendorPurchaseOrder_DetailsModel>(); connection.Open(); string sqlstr1 = "uspGetVendorPO"; SqlCommand cmd1 = new SqlCommand(sqlstr1, GlobalVariables.gConn); cmd1.CommandType = System.Data.CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Action", "fetchVPOConsumableEditMulti"); cmd1.Parameters.AddWithValue("@po_no", po_no.Trim()); SqlDataReader sdr1 = cmd1.ExecuteReader(); while (sdr1.Read()) { ssmtbl_VendorPurchaseOrder_DetailsModel tempdata = new ssmtbl_VendorPurchaseOrder_DetailsModel(); tempdata.vpo_det_auto_id = Convert.ToInt32(sdr1["vpo_det_auto_id"].ToString()); tempdata.item_code = sdr1["item_code"].ToString(); tempdata.item_description = sdr1["item_description"].ToString(); tempdata.qty = Convert.ToDecimal(sdr1["qty"].ToString()); tempdata.rate = Convert.ToDecimal(sdr1["rate"].ToString()); tempdata.rate_per = sdr1["rate_per"].ToString(); tempdata.amount = Convert.ToDecimal(sdr1["amount"].ToString()); tempdata.rm_section = sdr1["rm_section"].ToString(); tempdata.rm_gradeofmaterial = sdr1["rm_gradeofmaterial"].ToString(); tempdata.process = sdr1["process"].ToString(); objVPO_DetList.Add(tempdata); } sdr1.Close(); objModel.ssmtbl_VendorPurchaseOrder_DetailsModel = objVPO_DetList; connection.Close(); List <ssmtbl_TermsNCondtionModel> objVPO_TnCList = new List <ssmtbl_TermsNCondtionModel>(); connection.Open(); string sqlstr2 = "uspGetVendorPO"; SqlCommand cmd2 = new SqlCommand(sqlstr2, GlobalVariables.gConn); cmd2.CommandType = System.Data.CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@Action", "fetchVPOConsumableEdittc"); cmd2.Parameters.AddWithValue("@po_no", po_no.Trim()); SqlDataReader sdr2 = cmd2.ExecuteReader(); while (sdr2.Read()) { ssmtbl_TermsNCondtionModel tempdata = new ssmtbl_TermsNCondtionModel(); tempdata.id = Convert.ToInt32(sdr2["id"].ToString()); tempdata.TermsNConditionID = Convert.ToInt32(sdr2["TermsNConditionID"].ToString()); if (sdr2["po_no"].ToString() == "") { tempdata.TermsNConditionContent = sdr2["description"].ToString(); } else { tempdata.TermsNConditionContent = sdr2["TermsNConditionContent"].ToString(); } objVPO_TnCList.Add(tempdata); } objModel.ssmtbl_TermsNCondtionModel = objVPO_TnCList; connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objModel); }
public ssmtbl_QuotationModel GetOneQuotationForApproval(string QuotationId) { ssmtbl_QuotationModel objQuot = new ssmtbl_QuotationModel(); try { string sqlstr = "Select Isnull(id,0) As id, Isnull(InquiryNo,0) As InquiryNo, Isnull(QuotationNo,'') As QuotationNo, " + " Isnull(CustomerName,'') As CustomerName, Isnull(PartDescription,'') As PartDescription, Isnull(PartNo,'') As PartNo, " + " (select Options from LKP_Inquiry_Tb IT where IT.ID=ssmtbl_Quotation.HeatTreatment and Type='Heat Treatment') As HeatTreatment," + " Isnull(Material,'') As Material, Isnull(VersionNo,'') As VersionNo, " + " Isnull(Section,'') As Section, Isnull(MachainedWeight,'') As MachainedWeight, Isnull(GrossWeight,0) As GrossWeight, " + " Isnull(CutWeight,0) As CutWeight, Isnull(NetWeight,0) As NetWeight, Isnull(ForgingCostBased,'') As ForgingCostBased, " + " Isnull(MPICostBasedOn,'') As MPICostBasedOn, Isnull(SteelCost,0) As SteelCost, Isnull(Transportation,0) As Transportation, " + " Isnull(Total,0) As Total, Isnull(TotalRowMaterialCost,0) As TotalRowMaterialCost, Isnull(CuttingSquare1,0) As CuttingSquare1, " + " Isnull(CuttingSquare2,0) As CuttingSquare2, Isnull(Forging1,0) As Forging1, ISNULL(Forging2,0) As Forging2, " + " Isnull(HeatTreatment1,0) As HeatTreatment1, Isnull(HeatTreatment2,0) As HeatTreatment2, Isnull(ShotBlasting1,0) As ShotBlasting1, " + " Isnull(ShotBlasting2,0) As ShotBlasting2, Isnull(MPI1,0) As MPI1, Isnull(MPI2,0) As MPI2, Isnull(Grinding1,0) As Grinding1, " + " Isnull(Grinding2,0) As Grinding2, Isnull(ColdCoining1,0) As ColdCoining1, Isnull(ColdCoining2,0) As ColdCoining2, " + " Isnull(Machining1,0) As Machining1, Isnull(Machining2,0) As Machining2, Isnull(DieMaintenance1,0) As DieMaintenance1, " + " Isnull(DieMaintenance2,0) As DieMaintenance2, Isnull(TotalConverstionCost,0) As TotalConverstionCost, " + " Isnull(TotalComponentCost,0) As TotalComponentCost, Isnull(InitialDieCost,0) As InitialDieCost,Isnull(PoNo,'') As PoNo, " + " Isnull(FileStatus,'') As FileStatus, Isnull(Comment,'') As Comment, Isnull(ApprovalDate,'') As ApprovalDate, " + " Isnull(ApprovedBy,'') As ApprovedBy, Isnull(CreatedOn,'') As CreatedOn, Isnull(Createdby,'') As Createdby, " + " Isnull(UpdatedOn,'') As UpdatedOn, Isnull(UpdatedBy,'') As UpdatedBy, Isnull(new_Version_No,0) As new_Version_No, " + " Isnull(UserComment,'') As UserComment From ssmtbl_Quotation where Isnull(id,0)=@QuotationId"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@QuotationId", QuotationId); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objQuot.id = Convert.ToInt32(sdr["id"].ToString()); objQuot.InquiryNo = Convert.ToInt32(sdr["InquiryNo"].ToString()); objQuot.QuotationNo = sdr["QuotationNo"].ToString(); objQuot.CustomerName = sdr["CustomerName"].ToString(); objQuot.PartDescription = sdr["PartDescription"].ToString(); objQuot.PartNo = sdr["PartNo"].ToString(); objQuot.HeatTreatmentText = sdr["HeatTreatment"].ToString(); objQuot.Material = sdr["Material"].ToString(); objQuot.VersionNo = sdr["VersionNo"].ToString(); objQuot.Section = sdr["Section"].ToString(); objQuot.MachainedWeight = sdr["MachainedWeight"].ToString(); objQuot.GrossWeight = Convert.ToDecimal(sdr["GrossWeight"].ToString()); objQuot.CutWeight = Convert.ToDecimal(sdr["CutWeight"].ToString()); objQuot.NetWeight = Convert.ToDecimal(sdr["NetWeight"].ToString()); objQuot.ForgingCostBased = sdr["ForgingCostBased"].ToString(); objQuot.MPICostBasedOn = sdr["MPICostBasedOn"].ToString(); objQuot.SteelCost = Convert.ToDecimal(sdr["SteelCost"].ToString()); objQuot.Transportation = Convert.ToDecimal(sdr["Transportation"].ToString()); objQuot.Total = Convert.ToDecimal(sdr["Total"].ToString()); objQuot.TotalRowMaterialCost = Convert.ToDecimal(sdr["TotalRowMaterialCost"].ToString()); objQuot.CuttingSquare1 = (sdr["CuttingSquare1"].ToString()); objQuot.CuttingSquare2 = (sdr["CuttingSquare2"].ToString()); objQuot.Forging1 = (sdr["Forging1"].ToString()); objQuot.Forging2 = (sdr["Forging2"].ToString()); objQuot.HeatTreatment1 = (sdr["HeatTreatment1"].ToString()); objQuot.HeatTreatment2 = (sdr["HeatTreatment2"].ToString()); objQuot.ShotBlasting1 = (sdr["ShotBlasting1"].ToString()); objQuot.ShotBlasting2 = (sdr["ShotBlasting2"].ToString()); objQuot.MPI1 = (sdr["MPI1"].ToString()); objQuot.MPI2 = (sdr["MPI2"].ToString()); objQuot.Grinding1 = (sdr["Grinding1"].ToString()); objQuot.Grinding2 = (sdr["Grinding2"].ToString()); objQuot.ColdCoining1 = (sdr["ColdCoining1"].ToString()); objQuot.ColdCoining2 = (sdr["ColdCoining2"].ToString()); objQuot.Machining1 = (sdr["Machining1"].ToString()); objQuot.Machining2 = (sdr["Machining2"].ToString()); objQuot.DieMaintenance1 = (sdr["DieMaintenance1"].ToString()); objQuot.DieMaintenance2 = (sdr["DieMaintenance2"].ToString()); objQuot.TotalConverstionCost = Convert.ToDecimal(sdr["TotalConverstionCost"].ToString()); objQuot.TotalComponentCost = Convert.ToDecimal(sdr["TotalComponentCost"].ToString()); objQuot.InitialDieCost = Convert.ToDecimal(sdr["InitialDieCost"].ToString()); objQuot.PoNo = sdr["PoNo"].ToString(); objQuot.FileStatus = sdr["FileStatus"].ToString(); objQuot.Comment = sdr["Comment"].ToString(); objQuot.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString()); objQuot.ApprovedBy = sdr["ApprovedBy"].ToString(); objQuot.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString()); objQuot.Createdby = sdr["Createdby"].ToString(); objQuot.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"].ToString()); objQuot.UpdatedBy = sdr["UpdatedBy"].ToString(); objQuot.VersionNo = sdr["VersionNo"].ToString(); objQuot.new_Version_No = Convert.ToInt32(sdr["new_Version_No"].ToString()); objQuot.UserComment = sdr["UserComment"].ToString(); } sdr.Close(); List <ssmtbl_TermsNCondtionModel> objTCList = new List <ssmtbl_TermsNCondtionModel>(); sqlstr = "Select id, Isnull(QuotationID,0) As QuotationID, Isnull(TermsNConditionID,0) As TermsNConditionID, " + " Isnull(TermsNConditionContent,'') As TermsNConditionContent From ssmtbl_TermsNCondtion where QuotationID=@id"; //+" Isnull(TermsNConditionContent,'') As TermsNConditionContent From ssmtbl_TermsNCondtion where id=@id"; cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@id", objQuot.id); sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_TermsNCondtionModel tempobj = new ssmtbl_TermsNCondtionModel(); tempobj.id = Convert.ToInt32(sdr["id"].ToString()); tempobj.QuotationID = Convert.ToInt32(sdr["QuotationID"].ToString()); tempobj.TermsNConditionID = Convert.ToInt32(sdr["TermsNConditionID"].ToString()); tempobj.TermsNConditionContent = sdr["TermsNConditionContent"].ToString(); objTCList.Add(tempobj); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objQuot); }