public void SaveSupplierPaymentDetails(long SupplierPaymentId, long SupplierId, string SupplierEmail, string bookingreference, decimal amount, bool supplierPayment, bool BookRefNo1, int status)
{
CLayer.SupplierPayment sup = new CLayer.SupplierPayment();
sup.supplierPaymentId = SupplierPaymentId;
sup.supplierId = SupplierId;
sup.SupplierEmail = SupplierEmail;
sup.OrderId = bookingreference;
sup.Amount = amount;
sup.supplierPayment = supplierPayment;
sup.Status = status;
long count = BLayer.SupplierPayment.SaveSupplierPaymentDetails(sup);
Models.SupplierPaymentModel search = new Models.SupplierPaymentModel();
List <CLayer.SupplierPayment> users = BLayer.SupplierPayment.GetAllSupllierPaymentSearch((int)CLayer.ObjectStatus.StatusType.Active, "", 0, (int)CLayer.Role.Roles.Supplier, 0, 25);
search.Status = (int)CLayer.ObjectStatus.StatusType.Active;
search.SearchString = "";
search.SearchValue = 0;
search.userlist = users;
search.TotalRows = 0;
if (users.Count > 0)
{
search.TotalRows = users[0].TotalRows;
}
search.Limit = 25;
search.currentPage = 1;
ViewBag.Filter = search;
//if (BookRefNo1)
//{
// return RedirectToAction("ReportPdf", new { SupplierPaymentId = SupplierPaymentId });
//}
// return View("~/Areas/Admin/Views/SupplierPayment/Index", search);
}
public CLayer.SupplierPayment GetPaymentdetails(string refId)
{
CLayer.SupplierPayment user = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pRefId", DataPlug.DataType._Varchar, refId));
DataTable dt = Connection.GetTable("OfflineBooking_GetAllByRefid", param);
if (dt.Rows.Count > 0)
{
user = new CLayer.SupplierPayment();
user.Buyprice = Connection.ToDouble(dt.Rows[0]["TotalBuyPrice"]);
user.propertyname = Connection.ToString(dt.Rows[0]["PropertyName"]);
user.propertycity = Connection.ToString(dt.Rows[0]["PropertyCityname"]);
// FirstName = Connection.ToString(dr["FirstName"]),
// LastName = Connection.ToString(dr["LastName"]),
user.SupplierEmail = Connection.ToString(dt.Rows[0]["SupplierEmail"]);
user.SupplierName = Connection.ToString(dt.Rows[0]["SupplierName"]);
user.Buyprice = Connection.ToDouble(dt.Rows[0]["TotalBuyPrice"]);
user.AmountPaid = Connection.ToDouble(dt.Rows[0]["amount"]);
user.SupplierMobile = Connection.ToString(dt.Rows[0]["SupplierMobile"]);
user.OrderId = Connection.ToString(dt.Rows[0]["Orderno"]);
user.CheckIn_date = Connection.ToDate(dt.Rows[0]["CheckIn_date"]);
user.CustomerName = Connection.ToString(dt.Rows[0]["CustName"]);
// DeletedDate = Connection.ToDate(dr["DeletedDate"]),
user.CheckOut_date = Connection.ToDate(dt.Rows[0]["CheckOut_date"]);
user.BookingDate = Connection.ToDate(dt.Rows[0]["BookingDate"]);
user.supplierId = Connection.ToLong(dt.Rows[0]["SupplierId"]);
user.supplierPayment = Connection.ToBoolean(dt.Rows[0]["supplierPayment"]);
}
return(user);
}
public long SaveSupplierPaymentDetails(CLayer.SupplierPayment data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSupplierPaymentId", DataPlug.DataType._BigInt, data.supplierPaymentId));
// param.Add(Connection.GetParameter("pBusinessName", DataPlug.DataType._Varchar, data.Businessname));
param.Add(Connection.GetParameter("pSupplierId", DataPlug.DataType._BigInt, data.supplierId));
param.Add(Connection.GetParameter("pOfflineSupplierEmail", DataPlug.DataType._Varchar, data.SupplierEmail));
param.Add(Connection.GetParameter("pbookingreference", DataPlug.DataType._Varchar, data.OrderId));
param.Add(Connection.GetParameter("pAmount", DataPlug.DataType._Decimal, data.Amount));
param.Add(Connection.GetParameter("pSupplierPayment", DataPlug.DataType._Bool, data.supplierPayment));
param.Add(Connection.GetParameter("pstatus", DataPlug.DataType._Bool, data.Status));
object result = Connection.ExecuteQueryScalar("SupplierPaymentDetails_Save", param);
return(Connection.ToLong(result));
}
public long SaveSupplierPayment(Models.SupplierPaymentModel dat)
{
CLayer.SupplierPayment sup = new CLayer.SupplierPayment();
sup.BAnk = dat.Bank;
sup.supplierPaymentId = dat.supplierPaymentId;
sup.supplierId = 0;
sup.SupplierEmail = dat.SupplierEmail;
sup.OrderId = ""; // dat.Supplier.OrderId;
sup.Amount = 0; // dat.Supplier.Amount;
// sup.supplierPayment = dat.Supplier.supplierPayment;
sup.grossAmount = dat.GrossAmount;
sup.modeofPayment = dat.ModeofPayment;
sup.netAmtPaid = dat.NetAmount;
sup.tdsAmount = dat.TdsAmount;
DateTime dtPayment = DateTime.MinValue;
DateTime.TryParse(dat.dtPayment, out dtPayment);
sup.pdtPayment = dtPayment;
long count = BLayer.SupplierPayment.SaveSupplierPayment(sup);
dat.supplierPaymentId = count;
return(count);
}
public long Save(CLayer.SupplierPayment data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSupplierPaymentId", DataPlug.DataType._BigInt, data.supplierPaymentId));
// param.Add(Connection.GetParameter("pBusinessName", DataPlug.DataType._Varchar, data.Businessname));
param.Add(Connection.GetParameter("pSupplierId", DataPlug.DataType._BigInt, data.FirstName));
param.Add(Connection.GetParameter("pOfflineSupplierEmail", DataPlug.DataType._Varchar, data.SupplierEmail));
param.Add(Connection.GetParameter("pbookingreference", DataPlug.DataType._Varchar, data.OrderId));
param.Add(Connection.GetParameter("pAmount", DataPlug.DataType._Decimal, data.Amount));
param.Add(Connection.GetParameter("pSupplierPayment", DataPlug.DataType._Bool, data.supplierPayment));
param.Add(Connection.GetParameter("pdtPayment", DataPlug.DataType._DateTime, data.pdtPayment));
param.Add(Connection.GetParameter("pgrossAmount", DataPlug.DataType._Decimal, data.grossAmount));
param.Add(Connection.GetParameter("ptdsAmount", DataPlug.DataType._Decimal, data.tdsAmount));
param.Add(Connection.GetParameter("pnetAmtPaid", DataPlug.DataType._Decimal, data.netAmtPaid));
param.Add(Connection.GetParameter("pmodeofPayment", DataPlug.DataType._Varchar, data.modeofPayment));
param.Add(Connection.GetParameter("pbank", DataPlug.DataType._Varchar, data.BAnk));
object result = Connection.ExecuteQueryScalar("SupplierPayment_Save", param);
return(Connection.ToLong(result));
}
public static long SaveSupplierPaymentDetails(CLayer.SupplierPayment data)
{
DataLayer.SupplierPayment user = new DataLayer.SupplierPayment();
return(user.SaveSupplierPaymentDetails(data));
}
