// GET: AuctionsAdmin/Create
public ActionResult Create()
{
//ViewBag.Path = "~/Images/";
ltRollDescription rol = new ltRollDescription();
DefaultSetup defaultSetup = db.DefaultSetups.FirstOrDefault(t => t.Active == true);
rol.BackgroundColor = defaultSetup.BackgroundColor;
rol.FontColor = defaultSetup.FontColor;
rol.RefreshTime = defaultSetup.RefreshTime;
rol.StartDate = DateTime.Now;
rol.EndDate = DateTime.Now;
rol.AuctionDelayTime = 5;
rol.LogoPath = defaultSetup.LogoPath;
rol.LogoName = defaultSetup.LogoName;
rol.SmallLogoName = defaultSetup.SmallLogoName;
rol.RollImagesPath = defaultSetup.RollImagesPath;
rol.SmsNotification = true;
rol.LogoBackgroundColor = defaultSetup.LogoBackgroundColor;
rol.smsOutBidder = defaultSetup.smsOutBidder;
rol.RollImagesBackColor = defaultSetup.BackgroundColor;
rol.HomePeriodDescriptionBackColor = defaultSetup.HomePeriodDescriptionBackColor;
rol.ActionBackColor = defaultSetup.ActionBackColor;
rol.RollActionBidColor = defaultSetup.RollActionBidColor;
rol.RollActionBackIndexColor = defaultSetup.RollActionBackIndexColor;
return(View(rol));
}
public ActionResult DeleteConfirmed(int id)
{
ltRollDescription ltRollDescription = db.ltRollDescriptions.Find(id);
db.ltRollDescriptions.Remove(ltRollDescription);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Description,Active,BackgroundColor,FontColor,RefreshTime,StartDate,EndDate,AuctionDelayTime,SortPosition,LogoPath,LogoName,SmallLogoName,RollImagesPath,SmsNotification,LogoBackgroundColor, smsOutBidder, RollImagesBackColor, HomePeriodDescription, HomePeriodDescriptionTextColor, HomePeriodDescriptionBackColor, ActionTextColor, ActionBackColor, RollActionBidColor, RollActionBackIndexColor")] ltRollDescription ltRollDescription)
{
if (ModelState.IsValid)
{
db.Entry(ltRollDescription).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ltRollDescription));
}
// GET: AuctionsAdmin/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ltRollDescription ltRollDescription = db.ltRollDescriptions.Find(id);
if (ltRollDescription == null)
{
return(HttpNotFound());
}
return(View(ltRollDescription));
}
// GET: RollAdmin/Create
public ActionResult Create()
{
int?AuctionID;
if (Session["SelectedAuctionID"] == null) // IF sesion var not created yet, create
{
BidController bd = new BidController();
DefaultSetupModel dm = bd.LoadDefs(0); // Get the default values
AuctionID = dm.DefaultAuction;
Session["SelectedAuctionID"] = AuctionID.ToString(); // Set sesion var met wat geselekteer is
}
else
{
AuctionID = Int32.Parse(Session["SelectedAuctionID"].ToString());
}
ViewBag.auctionID = AuctionID;
ViewBag.RollId = new SelectList(db.ltRollDescriptions, "ID", "Description", AuctionID);
// ViewBag.RollId = new SelectList(db.ltRollDescriptions, "ID", "Description");
ViewBag.SpeciesCode = new SelectList(db.ltSpecies, "ID", "Description");
ViewBag.BuyerId = new SelectList(db.tblCustomers, "ID", "CompanyName");
ViewBag.SellerId = new SelectList(db.tblCustomers, "ID", "CompanyName");
tblRoll rol = new tblRoll();
ltRollDescription ltRollDescription = db.ltRollDescriptions.Find(AuctionID);
if (ltRollDescription != null)
{
rol.Quantity_Lot = "Animal";
rol.OnAuction = true;
rol.DateTimeClose = ltRollDescription.EndDate;
rol.DateLoaded = DateTime.Now;
rol.BidOpen = true;
}
return(View(rol));
}
// Hier
public Bid BidLogic(Bid bid)
{
currentBuyer.NewBuyerHaveCellNumber = false;
currentBuyer.OutBuyerHaveCellNumber = false;
currentBuyer.NewBuyerID = bid.BuyerId; // Die nuwe id wat oorkom.
using (AuctionDBEntities db = new AuctionDBEntities()) // make sure to get the latest info from DB and not the immage of DB.
{
tblRoll tblRollAfter = db.tblRolls.Find(bid.ID); // find the latest info on db.
if (tblRollAfter.Increments == null)
{
tblRollAfter.Increments = 0;
}
if (tblRollAfter.BiddingPrice == null)
{
tblRollAfter.BiddingPrice = 0;
}
if (bid.NewBidPrice >= (tblRollAfter.BiddingPrice + tblRollAfter.Increments))
{
double ExtendBitTime;
bool AuctionSMS = false;
ltRollDescription ltRollDescriptions = db.ltRollDescriptions.Find(bid.RollId);
if (ltRollDescriptions != null)
{
ExtendBitTime = System.Convert.ToDouble(ltRollDescriptions.AuctionDelayTime);
AuctionSMS = ltRollDescriptions.SmsNotification;
}
else
{
ExtendBitTime = 5;
AuctionSMS = false;
}
//
bid.BidTotalPrice = bid.NewBidPrice * tblRollAfter.Quantity;
if (DateTime.Now <= tblRollAfter.DateTimeClose)
{
tblRollAfter.DateTimeBid = DateTime.Now;
if (DateTime.Now.AddMinutes(ExtendBitTime) >= tblRollAfter.DateTimeClose)
{
tblRollAfter.DateTimeClose = DateTime.Now.AddMinutes(ExtendBitTime); // add time before close.
db.UpdateBidTimeClose(bid.ID, tblRollAfter.DateTimeClose);
}
// Kan later weer terugsit.
//if (currentBuyer.NewBuyerID != tblRollAfter.BuyerId) // Not same outgoing and new bidder.
//{
// Get outgoing bidder info
tblCustomer tblCustomersOut = db.tblCustomers.Find(tblRollAfter.BuyerId);
currentBuyer.OutBuyerCell = tblCustomersOut.Phone;
if (currentBuyer.OutBuyerCell != null && currentBuyer.OutBuyerCell != "")
{
currentBuyer.OutBuyerHaveCellNumber = true;
}
// Get incomming bidder info
tblCustomer tblCustomersIn = db.tblCustomers.Find(currentBuyer.NewBuyerID);
currentBuyer.NewBuyerCell = tblCustomersIn.Phone;
if (currentBuyer.NewBuyerCell != null && currentBuyer.NewBuyerCell != "")
{
currentBuyer.NewBuyerHaveCellNumber = true;
}
// }
// Huidige koper
// Laaste voor update.
tblRoll tblRollLast = db.tblRolls.Find(bid.ID); // find the latest info on db.
if (tblRollLast.Increments == null)
{
tblRollLast.Increments = 0;
}
if (tblRollLast.BiddingPrice == null)
{
tblRollLast.BiddingPrice = 0;
}
if (bid.NewBidPrice >= (tblRollLast.BiddingPrice + tblRollLast.Increments))
{
if (tblRollLast.Quantity_Lot == "Lot")
{
bid.BidTotalPrice = bid.NewBidPrice;
}
else
{
bid.BidTotalPrice = bid.NewBidPrice * tblRollAfter.Quantity;
}
// Kry die Auction Buyer Nommer
string AuctionBuyerNumber;
BuyerNo buyeNo = db.BuyerNoes.FirstOrDefault(t => t.CustomerID == bid.BuyerId && t.RollID == bid.RollId);
if (buyeNo == null)
{
AuctionBuyerNumber = "INT " + bid.BuyerId.ToString();
}
else
{
AuctionBuyerNumber = "B " + buyeNo.BuyerNumber;
}
db.UpdateBidder(bid.ID, bid.BuyerId, bid.NewBidPrice, bid.BidTotalPrice, tblRollAfter.DateTimeBid, AuctionBuyerNumber);
db.AddBidHistory(bid.ID, bid.RollId, tblRollAfter.Lot, tblRollAfter.SellerId, bid.BuyerId, bid.NewBidPrice, bid.BidTotalPrice, tblRollAfter.DateTimeBid, bid.UserID);
// Laai defaults
DefaultSetupModel dm = LoadDefs(0); // Get the default values vir stuur van sms
// Sal net sms stuur as koper cell het, spesifieke auction verys dit en default is aan.
// Sms outgoing bidder
if (currentBuyer.OutBuyerHaveCellNumber && AuctionSMS && dm.SMSAllFunctionality == true && dm.SMSOutBidder == true)
{
string x = string.Format("{0:0,000}", bid.NewBidPrice);
smsMGT smg = new smsMGT();
string messagestring = $"Silent auction: Your bid for Lot {tblRollAfter.Lot} has been exceeded. Current bid is : R {x}";
var res = smg.SendSingleSMS("1", currentBuyer.OutBuyerCell, messagestring);
if (res != "success")
{
string EmailSubject = "SMS NOT sent successfully";
string EMailBody = $"SMS NOT sent successfully to out bidder {tblCustomersOut.CompanyName}" + ". Error = " + res;
sendEmail sm = new sendEmail();
string emalres = sm.SendEmailFB("*****@*****.**", EmailSubject, EMailBody, null, null);
}
}
// Sms new bidder.
if (currentBuyer.NewBuyerHaveCellNumber && AuctionSMS && dm.SMSAllFunctionality == true && dm.SMSNewBidder == true)
{
string y = string.Format("{0:0,000}", bid.NewBidPrice);
smsMGT smg = new smsMGT();
string messagestring = $"Silent auction: Your bid for Lot {tblRollAfter.Lot} has been accepted. Your bid is : R {y}";
var res = smg.SendSingleSMS("1", currentBuyer.NewBuyerCell, messagestring);
if (res != "success")
{
string EmailSubject = "SMS NOT sent successfully";
string EMailBody = $"SMS NOT sent successfully to new bidder {tblCustomersIn.CompanyName}" + " " + res;
sendEmail sm = new sendEmail();
string emalres = sm.SendEmailFB("*****@*****.**", EmailSubject, EMailBody, null, null);
}
}
if (bid.NewBidPrice >= (tblRollAfter.BiddingPrice + (tblRollAfter.Increments * 10)))
{
// email warning to NWWT
sendEmail sm = new sendEmail();
string y = string.Format("{0:0,000}", bid.NewBidPrice);
string z = string.Format("{0:0,000}", tblRollAfter.BiddingPrice);
string EmailSubject = "An extraordinary high bid received";
string EMailBody = $"An extraordinary high bid was made on Lot {tblRollAfter.Lot} by {tblCustomersIn.CompanyName}. The new bid is : R {y} and the previous bid was R {z}";
string res = sm.SendEmailFB("*****@*****.**", EmailSubject, EMailBody, null, null);
}
}
else
{
bid.bidToLow = true;
}
}
else
{
bid.bidClosed = true;
}
}
else
{
bid.bidToLow = true;
}
}
return(bid);
}
public DefaultSetupModel LoadDefs(int?AuctionID)
{
DefaultSetupModel ds = new DefaultSetupModel();
// Laai eers alles vanaf DefaultSetup table.
DefaultSetup defaultSetup = db.DefaultSetups.FirstOrDefault(t => t.Active == true);
if (defaultSetup != null) // het gekry.
{
ds.ID = AuctionID; // Het gekry en rollID is dus reg.
ds.Description = defaultSetup.Description;
ds.BackgroundColor = defaultSetup.BackgroundColor;
ds.FontColor = defaultSetup.FontColor;
ds.LogoBackgroundColor = defaultSetup.LogoBackgroundColor;
ds.RefreshTime = defaultSetup.RefreshTime.ToString();
ds.RollImagePath = defaultSetup.RollImagesPath;
ds.Active = defaultSetup.Active;
ds.LogoPath = defaultSetup.LogoPath;
ds.LogoName = defaultSetup.LogoName;
ds.SmallLogoName = defaultSetup.LogoPath;
ds.RollImagePath = defaultSetup.RollImagesPath;
ds.AuctionDelayTime = defaultSetup.AuctionDelayTime.ToString();
ds.SMSNewBidder = defaultSetup.SmsNotification;
ds.SMSAllFunctionality = defaultSetup.SMSAllFunctionality;
ds.SMSCustRegistration = defaultSetup.SMSCustRegistration;
ds.SMSConfirmationLoginRequired = defaultSetup.SMSConfirmationLoginRequired;
ds.emailConfirmRegistration = defaultSetup.emailConfirmRegistration;
ds.emailConfirmationLoginRequired = defaultSetup.emailConfirmationLoginRequired;
ds.BackgroundColorHome = defaultSetup.BackgroundColorHome;
ds.DispLines = defaultSetup.DispLines;
ds.DispColumns = defaultSetup.DispColumns;
ds.pageSize = ds.DispLines * ds.DispColumns;
ds.RollDispRefreshRate = defaultSetup.RollDispRefreshRate;
ds.HomePeriodDescription = defaultSetup.HomePeriodDescription;
ds.HomePeriodDescriptionTextColor = defaultSetup.HomePeriodDescriptionTextColor;
ds.HomePeriodDescriptionBackColor = defaultSetup.HomePeriodDescriptionBackColor;
ds.ActionTextColor = defaultSetup.ActionTextColor;
ds.ActionBackColor = defaultSetup.ActionBackColor;
if (defaultSetup.DefaultAuction != null)
{
ds.DefaultAuction = defaultSetup.DefaultAuction;
}
else
{
ds.DefaultAuction = 0;
}
ds.SMSOutBidder = defaultSetup.smsOutBidder;
ds.message = "Please select an Auction";
}
if (AuctionID != 0) // Laai rol spesifieke inligting
{
ltRollDescription ltRollDescriptions = db.ltRollDescriptions.Find(AuctionID);
if (ltRollDescriptions != null) // het gekry.
{
ds.ID = AuctionID; // Het gekry en rollID is dus reg.
ds.AuctionID = AuctionID.ToString(); // String van ID
ds.Description = ltRollDescriptions.Description;
ds.BackgroundColor = ltRollDescriptions.BackgroundColor;
ds.FontColor = ltRollDescriptions.FontColor;
ds.LogoBackgroundColor = ltRollDescriptions.LogoBackgroundColor;
ds.RefreshTime = ltRollDescriptions.RefreshTime.ToString();
ds.RollImagePath = ltRollDescriptions.RollImagesPath;
ds.Active = ltRollDescriptions.Active;
ds.LogoPath = ltRollDescriptions.LogoPath;
ds.LogoName = ltRollDescriptions.LogoName;
ds.SmallLogoName = ltRollDescriptions.LogoPath;
ds.RollImagePath = ltRollDescriptions.RollImagesPath;
ds.AuctionDelayTime = ltRollDescriptions.AuctionDelayTime.ToString();
ds.SMSNewBidder = ltRollDescriptions.SmsNotification;
ds.SMSOutBidder = ltRollDescriptions.smsOutBidder;
ds.RollImagesBackColor = ltRollDescriptions.RollImagesBackColor;
ds.RollActionBidColor = ltRollDescriptions.RollActionBidColor;
ds.RollActionBackIndexColor = ltRollDescriptions.RollActionBackIndexColor;
ds.HomePeriodDescription = ltRollDescriptions.HomePeriodDescription;
ds.HomePeriodDescriptionTextColor = ltRollDescriptions.HomePeriodDescriptionTextColor;
ds.HomePeriodDescriptionBackColor = ltRollDescriptions.HomePeriodDescriptionBackColor;
ds.ActionTextColor = ltRollDescriptions.ActionTextColor;
ds.ActionBackColor = ltRollDescriptions.ActionBackColor;
ds.message = "Roll not loaded yet. Will be available soon!";
}
}
return(ds);
}
