public static int ArchiveTransaction(long refId)
{
var ret = 0;
using (SqlConnection connection = new SqlConnection(AppConfig.DailyTranConnection))
{
string query = "MAC_sp_updateTransactionHistory";
try
{
SqlCommandBuilder cb = default(SqlCommandBuilder);
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@refId", SqlDbType.BigInt);
command.Parameters["@refId"].Value = refId;
var returnPar = command.Parameters.Add("@ReturnVal", SqlDbType.Int);
returnPar.Direction = ParameterDirection.ReturnValue;
command.ExecuteNonQuery();
return(Convert.ToInt16(returnPar.Value));
}
}
catch (Exception ex)
{
MyHelperClass.WriteLog(ex);
}
}
return(ret);
}
static void PullTransactions(int threadId)
{
try
{
Console.WriteLine("this is thread Id " + threadId);
Console.WriteLine("====================== ");
var dt = TranAccess.PullPendingTran(threadId);
foreach (DataRow dr in dt.Rows)
{
var stanVal = "";
var stanDate = new DateTime();
//stanVal = DateTime.Now.ToString("yyMMddHH") + DateTime.Now.ToString("mmss");
stanVal = MyHelperClass.GenerateRandomString(4) + DateTime.Now.ToString("ddHHmmss");
if (String.IsNullOrEmpty(dr["value_date"].ToString()))
{
stanDate = DateTime.Now;
}
else
{
stanDate = Convert.ToDateTime(dr["value_date"].ToString());
}
//MyHelperClass.WriteLog(stanVal + " for " + dr["refId"].ToString() + "== ");
LogFileWrite(stanVal + " for " + dr["refId"].ToString() + "== ", threadId);
var up = TranAccess.UpdateStan(Convert.ToInt64(dr["refId"].ToString()), stanVal, stanDate);
// post to service
var identifier = dr["transaction_type"].ToString();
if (identifier == null || identifier == "")
{
identifier = identifier.Substring(0, 3);
}
var debitAccount = dr["debit_account_number"].ToString();
var creditAccount = dr["credit_account_number"].ToString();
var currency = dr["currency"].ToString();
var transactionAmount = Convert.ToDouble(dr["transaction_amount"].ToString());
var tranParticular2 = dr["transaction_particular2"].ToString();
var transactionRefernce = dr["transaction_reference"].ToString();
var transactionParticular = dr["transaction_particular1"].ToString();
var originalRefNum = dr["original_ref_num"].ToString();
var res = PostTransaction(debitAccount, creditAccount, currency, transactionAmount, stanDate, stanVal, tranParticular2, transactionRefernce, transactionParticular, identifier, threadId, originalRefNum);
var result = res.Split('|');
var fi = TranAccess.UpdateAfterPost(Convert.ToInt64(dr["refId"].ToString()), "Y", result[1].Replace("::", "").TrimStart('7'), result[0], result[1]);
LogFileWrite(result[0] + "==" + result[1] + "==" + result[2] + "==", threadId);
}
}
catch (Exception e)
{
MyHelperClass.WriteLog(e);
LogFileWrite(e.Message, threadId);
}
}
public ActionResult GetProductRecords()
{
string Product_Id = Request.QueryString["Product_Id"];
var productrecord = interfaceobj.GetModel().Where(a => a.ID == Convert.ToInt32(Product_Id)).AsEnumerable();
// DataContext dc = new DataContext();
// var catlist = dc.FF_Category;
// //ViewBag.id = productrecord.FirstOrDefault().Category_ID.ToString();
// //ViewBag.Dropdown_Category = new SelectList(catlist, "ID", "Category", "4");
// ViewBag.Dropdown_Category = catlist
//.ToList()
//.Select(x => new SelectListItem
//{
// Value = x.ID.ToString(),
// Text = x.Category,
// Selected = (x.ID == 4)
//});
//ViewBag.Dropdown_Category = new SelectList(catlist.Select(item => new SelectListItem
//{
// Value = item.ID.ToString(),
// Text = item.Category.ToString()
// //Selected = (productrecord.Select(s => s.Category_ID).ToString() == item.ID.ToString() ? true : false)
// //Selected = "select" == item.FF_Products.FirstOrDefault().Category_ID.ToString()
//}));
var productrecordList = productrecord.Select(s => new
{
ProductId = s.ID,
BrandName = (string.IsNullOrEmpty(s.Brand) ? "" : s.Brand),
ProductName = s.Product_Name,
ProductCode = s.Product_Code,
ProductPrice = (string.IsNullOrEmpty(s.Price) ? "" : s.Price),
ProductQuantity = (string.IsNullOrEmpty(s.Quantity) ? "-" : s.Quantity),
ProductDiscount = (string.IsNullOrEmpty(s.Discount) ? "-" : s.Discount + " %"),
CreationDate = s.Creation_Date.ToString("dd-MMM-yyyy"),
Description = (string.IsNullOrEmpty(s.Description) ? "-" : s.Description),
Category = s.FF_Category.Category,
ImageCollection = MyHelperClass.GetProduct_Images(Convert.ToInt32(Product_Id))
});
return(Json(productrecordList, JsonRequestBehavior.AllowGet));
//return Json(productrecord, JsonRequestBehavior.AllowGet);
}
public static int UpdateAfterPost(long refId, string postedFlag, string tranId, string respCode, string message)
{
var ret = 0;
using (SqlConnection connection = new SqlConnection(AppConfig.DailyTranConnection))
{
string query = "MAC_sp_updateFinalTransactions";
try
{
SqlCommandBuilder cb = default(SqlCommandBuilder);
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@refId", SqlDbType.BigInt);
command.Parameters["@refId"].Value = refId;
command.Parameters.Add("@postedFlag", SqlDbType.VarChar);
command.Parameters["@postedFlag"].Value = postedFlag;
command.Parameters.Add("@tranId", SqlDbType.VarChar);
command.Parameters["@tranId"].Value = tranId;
command.Parameters.Add("@respCode", SqlDbType.VarChar);
command.Parameters["@respCode"].Value = respCode;
command.Parameters.Add("@message", SqlDbType.VarChar);
command.Parameters["@message"].Value = message;
var returnPar = command.Parameters.Add("@ReturnVal", SqlDbType.Int);
returnPar.Direction = ParameterDirection.ReturnValue;
command.ExecuteNonQuery();
return(Convert.ToInt16(returnPar.Value));
}
}
catch (Exception ex)
{
MyHelperClass.WriteLog(ex);
}
}
return(ret);
}
public ActionResult Get_ProductDetails()
{
int Product_ID = Convert.ToInt32(Request.QueryString["Product_ID"]);
using (DataContext dc = new DataContext())
{
//var displayproductrecord = dc.FF_Products.Where(a => a.ID == Product_ID).AsEnumerable();
var ProductAllImages = MyHelperClass.GetProduct_Images(Product_ID);
var displayproductrecord = dc.FF_Products.Where(a => a.ID == Product_ID).AsEnumerable().Select(s => new
{
Product_ID = s.ID,
Product_Name = s.Product_Name,
Product_Code = s.Product_Code,
Price = s.Price,
Discount = s.Discount,
Quantity = s.Quantity,
Description = s.Description,
ImageCollection = ProductAllImages
////ProductOtherDetails = s.FF_Product_SubTable.Select(b => new {
////Size = b.Product_Size
////})
});
return(Json(displayproductrecord, JsonRequestBehavior.AllowGet));
////VM_Product model = new VM_Product();
////model.ID = displayproductrecord.First().ID;
////model.Product_Name = displayproductrecord.First().Product_Name;
////model.Product_Code = displayproductrecord.First().Product_Code;
////model.Price = Convert.ToDecimal(displayproductrecord.First().Price);
////model.Discount = displayproductrecord.First().Discount;
////model.Quantity = displayproductrecord.First().Quantity;
////model.Description = displayproductrecord.First().Description;
////model.ImageCollection = ProductAllImages;
////return PartialView("_ProductQuickView", model);//F:\MVC-New\FennyFeeds\FennyFeeds\Views\Shared\_ProductQuickView.cshtml
}
}
public static DataTable PullPendingTran(int threadId)
{
var dt = new DataTable();
var da = new SqlDataAdapter();
var ds = new DataSet();
// bool OpnrtnStatus = false;
using (SqlConnection connection = new SqlConnection(AppConfig.DailyTranConnection))
{
//(Real Live Query)
string query = "MAC_sp_getPendingTransactions";
try
{
SqlCommandBuilder cb = default(SqlCommandBuilder);
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@threadId", SqlDbType.Int);
command.Parameters["@threadId"].Value = threadId;
da.SelectCommand = command;
cb = new SqlCommandBuilder(da);
da.Fill(ds);
//da.Fill(dt)
dt = ds.Tables[0];
return(dt);
}
}
catch (Exception ex)
{
MyHelperClass.WriteLog(ex);
}
}
return(dt);
}
public static int UpdateStan(long refId, string stan, DateTime sysDate)
{
var ret = 0;
using (SqlConnection connection = new SqlConnection(AppConfig.DailyTranConnection))
{
//(Real Live Query)
string query = "MAC_sp_updateStanTransactions";
try
{
SqlCommandBuilder cb = default(SqlCommandBuilder);
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@refId", SqlDbType.BigInt);
command.Parameters["@refId"].Value = refId;
command.Parameters.Add("@stan", SqlDbType.VarChar);
command.Parameters["@stan"].Value = stan;
command.Parameters.Add("@sysdate", SqlDbType.DateTime);
command.Parameters["@sysdate"].Value = sysDate;
var returnPar = command.Parameters.Add("@ReturnVal", SqlDbType.Int);
returnPar.Direction = ParameterDirection.ReturnValue;
command.ExecuteNonQuery();
return(Convert.ToInt16(returnPar.Value));
}
}
catch (Exception ex)
{
MyHelperClass.WriteLog(ex);
}
}
return(ret);
}
public ActionResult ProductQuickView()
{
int Product_ID = Convert.ToInt32(Request.QueryString["Product_ID"]);
using (DataContext dc = new DataContext())
{
var displayproductrecord = dc.FF_Products.Where(a => a.ID == Product_ID).AsEnumerable();
var ProductAllImages = MyHelperClass.GetProduct_Images(Product_ID);
VM_Product model = new VM_Product();
model.ID = displayproductrecord.First().ID;
model.Product_Name = displayproductrecord.First().Product_Name;
model.Product_Code = displayproductrecord.First().Product_Code;
model.Price = displayproductrecord.First().Price;
model.Discount = displayproductrecord.First().Discount;
model.Quantity = displayproductrecord.First().Quantity;
model.Description = displayproductrecord.First().Description;
model.ImageCollection = ProductAllImages;
return(PartialView("_ProductQuickView", model));//F:\MVC-New\FennyFeeds\FennyFeeds\Views\Shared\_ProductQuickView.cshtml
}
}
public ActionResult Get_BannerImages()
{
string[] ImageCollection = MyHelperClass.GetBanner_Images();
return(Json(ImageCollection, JsonRequestBehavior.AllowGet));
}
public ActionResult GetProductRecordsForEdit()
{
int Product_Id = Convert.ToInt32(Request.QueryString["Product_Id"]);
//Product Main Table//
var productrecord = interfaceobj.GetModel().Where(a => a.ID == Product_Id).AsEnumerable();
DataContext dc = new DataContext();
//Category for dropdownlist
var catlist = dc.FF_Category;
ViewBag.Dropdown_Category = new SelectList(catlist, "ID", "Category");
//Sub Category for dropdownlist
var subcatlist = dc.FF_Sub_Category;
ViewBag.Dropdown_SubCategory = new SelectList(subcatlist, "ID", "SubCategory");
//Product Variant for dropdownlist
var variantlist = dc.FF_Product_Variants;
ViewBag.Dropdown_Variant = new SelectList(variantlist, "ID", "Variants_Name", "Select Variant");
VM_Product modal = new VM_Product();
var Product_Variant_Id = ((dc.FF_Product_SubTable.Where(a => a.Product_Id == Product_Id).Count() > 0) ? dc.FF_Product_SubTable.Where(a => a.Product_Id == Product_Id).First().Product_Variant_Id : 0);
modal.ID = Product_Id;
modal.Category_ID = productrecord.FirstOrDefault().Category_ID;
modal.Sub_Category_ID = productrecord.FirstOrDefault().Sub_Category_ID;
//modal.Product_Variant_Id = dc.FF_Product_SubTable.FirstOrDefault(a => a.Product_Id == Product_Id).Product_Variant_Id;
modal.Product_Variant_Id = ((dc.FF_Product_SubTable.Where(a => a.Product_Id == Product_Id).Count() > 0) ? dc.FF_Product_SubTable.Where(a => a.Product_Id == Product_Id).First().Product_Variant_Id : 0);
modal.Brand = productrecord.FirstOrDefault().Brand;
modal.Product_Name = productrecord.FirstOrDefault().Product_Name;
modal.Product_Code = productrecord.FirstOrDefault().Product_Code;
modal.Price = productrecord.FirstOrDefault().Price;
modal.Quantity = productrecord.FirstOrDefault().Quantity;
modal.Discount = productrecord.FirstOrDefault().Discount;
modal.Description = productrecord.FirstOrDefault().Description;
modal.ImageCollection = MyHelperClass.GetProduct_Images(Product_Id);
if (Product_Variant_Id != 4 && Product_Variant_Id != 0)
{
modal.VariantCollectionList = dc.FF_Product_SubTable.Where(f => f.Product_Id == Product_Id).Select(s => new VariantCollection
{
Product_Sub_Table_ID = s.ID,
First_Input = (string.IsNullOrEmpty(s.Product_Size) ? (string.IsNullOrEmpty(s.Product_Colour) ? s.Product_Weight : s.Product_Colour) : s.Product_Size),
Second_Input = s.Product_Price,
Third_Input = s.Product_Quantity,
//Size = s.Product_Size,
//Colour = s.Product_Colour,
//Weight = s.Product_Weight,
//Price = s.Product_Price,
//Quantity = s.Product_Quantity
}).ToList();
}
else if (Product_Variant_Id == 4)
{
modal.VariantCollectionList = dc.FF_Product_SubTable.Where(f => f.Product_Id == Product_Id).Select(s => new VariantCollection
{
Product_Sub_Table_ID = s.ID,
First_Input = s.Product_Size,
Second_Input = s.Product_Colour,
Third_Input = s.Product_Price,
Fourth_Input = s.Product_Quantity
//Size = s.Product_Size,
//Colour = s.Product_Colour,
//Weight = s.Product_Weight,
//Price = s.Product_Price,
//Quantity = s.Product_Quantity
}).ToList();
}
return(View("PV_EditProduct", modal));
//return Json(productrecord, JsonRequestBehavior.AllowGet);
}
public static string PostTransaction(string debitAccount, string creditAccount, string currency, double amount, DateTime transValueDate, string stan, string sessionId, string tranRemarks, string appDesc, string identifier, int threadId, string tranRef)
{
var bankId = ConfigurationManager.AppSettings["bankId"];
var controllerId = ConfigurationManager.AppSettings["controllerId"];
var ipAddress = ConfigurationManager.AppSettings["finacleIp"];
// live "10.0.0.133"; // test "10.0.33.13";
var ntranDate = transValueDate;
// var te = amount.ToString();
//amount = amount * 100;
if (ConfigurationManager.AppSettings["Environment"] == "Test")
{
ntranDate = Convert.ToDateTime(ConfigurationManager.AppSettings["TestDate"]);
}
// transValueDate; //Convert.ToDateTime("2015-07-27 00:00:00");
var port = Convert.ToInt32(ConfigurationManager.AppSettings["finaclePort"]);
// live 47002; // test 48027; //
Response resCharge;
var uniqueId = stan; //MyHelperClass.GenerateRandomString(8) + DateTime.Now.Date.Second + rnd.Next();
var xFTran = new FundTransfer(controllerId, ipAddress, port);
try
{
//xFTran.ValueDate = transValueDate;
xFTran.ValueDate = ntranDate;
xFTran.Field41CardAcceptorTerminalId = "000000003REC9991";
xFTran.Field2PAN = "9890190000000000000";
switch (currency)
{
case "NGN":
xFTran.Currency = new Currency(Currency.CURRENCY_REF.NGN);
break;
case "USD":
xFTran.Currency = new Currency(Currency.CURRENCY_REF.USD);
break;
case "GBP":
xFTran.Currency = new Currency(Currency.CURRENCY_REF.GBP);
break;
case "EUR":
xFTran.Currency = new Currency(Currency.CURRENCY_REF.EUR);
break;
}
xFTran.OptionalFieldData = "70NGND000000000000000000000001D0000000000000000NGN"; //Field46
xFTran.Field37RetrievalReferenceNumber = stan;
xFTran.Field42CardAcceptorTerminalCode = "RECONCILIATION1";
xFTran.Field124InfoText = identifier;
xFTran.Field125OptionalField1 = sessionId;
xFTran.Field126OptionalField2 = tranRemarks;
xFTran.Field127OptionalField3 = tranRef;
resCharge = xFTran.Commit(amount, debitAccount, creditAccount, appDesc, uniqueId);
MyHelperClass.WriteLog(xFTran.Diagnosis.ToString());
}
catch (Exception ex)
{
// MyHelperClass.WriteLog(ex);
LogFileWrite(ex.Message, threadId);
return("-99|Error: " + ex.Message + "|" + uniqueId);
}
if (resCharge != Response.TransactionApproved)
{
return("-1|" + resCharge + "|" + uniqueId);
}
return("0|" + Right(xFTran.Diagnosis.Trim(), 9) + "|" + uniqueId);
}
public ActionResult Get_All_FeaturedProducts()
{
using (DataContext dc = new DataContext())
{
var get_allfeatured_category = dc.FF_HomePage_Display_Product.ToList();
System.Text.StringBuilder Build = new System.Text.StringBuilder();
//Check Local Path Or Server Path
string rootpath = Utility_FF.Root_Path();
foreach (var item in get_allfeatured_category)
{
var getproduct = dc.FF_Products.Where(s => s.Category_ID == item.Category_ID);
if (getproduct.Count() > 0)
{
Build.Append("<div class='row'>");
Build.Append("<h2 class='head_collections'>" + item.Title + "<span>Food Product</span></h2>");
Build.Append("</div>");
Build.Append("<div class='row'>");
Build.Append("<div class='owl-carousel owl-theme owl-featured' id='FeaturedProperties'>");
foreach (var item1 in getproduct)
{
string firstimage = "";
string secondimage = "";
var ProductAllImages = MyHelperClass.GetProduct_Images(item1.ID);
if (ProductAllImages.Count() > 0)
{
firstimage = rootpath + "/Product_Image/" + item1.ID + "/" + ProductAllImages[0];
if (ProductAllImages.Count() > 1)
{
secondimage = rootpath + "/Product_Image/" + item1.ID + "/" + ProductAllImages[1];
}
}
else
{
firstimage = rootpath + "/Product_Image/no_image.jpg";
secondimage = rootpath + "/Product_Image/no_image.jpg";
}
Build.Append("<div class=''>");
Build.Append("<div class='product-grid7'>");
Build.Append("<div class='product-image7'>");
Build.Append("<a href='../Master/ProductDetails?Product_ID=" + item1.ID + "'>");
Build.Append("<img class='pic-1' src='" + firstimage + "'>");//../content/Product_Image/" + item1.ID + "/Image-1.jpg
Build.Append("<img class='pic-2' src='" + secondimage + "'>");
Build.Append("</a>");
Build.Append("<ul class='social'>");
Build.Append("<li><a href='' class='mdi mdi-magnify' onclick='Get_ProductQuickView(" + item1.ID + ")' data-toggle='modal' data-target=''></a></li>");
Build.Append("<li><a href='' class='mdi mdi-heart' onclick=CheckUserLoginOrNot('addproduct_to_wishlist','" + item1.ID + "') data-toggle='modal' data-target=''></a></li>");
Build.Append("<li><a href='' class='mdi mdi-cart' data-toggle='modal' data-target='#slidermodal'></a></li>");
Build.Append("</ul>");
Build.Append("</div>");
Build.Append("<div class='product-content'>");
Build.Append("<h3 class='title'><a href='#'>" + item1.Product_Name + "</a></h3>");
Build.Append("");
Build.Append("<div class='price'>");
Build.Append("<span class='featured-price wrap-text'><i class='mdi mdi-currency-inr mr-2'></i>" + item1.Price + "</span>");
Build.Append("</div>");
Build.Append("</div>");
Build.Append("</div>");
Build.Append("</div>");
}
Build.Append("</div>");
Build.Append("</div>");
}
}
return(Json(Build.ToString(), JsonRequestBehavior.AllowGet));
}
}
