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