public CLayer.SupplierInvoice getGetSupplierInvoicedetails(long ID) { CLayer.SupplierInvoice result = new CLayer.SupplierInvoice(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSupplierInvID", DataPlug.DataType._BigInt, ID)); DataTable dt = Connection.GetTable("getGetSupplierInvoicedetails", param); if (dt.Rows.Count > 0) { result = new CLayer.SupplierInvoice(); result.SupplierInvoiceID = Connection.ToLong(dt.Rows[0]["SupplierInvoiceID"]); result.PropertyId = Connection.ToLong(dt.Rows[0]["PropertyID"]); result.Property_Name = Connection.ToString(dt.Rows[0]["Title"]); result.SupplierId = Connection.ToLong(dt.Rows[0]["SupplierID"]); result.InvoiceNumber = Connection.ToString(dt.Rows[0]["InvoiceNumber"]); result.InvoiceDate = Connection.ToDate(dt.Rows[0]["InvoiceDate"]); result.ServiceTaxRegNumber = Connection.ToString(dt.Rows[0]["ServiceTaxRegNumber"]); result.PAN_Number = Connection.ToString(dt.Rows[0]["PAN"]); result.BaseAmount = Connection.ToDecimal(dt.Rows[0]["BaseAmount"]); result.LuxuryTax = Connection.ToDecimal(dt.Rows[0]["LuxuryTax"]); result.ServiceTax = Connection.ToDecimal(dt.Rows[0]["ServiceTax"]); result.TotalInvoiceValue = Connection.ToDecimal(dt.Rows[0]["TotalInvoiceValue"]); result.EntryDate = Connection.ToDate(dt.Rows[0]["EntryDate"]); result.txtTotalAdjustmentResult = Connection.ToDecimal(dt.Rows[0]["TotalAdjustment"]); result.PropertyEmailAddresss = Connection.ToString(dt.Rows[0]["PropertyEmailAddress"]); result.PropertyType = Connection.ToString(dt.Rows[0]["PropertyType"]); result.TaxType = Connection.ToInteger(dt.Rows[0]["TaxType"]); result.IsSupInvoicedone = Connection.ToBoolean(dt.Rows[0]["IsSupInvoicedone"]); result.BookingRefNumber = Connection.ToString(dt.Rows[0]["BookingReferenceIDNo"]); result.CheckedBookingRefNumber = Connection.ToString(dt.Rows[0]["CheckedBookingReferenceIDNo"]); } return(result); }
public long Save(CLayer.SupplierInvoice data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSupplierInvoiceID", DataPlug.DataType._BigInt, data.SupplierInvoiceID)); param.Add(Connection.GetParameter("pPropertyID", DataPlug.DataType._Int, data.PropertyId)); param.Add(Connection.GetParameter("pSupplierID", DataPlug.DataType._Int, data.SupplierId)); param.Add(Connection.GetParameter("pInvoiceNumber", DataPlug.DataType._Text, data.InvoiceNumber)); param.Add(Connection.GetParameter("pInvoiceDate", DataPlug.DataType._DateTime, data.InvoiceDate)); param.Add(Connection.GetParameter("pServiceTaxRegNumber", DataPlug.DataType._Text, data.ServiceTaxRegNumber)); param.Add(Connection.GetParameter("pPAN", DataPlug.DataType._Text, data.PAN_Number)); param.Add(Connection.GetParameter("pBaseAmount", DataPlug.DataType._Decimal, data.BaseAmount)); param.Add(Connection.GetParameter("pLuxuryTax", DataPlug.DataType._Decimal, data.LuxuryTax)); param.Add(Connection.GetParameter("pServiceTax", DataPlug.DataType._Decimal, data.ServiceTax)); param.Add(Connection.GetParameter("pTotalInvoiceValue", DataPlug.DataType._Decimal, data.TotalInvoiceValue)); param.Add(Connection.GetParameter("pEntryDate", DataPlug.DataType._DateTime, data.EntryDate)); param.Add(Connection.GetParameter("ptxtTotalAdjustmentResult", DataPlug.DataType._Decimal, data.txtTotalAdjustmentResult)); param.Add(Connection.GetParameter("pPropertyEmailAddresss", DataPlug.DataType._Text, data.PropertyEmailAddresss)); param.Add(Connection.GetParameter("pPropertyType", DataPlug.DataType._Text, data.PropertyType)); param.Add(Connection.GetParameter("pTaxType", DataPlug.DataType._Text, data.TaxType)); param.Add(Connection.GetParameter("pIsSupInvoicedone", DataPlug.DataType._Bool, data.IsSupInvoicedone)); object result = Connection.ExecuteQueryScalar("SupplierInvoice_save", param); return(Connection.ToInteger(result)); }
public ActionResult Details(long ID = 0, bool isFromList = false) { Models.SuppierInvoiceModel model = new Models.SuppierInvoiceModel(); int TotalRows_Booking; try { if (ID > 0) { CLayer.SupplierInvoice data = new CLayer.SupplierInvoice(); data = BLayer.SupplierInvoice.getGetSupplierInvoicedetails(ID); model.SupplierInvoiceID = data.SupplierInvoiceID; model.PropertyId = data.PropertyId; model.SupplierId = data.SupplierId; model.PropertyName = data.Property_Name; model.InvoiceNumber = data.InvoiceNumber; model.InvoiceDate = data.InvoiceDate == null ? "" : Convert.ToString(data.InvoiceDate.ToString("dd/MM/yyyy")); model.ServiceTaxRegNumber = data.ServiceTaxRegNumber; model.PAN_Number = data.PAN_Number; model.BaseAmount = data.BaseAmount; model.LuxuryTax = data.LuxuryTax; model.ServiceTax = data.ServiceTax; model.TotalInvoiceValue = data.TotalInvoiceValue; model.EntryDate = data.EntryDate == null ? "" : Convert.ToString(data.EntryDate.ToString("dd/MM/yyyy")); model.txtTotalAdjustmentResult = data.txtTotalAdjustmentResult; model.isFromList = isFromList; model.PropertyEmailAddresss = data.PropertyEmailAddresss; model.PropertyType = data.PropertyType; model.TaxType = data.TaxType; model.IsSupInvoicedone = data.IsSupInvoicedone; model.BookingRefIDs = data.BookingRefNumber; model.checkedBookingRefIDs = data.CheckedBookingRefNumber; if (data.PropertyId > 0 && ID > 0) { model.BookingList = BLayer.SupplierInvoice.SupplierInvoiceBookingList(data.PropertyId, ID, "", data.PropertyEmailAddresss, data.PropertyType, 0, LIMIT_Booking, 2, out TotalRows_Booking); model.currentPage_Booking = 1; model.Limit_Booking = LIMIT_Booking; model.TotalRows_Booking = TotalRows_Booking; //model.savedBookingList = null; model.savedBookingList = BLayer.SupplierInvoice.SupplierInvoiceSavedBookingList(data.PropertyId, ID, "", data.PropertyEmailAddresss, data.PropertyType); } } } catch (Exception ex) { Common.LogHandler.HandleError(ex); } return(View("~/Areas/Admin/Views/SupplierInvoiceDetails/Index.cshtml", model)); }
public List <CLayer.SupplierInvoice> getSupplierInvoiceList_Report(long Start, long Limit, DateTime?fromDT, DateTime?toDT) { fromDT = fromDT == DateTime.MinValue ? null : fromDT; toDT = toDT == DateTime.MinValue ? null : toDT; List <CLayer.SupplierInvoice> result = new List <CLayer.SupplierInvoice>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pfromDT", DataPlug.DataType._Date, fromDT)); param.Add(Connection.GetParameter("ptoDT", DataPlug.DataType._Date, toDT)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._BigInt, Start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._BigInt, Limit)); DataSet ds = Connection.GetDataSet("getGetSupplierInvoiceList_Report", param); CLayer.SupplierInvoice res = null; if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[1].Rows) { res = new CLayer.SupplierInvoice(); res.SupplierInvoiceID = Connection.ToLong(dr["SupplierInvoiceID"]); res.PropertyId = Connection.ToLong(dr["PropertyID"]); res.Property_Name = Connection.ToString(dr["Title"]); res.SupplierId = Connection.ToLong(dr["SupplierID"]); res.SupplierName = Connection.ToString(dr["SupplierName"]); res.City = Connection.ToString(dr["City"]); res.InvoiceNumber = Connection.ToString(dr["InvoiceNumber"]); res.InvoiceDate = Connection.ToDate(dr["InvoiceDate"]); res.ServiceTaxRegNumber = Connection.ToString(dr["ServiceTaxRegNumber"]); res.PAN_Number = Connection.ToString(dr["PAN"]); res.BaseAmount = Connection.ToDecimal(dr["BaseAmount"]); res.LuxuryTax = Connection.ToDecimal(dr["LuxuryTax"]); res.ServiceTax = Connection.ToDecimal(dr["ServiceTax"]); res.TotalInvoiceValue = Connection.ToDecimal(dr["TotalInvoiceValue"]); res.EntryDate = Connection.ToDate(dr["EntryDate"]); res.SupplierInvoiceBooking_ID = Connection.ToLong(dr["SupplierInvoiceBooking_ID"]); res.BookingRefNumber = Connection.ToString(dr["BookingRefNumber"]); res.CheckIn_date = Connection.ToDate(dr["CheckIn_date"]); res.CheckOut_date = Connection.ToDate(dr["CheckOut_date"]); res.BookinCreatedDT = Connection.ToDate(dr["BookinCreatedDT"]); res.TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]); result.Add(res); } } return(result); }
public List <CLayer.SupplierInvoice> getSupplierInvoiceList(string searchText, int searchType, int Start, int Limit, int TaxType, int Status) { List <CLayer.SupplierInvoice> result = new List <CLayer.SupplierInvoice>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSearchText", DataPlug.DataType._Text, searchText)); param.Add(Connection.GetParameter("pSearchType", DataPlug.DataType._Int, searchType)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit)); param.Add(Connection.GetParameter("pTaxType", DataPlug.DataType._Int, TaxType)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status)); DataSet ds = Connection.GetDataSet("getGetSupplierInvoiceList_Pager", param); CLayer.SupplierInvoice res = null; if (ds.Tables[1].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[1].Rows) { res = new CLayer.SupplierInvoice(); res.SupplierInvoiceID = Connection.ToLong(dr["SupplierInvoiceID"]); res.PropertyId = Connection.ToLong(dr["PropertyID"]); res.Property_Name = Connection.ToString(dr["Title"]); res.SupplierId = Connection.ToLong(dr["SupplierID"]); res.SupplierName = Connection.ToString(dr["SupplierName"]); res.City = Connection.ToString(dr["City"]); res.InvoiceNumber = Connection.ToString(dr["InvoiceNumber"]); res.InvoiceDate = Connection.ToDate(dr["InvoiceDate"]); res.ServiceTaxRegNumber = Connection.ToString(dr["ServiceTaxRegNumber"]); res.PAN_Number = Connection.ToString(dr["PAN"]); res.BaseAmount = Connection.ToDecimal(dr["BaseAmount"]); res.LuxuryTax = Connection.ToDecimal(dr["LuxuryTax"]); res.ServiceTax = Connection.ToDecimal(dr["ServiceTax"]); res.TotalInvoiceValue = Connection.ToDecimal(dr["TotalInvoiceValue"]); res.EntryDate = Connection.ToDate(dr["EntryDate"]); res.TaxType = Connection.ToInteger(dr["TaxType"]); res.TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]); result.Add(res); } } return(result); }
public static long Save(CLayer.SupplierInvoice data) { DataLayer.SupplierInvoice acc = new DataLayer.SupplierInvoice(); return(acc.Save(data)); }
public ActionResult saveSupplierInvoiceDetails(Models.SuppierInvoiceModel model) { try { CLayer.SupplierInvoice data = new CLayer.SupplierInvoice(); data.SupplierInvoiceID = model.SupplierInvoiceID; data.PropertyId = model.PropertyId; data.SupplierId = model.SupplierId; data.InvoiceNumber = model.InvoiceNumber; data.InvoiceDate = model.InvoiceDate == null ? DateTime.Now : DateTime.ParseExact(model.InvoiceDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); data.ServiceTaxRegNumber = model.ServiceTaxRegNumber; data.PAN_Number = model.PAN_Number; data.BaseAmount = model.BaseAmount; data.LuxuryTax = model.LuxuryTax; data.ServiceTax = model.ServiceTax; data.TotalInvoiceValue = model.TotalInvoiceValue; data.EntryDate = model.EntryDate == null ? DateTime.Now : DateTime.ParseExact(model.EntryDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); data.txtTotalAdjustmentResult = model.txtTotalAdjustmentResult; data.PropertyEmailAddresss = model.PropertyEmailAddresss; data.PropertyType = model.PropertyType; data.TaxType = model.TaxType; data.IsSupInvoicedone = model.IsSupInvoicedone; long ID = BLayer.SupplierInvoice.Save(data); data.SupplierInvoiceID = ID; if (ID > 0) { if (model.BookingRefIDsWithValue != null) { if (model.BookingRefIDsWithValue.Length > 0) { List <CLayer.OfflineBooking> lis = new List <CLayer.OfflineBooking>(); foreach (string num in model.BookingRefIDsWithValue.Split(',').ToList <string>()) { string[] numwtvle = num.Split('#'); string BkgNum = numwtvle[0]; bool isChecked = false; string dupe_num = BkgNum == null ? "" : BkgNum; if (dupe_num.Trim() != "") { if (model.checkedBookingRefIDs != null) { foreach (string chkNum in model.checkedBookingRefIDs.Split(',').ToList <string>()) { string checkedNum = chkNum == null ? "" : chkNum; if (checkedNum != "") { if (dupe_num == checkedNum) { isChecked = true; } } } } else { isChecked = false; } CLayer.OfflineBooking rs = new CLayer.OfflineBooking(); rs.ConfirmationNumber = BkgNum; rs.SupplierInvoiceID = ID; rs.isOpen = isChecked; decimal SupInvoiceValueBRef = 0; if (numwtvle[1] == null) { SupInvoiceValueBRef = 0; } else { SupInvoiceValueBRef = Convert.ToDecimal(numwtvle[1]); } decimal PaidValueBRef = 0; if (numwtvle[2] == null) { PaidValueBRef = 0; } else { PaidValueBRef = Convert.ToDecimal(numwtvle[2]); } rs.SupInvoiceValueBRef = SupInvoiceValueBRef; rs.PaidValueBRef = PaidValueBRef; lis.Add(rs); } } if (lis != null) { if (lis.Count() > 0) { BLayer.SupplierInvoice.saveSupplierInvoiceBooking(lis); } } } } } } catch (Exception ex) { Common.LogHandler.HandleError(ex); } if (model.TaxType == (int)CLayer.SupplierInvoice.TaxTypes.ServiceTax) { if (model.isFromList) { return(RedirectToAction("getSupplierInvoiceList")); } else { return(RedirectToAction("Index")); } } else { if (model.isFromList) { return(RedirectToAction("getSupplierInvoiceListForgst")); } else { return(RedirectToAction("GSTIndex")); } } }