protected void Guest_Click(object sender, EventArgs e)
{
string uname = "Guest";
Session["UserName"] = uname.Trim();
string gname = GuestName.Text;
string gaddress = GuestAddress.Text;
if ((gname == ""))
{
litStatus.Text = "Enter the Name and Shiping Address";
}
else if ((gaddress == ""))
{
litStatus.Text = "Enter the Name and Shiping Address";
}
else
{
Customer c = new Customer();
guest g = new guest();
g.name = gname;
g.shippingAddress = gaddress;
string res = c.updateGuest(g);
if (res == "success")
{
Response.Redirect("~/Index.aspx");
}
else
{
litStatus.Text = "Enter the Name and Shiping Address";
}
}
}
public ActionResult DeleteConfirmed(int id)
{
guest guest = db.guest.Find(id);
db.guest.Remove(guest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void Page_Load(object sender, EventArgs e)
{
authCode.Text = Session["AuthCode"].ToString();
string uname = Session["UserName"].ToString();
Customer cm = new Customer();
int cid;
if (uname == "Guest")
{
cid = -1;
}
else
{
cid = cm.returnClientID(uname);
}
PurchaseCtrl p = new PurchaseCtrl();
List <cart> carts = p.validateProduct(cid);
foreach (cart cart in carts)
{
int q = Convert.ToInt32(cart.ProductId);
p.inventoryUpdate(q, cart.Amount);
}
string auth = Session["AuthCode"].ToString();
p.markOrdersAsPaid(carts, auth);
Customer cust = new Customer();
string wName, wAddress;
if (cid == (-1))
{
guest gue = cust.getGuestDetail(1);
wName = gue.name;
wAddress = gue.shippingAddress;
}
else
{
user use = cust.getUserDetail(cid);
wName = use.name;
wAddress = use.address;
}
warehouse wh = new warehouse
{
paymentID = auth,
Name = wName,
shippingAddress = wAddress,
packagingStatus = "ReadyToPacked",
ShippingStatus = "NotShipped",
DeliveryStatus = "NotDelivered"
};
WarehouseScreen ws = new WarehouseScreen();
string report = ws.printOrder(wh);
}
public ActionResult Edit([Bind(Include = "id,first_name,last_name,e_mail,phone_number")] guest guest)
{
if (ModelState.IsValid)
{
db.Entry(guest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(guest));
}
public static void Add(int k)
{
try
{
string n =
"Adams,Baker,Clark,Davis,Evans,Frank,Ghosh,Hills,Irwin,Jones,Klein,Lopez,Mason,Nalty,Ochoa,Patel,Quinn,Reily,Smith,Trott,Usman,Valdo,White,Xiang,Yakub,Zafar";
string[] names = n.Split(',');
long pollId = 5;
long ownerId = 1;
for (int j = 0; j < k; j++)
{
Random r = new Random();
string fieldData =
"[{\"FieldCode\":\"ad-soyad\",\"FieldValue\":\"" + names[r.Next(0, 26)] +
"\"},{\"FieldCode\":\"cep-telefonu\",\"FieldValue\":\"" + r.Next(11111111, 99999999) + "\"}]";
guest guest = new guest
{
fielddata = fieldData,
pollid = pollId,
ownerid = ownerId,
ownertype = "P",
ip = GetRandomIp(),
complatesecond = r.Next(20, 60)
};
EntityConnectionService.Guest.Add(guest);
var pollList = EntityConnectionService.Question.GetList(x => x.pollid.Equals(pollId));
var answerList = EntityConnectionService.Answer.GetList(x => x.pollid.Equals(pollId));
List <guestanswer> guestanswers = new List <guestanswer>();
for (var i = 0; i < pollList.Count; i++)
{
var lAnswers = answerList.Where(x => x.questionid.Equals(pollList[i].questionid)).ToList();
long answerId = lAnswers[r.Next(0, lAnswers.Count)].answerid;
guestanswer ga = new guestanswer()
{
pollid = pollId,
ownerid = ownerId,
ownertype = "P",
questionid = pollList[i].questionid,
answerid = answerId,
guestid = guest.guestid
};
guestanswers.Add(ga);
}
EntityConnectionService.GuestAnswer.Add(guestanswers.ToArray());
}
}
catch (Exception ex)
{
Log.Error(ex.ToString() + ex.Message.ToString());
}
}
public ActionResult Create([Bind(Include = "id,first_name,last_name,e_mail,phone_number")] guest guest)
{
if (ModelState.IsValid)
{
db.guest.Add(guest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(guest));
}
// GET: guests/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
guest guest = db.guest.Find(id);
if (guest == null)
{
return(HttpNotFound());
}
return(View(guest));
}
public guest getGuestDetail(int id)
{
try
{
using (autopartsEntities db = new autopartsEntities())
{
guest gu = db.guests.Find(id);
return(gu);
}
}
catch (Exception)
{
return(null);
}
}
public ActionResult Create(CreateView reservation, int?id)
{
if (ModelState.IsValid)
{
var misafir = new guest();
Random rnd = new Random();
int num = rnd.Next(1, 10000);
misafir.id = num;
misafir.e_mail = reservation.e_mail;
misafir.first_name = reservation.first_name;
misafir.last_name = reservation.last_name;
misafir.phone_number = reservation.phone_number;
db.guest.Add(misafir);
db.SaveChanges();
var rezervasyon = new reservation();
int generated = rezervasyon.GetHashCode();
rezervasyon.id = generated;
rezervasyon.guest_id = num;
rezervasyon.date_in = DateTime.Now;
rezervasyon.date_out = DateTime.Now.AddDays(10);
rezervasyon.status = "true";
rezervasyon.made_by = reservation.first_name + " " + reservation.last_name;
db.reservation.Add(rezervasyon);
db.SaveChanges();
//Database kayıt işlemi
//db.Entry(reservation).State = EntityState.Modified;
//oda durumunun değiştiği yer
var room = db.room.Find(id);
room.status = "false";
db.SaveChanges();
return(RedirectToAction("Create", "CreditCards", new { id = id }));
}
return(View());
}
public static bool AddVisitor(guest vd)
{
bool success = false;
User muser = new User();
try
{
String insertQuery = "INSERT INTO [dbo].[Guest_EntryRequest] ([Name],[MobileNo],[Address],[Purpose],[StartTime],[EndTime])" +
"VALUES('" + vd.Name + "','" + vd.MobileNo + "','" + vd.Address + "','" + vd.Purpose + "','" + vd.StartTime + "','" + vd.EndTime + "');";
DataAccess da = new DataAccess();
success = da.Update(insertQuery);
}
catch (Exception ex)
{
}
return(success);
}
public async Task <IHttpActionResult> Postguest(guest guest)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var guestInDB = db.guests.FirstOrDefault(g => g.email.Equals(guest.email));
if (guestInDB == null)
{
guest.id = Guid.NewGuid().ToString("N");
db.guests.Add(guest);
}
else
{
guestInDB.numberOfGuests = guest.numberOfGuests;
guestInDB.coming = guest.coming;
guestInDB.name = guest.name;
}
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (guestExists(guest.id))
{
return(Conflict());
}
else
{
throw;
}
}
//send email
Email email = new Email();
await email.SendAsync(guest.email, null, "Wedding Invitation Sanmathi and Shivam", "" +
"Wedding Invitation");
return(Ok());
}
public string updateGuest(guest g)
{
try
{
autopartsEntities db = new autopartsEntities();
//Fetch
guest guest = db.guests.Find(1);
guest.name = g.name;
guest.shippingAddress = g.shippingAddress;
db.SaveChanges();
return("success");
}
catch (Exception e)
{
return("Error :" + e);
}
}
public ActionResult Create(CreateView reservation, int?id)
{
if (ModelState.IsValid)
{
var misafir = new guest();
misafir.id = 45;
misafir.e_mail = reservation.e_mail;
misafir.first_name = reservation.first_name;
misafir.last_name = reservation.last_name;
misafir.phone_number = reservation.phone_number;
db.guests.Add(misafir);
db.SaveChanges();
var rezervasyon = new reservation();
rezervasyon.date_in = DateTime.Now;
rezervasyon.date_out = DateTime.Now.AddDays(10);
rezervasyon.guest_id = misafir.id;
rezervasyon.status = "true";
rezervasyon.made_by = reservation.first_name + " " + reservation.last_name;
db.reservations.Add(rezervasyon);
db.SaveChanges();
//Database kayıt işlemi
//db.Entry(reservation).State = EntityState.Modified;
//oda durumunun değiştiği yer
var room = db.rooms.Find(id);
room.status = "false";
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View());
}
void Awake()
{
instance = this;
}
public static UpdateResponse UpdateBookingDetails(string propCode, BookingViewModel model)
{
var webAddr = "https://chartswebintf-fra.chartspms.com.au/json/execute?un=charteuhh&pw=hh246eu";
var httpWebRequest = (HttpWebRequest)WebRequest.Create(webAddr);
httpWebRequest.ContentType = "text/json";
httpWebRequest.Method = "POST";
JavaScriptSerializer js = new JavaScriptSerializer();
login logdetails = new login();
logdetails.user = "******";
logdetails.pasw = "";
propIdent requestdata = new propIdent();
requestdata.mesg = "ResvUpdate";
requestdata.propcode = propCode;
requestdata.login = logdetails;
Update jsonupdate = new Update();
guest g = new guest();
g.salu = model.salu;
g.naml = model.lastName;
g.namf = model.firstName;
g.comp = model.company;
g.emai = model.email;
g.cell = model.cellnumber;
g.phon = model.phonenumber;
g.secu = model.secu;
addr a = new addr();
a.line1 = model.address1;
a.line2 = model.address2;
a.city = model.city;
a.posc = model.postcode;
a.stat = model.state;
a.cnty = model.country;
g.addr = a;
stay s = new stay();
s.arrt = model.timearrival;
s.paym = model.paym;
if (model.cardNumber != null)
{
s.card = new Card();
s.card.auth = model.cardHolder;
s.card.numb = model.cardNumber;
s.card.expy = model.cardEndDate;
}
List <exflds> ext = new List <exflds>();
if (model.gender != null)
{
exflds e = new exflds();
e.numb = 65;
e.value = model.gender;
ext.Add(e);
}
//if (ext.Count > 0)
//{
// s.exflds = ext.ToArray();
//}
//if (false) {
//List<exflds> ext = new List<exflds>();
if (model.document != null)
{
exflds e = new exflds();
e.numb = 74;
e.value = model.document;
ext.Add(e);
}
if (model.idtype != null)
{
exflds n = new exflds();
n.numb = 75;
n.value = model.idtype;
ext.Add(n);
}
if (model.secu != null)
{
exflds n = new exflds();
n.numb = 76;
n.value = model.secu;
ext.Add(n);
}
if (ext.Count > 0)
{
s.exflds = ext.ToArray();
}
//}
jsonupdate.ident = requestdata;
jsonupdate.indx = model.index;
jsonupdate.guest = g;
jsonupdate.stay = s;
Update[] sendarray = { jsonupdate };
jsonUpdateModel array = new jsonUpdateModel();
array.requests = sendarray;
string json = JsonConvert.SerializeObject(array);
using (StreamWriter streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
streamWriter.Write(json);
streamWriter.Flush();
}
HttpWebResponse httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
StreamReader streamReader = new StreamReader(httpResponse.GetResponseStream());
string result = streamReader.ReadToEnd(); //in result is the end data.
jsonUpdateResponseModel response = JsonConvert.DeserializeObject <jsonUpdateResponseModel>(result);
UpdateResponse data = response.responses[0];
return(data);
}
/// <summary>
/// Guestin cevaplarini tablolara insert eder.
/// </summary>
/// <param name="pollid">Anket Id</param>
/// <param name="ownerid">Anketi acan kullanicinin Id si</param>
/// <param name="ownertype">Anketi acan kullanici type i</param>
/// <param name="guestanswerdata">Kullanicinin cevaplari : [{QuestionId:'SoruId',AnswerId:'CevapId'}]</param>
/// <param name="staffid">eger private anket ise doldurulur o an anketi yapan staffid sidir</param>
/// <param name="authkey">eger private anket ise doldurulur o an anketi yapan authkey idir</param>
/// <param name="fielddata">PollMaster da belirtilen field larin doldurulmus verisini alir database e basar.[{"FieldCode":"ad-soyad","FieldValue":"test"}]</param>
/// <returns></returns>
public string SetGuestAnswers(dynamic jsonData)
{
string fieldData = jsonData.fielddata;
long pollId = jsonData.pollid;
long ownerId = jsonData.ownerid;
string ownerType = jsonData.ownertype;
int complateSecond = jsonData.complatesecond;
string ip = jsonData.ip;
List <GuestAnswer> answerList = jsonData.guestanswerdata.ToObject <List <GuestAnswer> >();
poll pollMaster =
EntityConnectionService.Poll.GetSingle(x => x.pollid.Equals(pollId) && x.ownerid.Equals(ownerId) && x.ownertype.Equals(ownerType));
if (pollMaster == null)
{
return(Helper.GetResult(false, "0x0012"));
}
if (pollMaster.active != "X")
{
return(Helper.GetResult(false, "0x0020"));
}
if (pollMaster.isipcheck == ("X"))
{
guest pollGuest = EntityConnectionService.Guest.GetSingle(x => x.ip == ip && x.ownerid == ownerId && x.ownertype == ownerType && x.pollid == pollId);
if (pollGuest != null)
{
return(Helper.GetResult(false, "0x0018"));
}
}
if (pollMaster.isprivate == ("X"))
{
long staffId = jsonData.staffid;
string authKey = jsonData.authkey;
staff loggedUser = DatabaseService.CheckStaffAuth(staffId, authKey, ownerId);
if (loggedUser == null)
{
return(Helper.GetResult(false, "0x0017"));
}
}
guest guest = new guest
{
fielddata = fieldData,
pollid = pollId,
ownerid = ownerId,
ownertype = ownerType,
ip = ip,
complatesecond = complateSecond
};
if (!EntityConnectionService.Guest.Add(guest))
{
return(Helper.GetResult(false, "0x0013"));
}
List <guestanswer> guestanswers = new List <guestanswer>();
for (int i = 0; i < answerList.Count; i++)
{
guestanswers.Add(new guestanswer()
{
pollid = pollId,
ownerid = ownerId,
ownertype = ownerType,
questionid = answerList[i].QuestionId,
answerid = answerList[i].AnswerId,
guestid = guest.guestid
});
}
if (!EntityConnectionService.GuestAnswer.Add(guestanswers.ToArray()))
{
return(Helper.GetResult(false, "0x0014"));
}
return(Helper.GetResult(true, true));
}
/// <summary>
/// Verilen bilgilere ait anketin verisini dondurur.
/// </summary>
/// <param name="pollid">Anket idsi</param>
/// <param name="ownerid">Anketi olusturan kullanici idsi</param>
/// <param name="ownertype">Anketi olusturan kullanici type i</param>
/// <returns></returns>
public string GetPollData(dynamic jsonData)
{
long pollId = jsonData.pollid;
long ownerId = jsonData.ownerid;
string ownerType = jsonData.ownertype;
poll pollMaster =
EntityConnectionService.Poll.GetSingle(x => x.pollid.Equals(pollId) && x.ownerid.Equals(ownerId) && x.ownertype.Equals(ownerType));
if (pollMaster == null)
{
return(Helper.GetResult(false, "0x0012"));
}
if (pollMaster.isipcheck == ("X"))
{
string ip = jsonData.ip;
guest pollGuest = EntityConnectionService.Guest.GetSingle(x => x.ip == ip && x.ownerid == ownerId && x.ownertype == ownerType && x.pollid == pollId);
if (pollGuest != null)
{
return(Helper.GetResult(false, "0x0018"));
}
}
if (pollMaster.isprivate == "X")
{
long staffId = jsonData.staffid;
string authKey = jsonData.authkey;
staff loggedUser = DatabaseService.CheckStaffAuth(staffId, authKey, ownerId);
if (loggedUser == null)
{
return(Helper.GetResult(false, "0x0017"));
}
}
pollMaster.viewcount++;
EntityConnectionService.Poll.Update(pollMaster);
List <question> questionList =
EntityConnectionService.Question.GetList(
x =>
x.pollid.Equals(pollId) && x.ownerid.Equals(ownerId) && x.ownertype.Equals(ownerType)).ToList();
PollModel poll = new PollModel();
poll.PollId = pollMaster.pollid;
poll.IsPassword = pollMaster.ispassword;
poll.Password = pollMaster.password;
poll.PollTitle = pollMaster.polltitle;
poll.Questions = new List <Question>();
poll.Fields = pollMaster.fielddata;
poll.IsCookieCheck = pollMaster.iscookiecheck;
poll.Active = pollMaster.active;
for (int i = 0; i < questionList.Count; i++)
{
Question localQuestion = new Question
{
Content = questionList[i].content,
QuestionId = questionList[i].questionid,
QuestionType = questionList[i].questiontype,
Answers = new List <Answer>()
};
List <answer> answerList =
EntityConnectionService.Answer.GetList(
x =>
x.pollid.Equals(pollId) && x.questionid.Equals(localQuestion.QuestionId) &&
x.ownerid.Equals(ownerId) && x.ownertype.Equals(ownerType)).ToList();
for (int j = 0; j < answerList.Count; j++)
{
Answer localAnswer = new Answer
{
AnswerId = answerList[j].answerid,
Content = answerList[j].content,
AnswerType = answerList[j].answertype
};
localQuestion.Answers.Add(localAnswer);
}
poll.Questions.Add(localQuestion);
}
return(Helper.GetResult(true, poll));
}
