public JsonResult UpdateContentMailforNhanvien([FromBody] MailCustomViewModel Mailcontext)
{
var db = new dbcontext();
var exsistMailfornhanvien = db.Mailtonhanviens.Where(x => x.NhanvienId == Mailcontext.idnv).FirstOrDefault();
if (exsistMailfornhanvien == null)
{
var newmailfornhanvien = new Mailtonhanvien()
{
NhanvienId = Mailcontext.idnv,
Tieude = Mailcontext.tieudemail,
Noidung = Mailcontext.noidungmail
};
db.Mailtonhanviens.Add(newmailfornhanvien);
db.SaveChanges();
return(new JsonResult(
new
{
mes = "thanh cong"
}
));
}
else
{
exsistMailfornhanvien.Tieude = Mailcontext.tieudemail;
exsistMailfornhanvien.Noidung = Mailcontext.noidungmail;
db.SaveChanges();
return(new JsonResult(
new
{
mes = "thanh cong"
}
));
}
}
public ActionResult Giris(Kullanici kul, int CompanyCode = 0, string remember = "")
{
if (remember == "1")
{
HttpCookie cookie = new HttpCookie("KullaniciAd", kul.Username);
HttpCookie cookie2 = new HttpCookie("FirmaId", CompanyCode.ToString());
Response.Cookies.Add(cookie); Response.Cookies.Add(cookie2);
}
else
{
Request.Cookies.Remove("KullaniciAd"); Request.Cookies.Remove("FirmaId");
}
Firma firma = db.Firma.FirstOrDefault(x => x.Username == kul.Username && x.Sifre == kul.Sifre);
if (firma != null)
{
CompanyCode = firma.FirmaId;
}
if (CompanyCode != 0)
{
Kullanici k = db.Kullanici.FirstOrDefault(x => x.Company.FirmaId == CompanyCode && x.Username == kul.Username && x.Sifre == kul.Sifre);
if (k != null)
{
k.LastLogin = DateTime.Now;
db.SaveChanges();
Session["Kullanici"] = k; CurrentSession.Set <int>("giris", 1);
return(Redirect("/Anasayfa/SiraListesi"));
}
}
TempData["GirisHata"] = "Lütfen Giriş Bilgilerinizi Kontrol Ediniz";
return(View());
}
public ActionResult Create([Bind(Include = "id,Name,Mobile,Email")] Registeration Register, Helper help)
{
try
{
if (ModelState.IsValid)
{
var phone = db.Registerations.FirstOrDefault(x => x.Mobile == Register.Mobile);
if (phone != null)
{
this.SetNotification("Sorry Mobile No Already Exist. Please Use Another Number", Models.NotificationEnumeration.Error);
return(View());
}
else
{
// Generate Otp
string[] saAllowedCharacters = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" };
string sRandomOTP = help.GenerateRandomOTP(6, saAllowedCharacters);
Register.OTP = Convert.ToInt32(sRandomOTP);
Register.OTPStatus = "Not Verify";
db.Registerations.Add(Register);
db.SaveChanges();
// Send Otp
help.smssetting(Register.Mobile, "Yout OTP Is : " + sRandomOTP + "");
return(RedirectToAction("OTPVerifications", new { id = Register.id }));
}
}
return(View());
}
catch
{
return(View());
}
}
public ActionResult PutRateInfo(int id, RateInfo rateInfo)
{
if (!ModelState.IsValid)
{
return(Json("Model is not valid", JsonRequestBehavior.AllowGet));
}
if (id != rateInfo.RateInfoId)
{
return(Json("Model id is not valid", JsonRequestBehavior.AllowGet));
}
db.Entry(rateInfo).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!RateInfoExists(id))
{
return(Json("Data is not in table", JsonRequestBehavior.AllowGet));
}
else
{
throw;
}
}
return(Json(rateInfo, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult Posttextnote([FromBody] note textnote)
{
textnote.img = null;
db.notes.Add(textnote);
db.SaveChanges();
return(Ok(new { result = "success" }));
}
private void BtnCustomerSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtCustomerLastName.Text) ||
string.IsNullOrEmpty(txtCustomerName.Text) ||
string.IsNullOrEmpty(txtCustomerPhone.Text))
{
MessageBox.Show("Fill the banks");
return;
}
try
{
customer.FirstName = txtCustomerName.Text;
customer.LastName = txtCustomerLastName.Text;
customer.BirthDate = dtpCustomerBirthDate.Value;
customer.PhoneNumber = txtCustomerPhone.Text;
customer.Status = true;
customer.PackageEntryQuantity = (byte)customer.package.EntryQuantity;
}
catch (Exception a)
{
MessageBox.Show($"{a.Message}");
}
//customer.Balance += customer.payments.FirstOrDefault(n => n.CustomerId == customer.id).Amount;
context.Customers.Add(customer);
context.SaveChanges();
FillCustomerDataGView();
}
public IHttpActionResult PutPartyInfo(int id, PartyInfo partyInfo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != partyInfo.PartyInfoId)
{
return(BadRequest());
}
db.Entry(partyInfo).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PartyInfoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "Id,date,name,email,contact,login,password,rid,image,Type,status,StartTime,EndTime")] tblreceptionist tblreceptionist, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
tblreceptionist recp = db.tblreceptionists.FirstOrDefault();
if (recp == null)
{
tblreceptionist.rid = "1001";
}
else
{
var valc = db.tblreceptionists.Max(x => x.rid);
tblreceptionist.rid = (Convert.ToInt32(valc) + 1).ToString();
}
if (User.IsInRole("Franchisee"))
{
tblreceptionist.franchid = Help.Franchisee();
}
else
{
tblreceptionist.franchid = Help.Franchisee();
}
tblreceptionist.image = Help.uploadfile(file);
tblreceptionist.password = tblreceptionist.password;
db.tblreceptionists.Add(tblreceptionist);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(tblreceptionist));
}
public ActionResult CreateBook([Bind(Include = "Mid,IdCard,Bid,IssueDate,LastDate,Fine,Status")] IssueBook books, int bookid)
{
if (ModelState.IsValid)
{
Books book = db.Books.Find(bookid);
Setting ss = db.Settings.First();
if (book.BookCopies > ss.BookAlert)
{
books.Bid = bookid;
books.Status = "Issue";
books.fine = 0;
db.IssueBooks.Add(books);
db.SaveChanges();
#region Update Book Quantity
book.BookCopies = book.BookCopies - 1;
db.Entry(book).State = EntityState.Modified;
db.SaveChangesAsync();
#endregion
TempData["Success"] = "Issue Book Successfully";
}
else
{
TempData["Success"] = "Quantity Not Sufficient";
return(RedirectToAction("add", new { id = books.Mid }));
}
}
return(RedirectToAction("add", new { id = books.Mid }));
}
public async Task <ActionResult> Create([Bind(Include = "CCid,Cid,Oid,Name,Description,ProgramLength,ApplicationFee,TuitionFee,LivingCost,Code,Status")] CollegeCourse collegeCourse, string[] take, Intake section)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
collegeCourse.Code = uniquecode();
collegeCourse.Status = true;
db.CollegeCourses.Add(collegeCourse);
await db.SaveChangesAsync();
// return RedirectToAction("Index");
for (int i = 0; i <= take.Length - 1; i++)
{
section.CCid = collegeCourse.Code;
section.IntakeName = take[i].ToString();
section.Status = true;
db.Intakes.Add(section);
db.SaveChanges();
}
ViewBag.Cid = new SelectList(db.Countries, "Cid", "CountryName", collegeCourse.Cid);
ViewBag.Oid = new SelectList(db.Colleges, "Oid", "Name", collegeCourse.Oid);
transaction.Commit();
return(RedirectToAction("Index", "CollegeCourses"));
}
catch (Exception e)
{
transaction.Rollback();
throw;
}
}
}
public ActionResult Create([Bind(Include = "Id,date,name,email,contact,login,password,rid,image,Type,status")] tblreceptionist tblreceptionist, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
//tblreceptionist recp = db.tblreceptionists.FirstOrDefault();
//if (recp == null)
//{
// tblreceptionist.rid = "r_1001";
//}
//else
//{
// var valc = db.tblreceptionists.Max(x => x.rid);
// string[] rec = valc.Split('_');
// var ab = rec[1].ToString();
// tblreceptionist.rid = (Convert.ToInt32(ab) + 1).ToString();
//}
tblreceptionist.image = Help.uploadfile(file);
db.tblreceptionists.Add(tblreceptionist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblreceptionist));
}
private void BtnPackageSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtPackageEntryQuantity.Text.Trim()) &&
string.IsNullOrEmpty(txtPackageName.Text.Trim()) &&
string.IsNullOrEmpty(txtPackagePrice.Text.Trim()))
{
MessageBox.Show("Fill the banks");
return;
}
try
{
package = new Package();
package.Name = txtPackageName.Text;
package.Price = Convert.ToDecimal(txtPackagePrice.Text);
package.EntryQuantity = Convert.ToInt32(txtPackageEntryQuantity.Text);
package.Status = true;
context.packages.Add(package);
context.SaveChanges();
FillPackagesDataGView();
}
catch (Exception ex)
{
MessageBox.Show($"{ex.Message}");
}
}
private void BtnPaymentSave_Click(object sender, EventArgs e)
{
if (cmbPaymentsCustomer.SelectedIndex < 0 ||
cmbPaymentsPackage.SelectedIndex < 0 ||
string.IsNullOrEmpty(txtPaymentsAmount.Text))
{
MessageBox.Show("Fill the banks");
return;
}
customerfirstname = cmbPaymentsCustomer.SelectedItem.ToString().Split(' ')[0];
payment.customer = context.Customers.FirstOrDefault(a => a.FirstName == customerfirstname);
packagename = cmbPaymentsPackage.SelectedItem.ToString().Split('-')[0];
payment.Package = context.packages.FirstOrDefault(a => a.Name == packagename);
payment.CreatedAt = DateTime.Now;
payment.Amount = Convert.ToDecimal(txtPaymentsAmount.Text);
payment.Status = true;
payment.customer.Balance = payment.Amount;
context.payments.Add(payment);
foreach (Payment item in context.payments.ToList())
{
if (payment.CustomerId == item.CustomerId)
{
item.Status = false;
}
}
context.SaveChanges();
FillPaymentsDataGridView();
}
public ActionResult Register([Bind(Include = "FirstName, LastName, Email, Password")] User user)
{
if (ModelState.IsValid)
{
log.Info("Register User : "******"Password must be at least 8 characters long!";
return(View("Register"));
}
user.Password = Hash(user.Password);
user.TokensNumber = 0;
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Login"));
}
else
{
ViewBag.Message = "Email is already taken";
return(View("Register"));
}
}
return(View("Register"));
}
public ActionResult Create([Bind(Include = "Albumid,AlbumName,Image,date")] Album album, HttpPostedFileBase file, Gallery gallery, IEnumerable <HttpPostedFileBase> file2, Helper Help)
{
if (ModelState.IsValid)
{
album.date = System.DateTime.Now;
album.Image = Help.uploadfile(file);
db.Albums.Add(album);
db.SaveChanges();
gallery.date = System.DateTime.Now;
gallery.Albumid = db.Albums.Max(x => x.Albumid);
foreach (var a in file2)
{
gallery.Images = Help.uploadfile(a);
db.Galleries.Add(gallery);
db.SaveChanges();
}
//gallery.Images = Help.uploadfile(file2);
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(album));
}
public IHttpActionResult PutDestination(int id, Destination destination)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != destination.DestinationId)
{
return(BadRequest());
}
db.Entry(destination).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DestinationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create(int Amount, int Discount, int CourseId, DateTime Alert, DateTime date, Recipt_Details receiptdetail)
{
try
{
// TODO: Add insert logic here
Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno);
feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount));
feesmaster.Date = date;
feesmaster.AlertDate = Alert;
feesmaster.PaidFees += Amount;
feesmaster.Status = true;
db.Entry(feesmaster).State = EntityState.Modified;
db.SaveChanges();
receiptdetail.RollNo = rollno;
receiptdetail.ReciptNo = receiptno;
receiptdetail.CourseId = CourseId;
receiptdetail.Date = date;
receiptdetail.Amount = Amount;
receiptdetail.Active = true;
db.Recipt_Details.Add(receiptdetail);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("invoice", new { id = receiptno }));
}
catch
{
return(View());
}
}
public ActionResult Create([Bind(Include = "Ieltsid,Name,Categoryid,TestType,Image,date")] IeltsTest ieltsTest, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
string isValid = string.Empty;
try
{
foreach (string upload in Request.Files)
{
if (Request.Files[upload].ContentType == "application/octet-stream") //Content type for .zip is application/octet-stream
{
if (Request.Files[upload].FileName != "")
{
string path = AppDomain.CurrentDomain.BaseDirectory + "/UploadedFiles/";
// string path = AppDomain.CurrentDomain.BaseDirectory + "/ App_Data / uploads /";
if (!Directory.Exists(path))
{
// Try to create the directory.
DirectoryInfo di = Directory.CreateDirectory(path);
}
string filename = Path.GetFileName(Request.Files[upload].FileName);
filename = Guid.NewGuid().ToString().Substring(0, 4) + filename;
string pth = Path.Combine(path, filename);
Request.Files[upload].SaveAs(pth);
//isValid = CheckForTheIcon(pth);
isValid = (pth);
ieltsTest.Image = filename;
ieltsTest.date = System.DateTime.Now;
db.IeltsTests.Add(ieltsTest);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
}
}
else
{
isValid = "Only .zip files are accepted.";
}
}
//return isValid;
}
catch (Exception)
{
// return "Oops!. Something went wrong";
}
//ieltsTest.date = System.DateTime.Now;
//ieltsTest.Image = Help.uploadfile(file);
//db.IeltsTests.Add(ieltsTest);
//db.SaveChanges();
//TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
ViewBag.Categoryid = new SelectList(db.Categories, "Categoryid", "Name", ieltsTest.Categoryid);
return(View(ieltsTest));
}
public ActionResult submit(string email, string password, float Rate)
{
Worker worker = new Worker(); worker.Email = email; worker.Psswrd = password; worker.RatePerHour = Rate;
db.Worker.Add(worker);
db.SaveChanges();
return(Json(new { status = true }));
}
public ActionResult Create([Bind(Include = "Id,date,inquiryid,name,fname,contact,address,referedby,Categoryid,status")] tblinquiry tblinquiry, [Bind(Include = "Id,date,inquiryid,feedback,days,type,nexfollow,status,loginid")] tblfeedback tblfeedback)
{
if (ModelState.IsValid)
{
tblinquiry inquiry = db.tblinquiries.FirstOrDefault();
if (inquiry == null)
{
tblinquiry.inquiryid = "I_101";
}
else
{
var ab = db.tblinquiries.Max(x => x.inquiryid);
string [] vall = ab.Split('_');
string neww = (Convert.ToInt32(vall[1].ToString()) + 1).ToString();
tblinquiry.inquiryid = "I_" + neww;
}
tblinquiry.status = true;
db.tblinquiries.Add(tblinquiry);
db.SaveChanges();
// tblfeedback feedback = new tblfeedback();
DateTime next = new DateTime();
if (tblfeedback.type == "Days")
{
next = System.DateTime.Now.AddDays(tblfeedback.days);
// System.DateTime.Now.AddDays(Convert.ToInt32(days)).ToString("MM/dd/yyyy");
}
//else if (option == "Month")
//{
// next = System.DateTime.Now.AddMonths(days);
//}
//else if (option == "Year")
//{
// next = System.DateTime.Now.AddYears(days);
//}
else
{
next = System.DateTime.Now;
}
tblfeedback.date = tblinquiry.date;
tblfeedback.inquiryid = tblinquiry.inquiryid;
tblfeedback.loginid = Session["User"].ToString();
tblfeedback.status = "Active";
tblfeedback.nextfollow = next;
db.tblfeedback.Add(tblfeedback);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(tblinquiry));
}
public ActionResult Create([Bind(Include = "Id,Start_no,End_no,Date,Current_Recipt,Status")] tblReceipt tblReceipt)
{
if (ModelState.IsValid)
{
db.tblReceipt.Add(tblReceipt);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblReceipt));
}
public ActionResult Create([Bind(Include = "RoomId,room,status")] tblroom tblroom)
{
if (ModelState.IsValid)
{
db.tblrooms.Add(tblroom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblroom));
}
public ActionResult Create([Bind(Include = "Categoryid,CategoryName")] Category category)
{
if (ModelState.IsValid)
{
db.Categories.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Create([Bind(Include = "id,Username,Senderid,Type,Api,alertno,Status")] tblsms tblsms)
{
if (ModelState.IsValid)
{
db.tblsms.Add(tblsms);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblsms));
}
public ActionResult Create([Bind(Include = "Id,date,name,email,contact,login,password,UserType,status")] Account account)
{
if (ModelState.IsValid)
{
account.password = Help.EncryptData(account.password);
db.Accounts.Add(account);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(account));
}
public ActionResult Create([Bind(Include = "CampusId,CollegeId,CampusName,Distance")] Campus campus)
{
if (ModelState.IsValid)
{
db.Campus.Add(campus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CollegeId = new SelectList(db.Colleges, "CollegeId", "CollegeName", campus.CollegeId);
return(View(campus));
}
public ActionResult Create([Bind(Include = "Counterid,Experience,Customers,date,Award,Satisfied")] Counter counter)
{
if (ModelState.IsValid)
{
counter.date = System.DateTime.Now;
db.Counters.Add(counter);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(counter));
}
public ActionResult Create([Bind(Include = "CollegeId,Countryid,CollegeName,Location")] College college)
{
if (ModelState.IsValid)
{
db.Colleges.Add(college);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Countryid = new SelectList(db.Countries, "Countryid", "CountryName", college.Countryid);
return(View(college));
}
public ActionResult Create([Bind(Include = "Id,date,name,passport,dob,doe,choice1,choice2,choice3,module,v1,v2,v3,mode,instname,status,fid,uname,pass")] tblfill tblfill)
{
if (ModelState.IsValid)
{
db.tblfills.Add(tblfill);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(tblfill));
}
public ActionResult Create([Bind(Include = "Categoryid,Name,date")] Category category)
{
if (ModelState.IsValid)
{
db.Categories.Add(category);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(category));
}
