public ActionResult VendorResponse() { Paged_ssmtbl_VendorPurchaseOrderModel objList = new Paged_ssmtbl_VendorPurchaseOrderModel(); objList = objVPOData.AllVPOList1(); @ViewBag.RatePer = objDrop.GetRatePerList(); @ViewBag.NotAvailable = objDrop.GetNotAvailableList(); ViewData["VPOTermsAndCondition"] = GlobalFunction.GetLKP_VPOTermsAndCondition(); return(View(objList)); }
public PartialViewResult AllGIConsumables(string _inward_type) { Paged_ssmtbl_VendorPurchaseOrderModel objList = new Paged_ssmtbl_VendorPurchaseOrderModel(); objList = objVPOData.AllVPOList(_inward_type); @ViewBag.RatePer = objDrop.GetRatePerList(); @ViewBag.NotAvailable = objDrop.GetNotAvailableList(); objList.ssmtbl_GoodsInward_DocReceivedModel = objGFunc.GetGIDocReceivedList(); objList.ginNumber = objGIData.GetMaxGinNo(); ViewData["VPOTermsAndCondition"] = GlobalFunction.GetLKP_VPOTermsAndCondition(); return(PartialView(objList)); }
public Paged_ssmtbl_VendorPurchaseOrderModel AllVPOFilter(string _inward_type) { Paged_ssmtbl_VendorPurchaseOrderModel objPGVPO = new Paged_ssmtbl_VendorPurchaseOrderModel(); List <ssmtbl_VendorPurchaseOrderModel> objList = new List <ssmtbl_VendorPurchaseOrderModel>(); try { string sqlstr = "VPORequisition"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "VPOBindFilter"); cmd.Parameters.AddWithValue("@inward_type", _inward_type.Trim()); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel(); objModel.auto_id = Convert.ToInt32(sdr["auto_id"].ToString()); objModel.vendor_name = sdr["Name"].ToString(); objModel.vendor_po_type = sdr["vendor_po_type"].ToString(); objModel.po_no = (sdr["po_no"].ToString()); objModel.po_date = Convert.ToDateTime(sdr["po_date"].ToString()); objList.Add(objModel); } connection.Close(); objPGVPO.ssmtbl_VendorPurchaseOrderModelList = objList; // objPGVPO.vendor_po_type = vendor_po_type; } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objPGVPO); }
public Paged_ssmtbl_VendorPurchaseOrderModel AllVPOList(string _inward_type) { Paged_ssmtbl_VendorPurchaseOrderModel objPGVPO = new Paged_ssmtbl_VendorPurchaseOrderModel(); List <ssmtbl_VendorPurchaseOrderModel> objList = new List <ssmtbl_VendorPurchaseOrderModel>(); try { string sqlstr = "AllVPO"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "selectApprovedVPO"); cmd.Parameters.AddWithValue("@vendor_po_type", _inward_type.Trim()); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel(); objModel.vpo_id = Convert.ToInt32(sdr["vpo_id"].ToString()); //objModel.cstpo_id= Convert.ToInt32(sdr["cstpo_id"].ToString()); //objModel.CustomerPONo = sdr["CustomerPONo"].ToString(); objModel.po_no = sdr["po_no"].ToString(); objModel.dia_no = sdr["dia_no"].ToString(); objModel.vendor_name = sdr["PartyName"].ToString(); objModel.customerName = sdr["PartyName"].ToString(); objModel.po_date = Convert.ToDateTime(sdr["po_date"].ToString()); //objModel.cstPODate = Convert.ToDateTime(sdr["cstPOcreateddate"].ToString()); objModel.PartyTYpe = sdr["PartyTYpe"].ToString(); objModel.vendor_po_type = sdr["Vtype"].ToString(); //objModel.quotation_ref_no = sdr["quotation_ref_no"].ToString(); //objModel.vendor_id = Convert.ToInt32(sdr["vendor_id"].ToString()); //objModel.quotation_ref_date = Convert.ToDateTime(sdr["quotation_ref_date"].ToString()); //objModel.vendor_email = sdr["vendor_email"].ToString(); //objModel.vendor_mobile = sdr["vendor_mobile"].ToString(); //objModel.valid_date = Convert.ToDateTime(sdr["valid_date"].ToString()); //objModel.contact_person = sdr["contact_person"].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"].ToString()); //objModel.UpdatedBy = sdr["UpdatedBy"].ToString(); //objModel.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"].ToString()); //objModel.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString()); //objModel.ApprovedBy = sdr["ApprovedBy"].ToString(); objList.Add(objModel); } connection.Close(); objPGVPO.ssmtbl_GoodsInward_DocReceivedModel = objGFunc.GetGIDocReceivedList(); objPGVPO.ssmtbl_VendorPurchaseOrderModelList = objList; // objPGVPO.vendor_po_type = vendor_po_type; } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objPGVPO); }
public Paged_ssmtbl_VendorPurchaseOrderModel getAllVendorPurchaseOrder(string vendor_po_type) { Paged_ssmtbl_VendorPurchaseOrderModel objPGVPO = new Paged_ssmtbl_VendorPurchaseOrderModel(); List <ssmtbl_VendorPurchaseOrderModel> objList = new List <ssmtbl_VendorPurchaseOrderModel>(); try { string sqlstr = "ssmsp_GetAllVendorPO"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vendor_po_type", vendor_po_type); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel(); 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"].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"].ToString()); objModel.valid_date = Convert.ToDateTime(sdr["valid_date"].ToString()); objModel.contact_person = sdr["contact_person"].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"].ToString()); objModel.UpdatedBy = sdr["UpdatedBy"].ToString(); objModel.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"].ToString()); objModel.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString()); objModel.ApprovedBy = sdr["ApprovedBy"].ToString(); objList.Add(objModel); } connection.Close(); objPGVPO.ssmtbl_VendorPurchaseOrderModelList = objList; objPGVPO.vendor_po_type = vendor_po_type; } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objPGVPO); }