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);
}
