public bool IsCategoryNameExist(CategoryVM cat) { ExcellentMarketResearchEntities db = new ExcellentMarketResearchEntities(); bool flag = false; //same name of child and parent cat,to check that find out the catid of same catname var Catid = db.CategoryMasters.Where(x => x.CategoryName == cat.CategoryName).Select(x => x.CategoryId).FirstOrDefault(); //Same name of Category of same parentcategory, to check that find out the parent of same catname var Parentcatid = db.CategoryMasters.Where(x => x.CategoryName == cat.CategoryName).Select(x => x.ParentCategoryId).FirstOrDefault(); if (Catid != 0 || Parentcatid != null) { //check the condition if true duplicate catname error ... if (Catid == cat.ParentCategoryId || Parentcatid == cat.ParentCategoryId) { flag = true; } else { flag = false; } } else { flag = false; } return(flag); }
public static BuyingInfo GetBuyerByGuId(string guid) { ExcellentMarketResearchEntities db = new ExcellentMarketResearchEntities(); //var buyer = db.BuyingInfoes.Where(x => x.GuId == guid).Select new BuyingInfo( //).FirstOrDefault(); var buyer = (from l in db.BuyingInfoes where l.GuId == guid select l).FirstOrDefault(); return(buyer); }
public static bool PayPalProcess(PaymentLibrary.PayPal.PayPalResponse paypalResponse) { ExcellentMarketResearchEntities db = new ExcellentMarketResearchEntities(); if (paypalResponse != null && (!string.IsNullOrEmpty(paypalResponse.PAYERID) || !string.IsNullOrEmpty(paypalResponse.guid))) { BuyingInfo b = new BuyingInfo(); if (string.IsNullOrEmpty(paypalResponse.PAYERID)) { log4net.LogManager.GetLogger("Error").Error("PayerID not found OR Response is null OR guid is not found.\nData - " + Newtonsoft.Json.JsonConvert.SerializeObject(paypalResponse)); } //TODO: Get buyer from table using guid var buyer = GetBuyerByGuId(paypalResponse.guid); //bool IsBuyerExist= buyer.Count(x=>x.GuId==paypalResponse.guid)>0?true:false; bool IsBuyerExist = buyer != null ? true : false; //TODO: Check buyer if exist or not if (IsBuyerExist == null) { // log4net.logmanager.getlogger("error").error("buyer not found.\ndata - " + newtonsoft.json.jsonconvert.serializeobject(paypalresponse)); return(false); } ValidResponse vResponse = PaymentLibrary.PayPal.PayPal.IsPaymentValid(paypalResponse, PayPalConfig.GetConfiguration(HttpContext.Current.Server.MapPath("/paypalconfig/paypal.config"), false), false); if (vResponse.IsValid) { //TODO: update status of payment transaction to success var updatestatus = db.BuyingInfoes.Where(x => x.GuId == paypalResponse.guid).FirstOrDefault(); b.PaymentTransaction = true; updatestatus.PaymentTransaction = b.PaymentTransaction; db.Entry(updatestatus).State = EntityState.Modified; db.SaveChanges(); return(true); } Newtonsoft.Json.JsonSerializer serializer = new Newtonsoft.Json.JsonSerializer(); Stream s = new MemoryStream(); TextWriter t = new StreamWriter(s); serializer.Serialize(t, paypalResponse); TextReader r = new StreamReader(s); //TODO: Save error to db //_saveStatus(, 'f', vResponse.Reason + "|ErrorCode - " + vResponse.ErrorCode + "|PaypalResponse - " + r.ReadToEnd()); var saveError = db.BuyingInfoes.Where(x => x.GuId == paypalResponse.guid).FirstOrDefault(); b.PaymentTransaction = false; saveError.PaymentTransaction = b.PaymentTransaction; saveError.ErrorReason = vResponse.Reason; saveError.ErrorCode = vResponse.ErrorCode; db.Entry(saveError).State = EntityState.Modified; db.SaveChanges(); return(false); } return(false); }
public CategoryRepository() { db = new ExcellentMarketResearchEntities(); }