/*******Begin code to modify********/
/// <summary>
/// Create a new user of the LMS with the specified information.
/// Assigns the user a unique uID consisting of a 'u' followed by 7 digits.
/// </summary>
/// <param name="fName">First Name</param>
/// <param name="lName">Last Name</param>
/// <param name="DOB">Date of Birth</param>
/// <param name="SubjectAbbrev">The department the user belongs to (professors and students only)</param>
/// <param name="SubjectAbbrev">The user's role: one of "Administrator", "Professor", "Student"</param>
/// <returns>A unique uID that is not be used by anyone else</returns>
public string CreateNewUser(string fName, string lName, DateTime DOB, string SubjectAbbrev, string role)
{
String nextUid = "not filled";
using (Team31LMSContext db = new Team31LMSContext())
{
var all_uIds = (from stud in db.Students orderby stud.UId descending select new { uId = stud.UId })
.Union(from prof in db.Professors orderby prof.UId descending select new { uId = prof.UId })
.Union(from adm in db.Administrators orderby adm.UId descending select new { uId = adm.UId });
var uIds = all_uIds.OrderByDescending(x => x.uId).Take(1);
// get new Uid
String highestUid = uIds.First().uId.ToString();
int highestUidNumber = Int32.Parse(highestUid.Substring(1, highestUid.Length - 1));
int nextUidNumber = highestUidNumber + 1;
nextUid = "u" + nextUidNumber.ToString();
// chose role
if (role == "Student")
{
Students st = new Students
{
UId = nextUid,
FirstName = fName,
LastName = lName,
Dob = DOB,
Major = SubjectAbbrev
};
db.Students.Add(st);
db.SaveChanges();
}
else if (role == "Professor")
{
Professors pr = new Professors
{
UId = nextUid,
FirstName = fName,
LastName = lName,
Dob = DOB,
Works = SubjectAbbrev
};
db.Professors.Add(pr);
db.SaveChanges();
}
else if (role == "Administrator")
{
Administrators ad = new Administrators
{
UId = nextUid,
FirstName = fName,
LastName = lName,
Dob = DOB
};
db.Administrators.Add(ad);
db.SaveChanges();
}
}
return(nextUid);
}
/*******Begin code to modify********/
/// <summary>
/// Create a new user of the LMS with the specified information.
/// Assigns the user a unique uID consisting of a 'u' followed by 7 digits.
/// </summary>
/// <param name="fName">First Name</param>
/// <param name="lName">Last Name</param>
/// <param name="DOB">Date of Birth</param>
/// <param name="SubjectAbbrev">The department the user belongs to (professors and students only)</param>
/// <param name="SubjectAbbrev">The user's role: one of "Administrator", "Professor", "Student"</param>
/// <returns>A unique uID that is not be used by anyone else</returns>
public string CreateNewUser(string fName, string lName, DateTime DOB, string SubjectAbbrev, string role)
{
var query = from s in db.Students
select s.UId;
var query2 = from s2 in db.Professors
select s2.UId;
var query3 = from s3 in db.Professors
select s3.UId;
int max = 0;
foreach (var x in query)
{
String uid = x.Substring(1);
int id = Int32.Parse(uid);
if (id > max)
{
max = id;
}
}
foreach (var x in query2)
{
String uid = x.Substring(1);
int id = Int32.Parse(uid);
if (id > max)
{
max = id;
}
}
foreach (var x in query3)
{
String uid = x.Substring(1);
int id = Int32.Parse(uid);
if (id > max)
{
max = id;
}
}
max += 1;
String newId = max.ToString();
while (newId.Length < 7)
{
newId = '0' + newId;
}
newId = 'u' + newId;
if (role == "Student")
{
Students s = new Students();
s.UId = newId;
s.FirstName = fName;
s.LastName = lName;
s.Dob = DOB.ToString();
s.DeptMajor = SubjectAbbrev;
db.Students.Add(s);
db.SaveChanges();
}
else if (role == "Professor")
{
Professors p = new Professors();
p.UId = newId;
p.FirstName = fName;
p.LastName = lName;
p.Dob = DOB.ToString();
p.DeptWorksIn = SubjectAbbrev;
db.Professors.Add(p);
db.SaveChanges();
}
else if (role == "Administrator")
{
Administrators a = new Administrators();
a.UId = newId;
a.FirstName = fName;
a.LastName = lName;
a.Dob = DOB.ToString();
db.Administrators.Add(a);
db.SaveChanges();
}
return(newId);
}
private void InsertExcelRecords(string FilePath)
{
List <Product> _products = new List <Product>();
var csvData = System.IO.File.ReadAllLines(FilePath).Skip(1);
int insertCount = 0;
int updateCount = 0;
try
{
//Execute a loop over the rows.
foreach (string row in csvData)
{
if (!string.IsNullOrEmpty(row))
{
if (row != ",,,,,,,,,,,,,,,,")
{
_products.Add(new Product
{
Product_Id = Convert.ToInt32(row.Split(',')[0]),
SubCategory_Id = Convert.ToInt32(row.Split(',')[1]),
Product_Title = row.Split(',')[2],
Product_Description = row.Split(',')[3],
Product_Specification = row.Split(',')[4],
Product_Qty = Convert.ToInt32(row.Split(',')[5]),
Product_Qty_Alert = Convert.ToInt32(row.Split(',')[6]),
Product_Delivery_Time = Convert.ToInt32(row.Split(',')[7]),
Product_Max_Purchase = Convert.ToInt32(row.Split(',')[8]),
Product_Mkt_Price = Convert.ToDecimal(row.Split(',')[9]),
Product_Our_Price = Convert.ToDecimal(row.Split(',')[10]),
Product_ShippingCharge = Convert.ToDecimal(row.Split(',')[11]),
Product_Has_Size = Convert.ToBoolean(row.Split(',')[12].ToLower()),
Product_Size = row.Split(',')[13],
Product_Avail_ZipCode = row.Split(',')[14],
Product_Discount = Convert.ToDecimal(row.Split(',')[15]),
Product_CreatedDate = DateTime.Now,
Product_UpdatedDate = DateTime.Now,
Product_Status = eProductStatus.ReviewPending.ToString()
});
}
}
}
}
catch (Exception ex)
{
}
int AdminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString());
Administrators _admin = context.Administrator.ToList().Where(m => m.Administrators_Id == AdminId).FirstOrDefault();
foreach (var item in _products)
{
SubCategories _subCategory = context.SubCategory.Where(m => m.SubCategory_Id == item.SubCategory_Id).FirstOrDefault();
item.Administrators_Id = _admin.Administrators_Id;
item.Store_Id = _admin.Store_Id;
if (_subCategory != null)
{
if (item.Product_Id == 0)
{
Product Product = new Product()
{
Store_Id = _admin.Store_Id,
Product_Title = item.Product_Title,
Product_Description = item.Product_Description,
Product_Specification = item.Product_Specification,
Administrators_Id = _admin.Administrators_Id,
Product_Qty = item.Product_Qty,
Product_Qty_Alert = item.Product_Qty_Alert,
Product_Delivery_Time = item.Product_Delivery_Time,
Product_Max_Purchase = item.Product_Max_Purchase,
Product_Mkt_Price = item.Product_Mkt_Price,
Product_Our_Price = item.Product_Our_Price,
Product_ShippingCharge = item.Product_ShippingCharge,
Product_Has_Size = item.Product_Has_Size,
Product_Size = (item.Product_Has_Size == true) ? item.Product_Size : "No Size",
Product_Avail_ZipCode = item.Product_Avail_ZipCode,
Product_Discount = item.Product_Discount,
SubCategory_Id = item.SubCategory_Id,
Product_CreatedDate = item.Product_CreatedDate,
Product_UpdatedDate = item.Product_UpdatedDate,
Product_Status = item.Product_Status
};
try
{
int maxAdminId = 1;
if (context.Product.ToList().Count > 0)
{
maxAdminId = context.Product.Max(m => m.Product_Id);
}
maxAdminId = (maxAdminId == 1 && context.Product.ToList().Count > 0) ? (maxAdminId + 1) : maxAdminId;
Product.ProductCode = "PRDTRACH" + maxAdminId + "TERA" + (maxAdminId + 1);
context.Product.Add(Product);
context.SaveChanges();
ProductHelper.CreateProductFlow(Product.Product_Id, Product.Product_Title, _admin.Administrators_Id, _admin.FullName, "New Product Created", Product.Product_Status);
item.Product_Id = Product.Product_Id;
insertCount = insertCount + 1;
ProductBanners ProductBanner = new ProductBanners()
{
Product_Id = Product.Product_Id,
Administrators_Id = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()),
Product_Banner_Default = 1,
Product_Banner_Photo = "content/noimage.png",
Product_Banner_CreatedDate = DateTime.Now,
Product_Banner_UpdatedDate = DateTime.Now
};
int maxBnrAdminId = 1;
if (context.ProductBanner.ToList().Count > 0)
{
maxBnrAdminId = context.ProductBanner.Max(m => m.Product_Id);
}
maxBnrAdminId = (maxBnrAdminId == 1 && context.ProductBanner.ToList().Count > 0) ? (maxBnrAdminId + 1) : maxBnrAdminId;
ProductBanner.Product_BannerCode = "PRDBNRTRACH" + maxBnrAdminId + "TERA" + (maxBnrAdminId + 1);
context.ProductBanner.Add(ProductBanner);
context.SaveChanges();
}
catch
{
}
}
else
{
Product _product = context.Product.ToList().Where(m => m.Product_Id == item.Product_Id).FirstOrDefault();
if (_product != null)
{
_product.Store_Id = _admin.Store_Id;
_product.Product_Title = item.Product_Title;
_product.Product_Description = item.Product_Description;
_product.Product_Specification = item.Product_Specification;
_product.Administrators_Id = _admin.Administrators_Id;
_product.Product_Qty = item.Product_Qty;
_product.Product_Qty_Alert = item.Product_Qty_Alert;
_product.Product_Delivery_Time = item.Product_Delivery_Time;
_product.Product_Max_Purchase = item.Product_Max_Purchase;
_product.Product_Mkt_Price = item.Product_Mkt_Price;
_product.Product_Our_Price = item.Product_Our_Price;
_product.Product_ShippingCharge = item.Product_ShippingCharge;
_product.Product_Size = item.Product_Size;
_product.Product_Avail_ZipCode = item.Product_Title;
_product.Product_Discount = item.Product_Discount;
_product.SubCategory_Id = item.SubCategory_Id;
_product.Product_UpdatedDate = item.Product_UpdatedDate;
_product.Product_Status = item.Product_Status;
try
{
updateCount = updateCount + 1;
context.Entry(_product).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
catch
{
}
}
else
{
item.Product_Status = "Invalid Product Id";
}
}
}
else
{
item.Product_Status = "Invalid Sub Category Id";
}
}
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-success alert-dismissable";
pnlErrorMessage.Visible = true;
lblMessage.Text = "We are done!! " + insertCount + " Products Inserted and " + updateCount + " Products Updated Successfully also we have dowloaded the updated excel. Please check your download folder.";
DataTable dt = ConvertToDataTable(_products);
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Products.xls"));
Response.ContentType = "application/ms-excel";
string str = string.Empty;
foreach (DataColumn dtcol in dt.Columns)
{
Response.Write(str + dtcol.ColumnName);
str = "\t";
}
Response.Write("\n");
foreach (DataRow dr in dt.Rows)
{
str = "";
for (int j = 0; j < dt.Columns.Count; j++)
{
Response.Write(str + Convert.ToString(dr[j]));
str = "\t";
}
Response.Write("\n");
}
Response.End();
}
public void AddAdministrator(User u)
{
Administrators.Add(u);
}
/// <summary>
/// Je skupina administrovaná členem?
/// </summary>
/// <param name="user">testovaný uživatel</param>
/// <returns></returns>
public bool IsAdminedBy(User user)
{
return(Administrators.Contains(user));
}
public ActionResult SubmitOrder(string addressId, string paymentType)
{
int custId = Convert.ToInt32(Session["UserKey"]);
Customers _cust = bCustomer.List().Where(m => m.Customer_Id == custId).FirstOrDefault();
int custAdrId = Convert.ToInt32(addressId);
int selPaymentType = Convert.ToInt32(paymentType);
List <Carts> _cart = _mcartmdl.GetCarts().Where(m => m.Customer_Id == custId && m.Cart_Status == eCartStatus.Open.ToString()).ToList();
string _res = string.Empty;
foreach (var item in _cart)
{
Product _prd = context.Product.Where(m => m.Product_Id == item.Product_Id).FirstOrDefault();
Order Orders = new Order()
{
Order_Price = item.Cart_Price,
Order_Qty = item.Cart_Qty,
Order_Size = item.Cart_Size,
Order_Status = eOrderStatus.Placed.ToString(),
Product_Id = item.Product_Id,
Product_Banner = item.Product_Banner,
Product_Price = item.Product_Price,
Product_Title = item.Product_Title,
Customer_Id = item.Customer_Id,
Customer_Name = item.Customer_Name,
CustomerAddress_Id = custAdrId,
Payment_Method_Id = selPaymentType,
Order_Date = DateTime.Now,
Order_Delievery_Date = DateTime.Now.AddDays(_prd.Product_Delivery_Time),
Store_Id = _prd.Store_Id,
Order_UpdateDate = DateTime.Now
};
int maxBnrCusAdrAdminId = 1;
if (context.Orders.ToList().Count > 0)
{
maxBnrCusAdrAdminId = context.Orders.Max(m => m.Order_Id);
}
maxBnrCusAdrAdminId = (maxBnrCusAdrAdminId == 1 && context.Orders.ToList().Count > 0) ? (maxBnrCusAdrAdminId + 1) : maxBnrCusAdrAdminId;
Orders.Order_Code = "ORDRACH" + maxBnrCusAdrAdminId + "TERA" + (maxBnrCusAdrAdminId + 1);
context.Orders.Add(Orders);
context.SaveChanges();
Administrators _adm = context.Administrator.Where(m => m.EmailId == "*****@*****.**").FirstOrDefault();
OrderHistory OrderHistories = new OrderHistory()
{
Order_Id = Orders.Order_Id,
OrderHistory_Status = eOrderStatus.Placed.ToString(),
OrderHistory_Description = "Order Submitted successfully on " + DateTime.Now.ToString("D").ToString(),
OrderHistory_CreatedDate = DateTime.Now,
OrderHistory_UpdatedDate = DateTime.Now,
Administrators_Id = _adm.Administrators_Id,
Store_Id = Orders.Store_Id
};
context.OrderHistories.Add(OrderHistories);
context.SaveChanges();
Carts _carts = _mcartmdl.GetCarts().Where(m => m.Cart_Id == item.Cart_Id).FirstOrDefault();
_mcartmdl.DeleteCartByCartId(_carts);
string productUrl = "http://rachnateracotta.com/product/index?id=" + item.Product_Id;
_res = _res + "<tr style='border: 1px solid black;'><td style='border: 1px solid black;'><img src='" + ConfigurationSettings.AppSettings["DomainUrl"].ToString() + item.Product_Banner + "' width='100' height='100'/></td>"
+ "<td style='border: 1px solid black;'><a href='" + productUrl + "'>" + item.Product_Title + "</a></td><td style='border: 1px solid black;'> Total Quantity :" + item.Cart_Qty + " </td><td style='border: 1px solid black;'> " + item.Cart_Price + " </td></tr>";
}
if (Convert.ToBoolean(ConfigurationSettings.AppSettings["IsEmailEnable"]))
{
string host = string.Empty;
host = "<table style='width:100%'>" + _res + "</ table >";
string body = MailHelper.CustomerOrderPlaced(host, (_cust.Customers_FullName));
MailHelper.SendEmail(_cust.Customers_EmailId, "Success!!! You Order Placed In Rachna Teracotta Estore.", body, "Rachna Teracotta Order Placed");
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
public bool ChangeStatus(int UserID, int JobpostingID, string Status, string Date)
{
Administrators administrationManager = new Administrators();
return(administrationManager.UpdateCandidateJobStatus(UserID, JobpostingID, Status, Date));
}
protected void ExportToExcel(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
grdStoreOrders.AllowPaging = false;
if (ddlStatus.Text == "" || txtStartDate.Text != "" || txtEndDate.Text != "")
{
LoadDetail();
}
else
{
using (var ctx = new RachnaDBContext())
{
Administrators _Administrator = null;
_Administrator = bAdministrator.List().Where(m => m.Administrators_Id == Convert.ToInt32(Session[ConfigurationSettings.AppSettings["VendorSession"].ToString()].ToString())).FirstOrDefault();
int storeId = _Administrator.Store_Id;
_RequestList = context.Orders.Where(m => m.Store_Id == storeId).ToList();
if (_RequestList == null)
{
btnExport.Visible = false;
}
grdStoreOrders.DataSource = _RequestList;
grdStoreOrders.DataBind();
}
}
grdStoreOrders.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in grdStoreOrders.HeaderRow.Cells)
{
cell.BackColor = grdStoreOrders.HeaderStyle.BackColor;
}
foreach (GridViewRow row in grdStoreOrders.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = grdStoreOrders.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = grdStoreOrders.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
grdStoreOrders.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
public WSRContext()
{
//if (!(Database.GetService<IDatabaseCreator>() as RelationalDatabaseCreator).Exists())
Database.EnsureDeleted();
Database.EnsureCreated();
if (!Participants.Any())
{
string DPath = Path.GetFullPath(Path.Combine(Directory.GetCurrentDirectory(), @"..\..\"));
DPath += "\\CSV\\";
Database.OpenConnection();
using (var reader = new StreamReader(DPath + "Participants.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Participants.AddRange(csv.GetRecords <Participant>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Participants ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Participants OFF;");
using (var reader = new StreamReader(DPath + "Experts.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Experts.AddRange(csv.GetRecords <Expert>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Experts ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Experts OFF;");
using (var reader = new StreamReader(DPath + "Admins.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Administrators.AddRange(csv.GetRecords <Administrator>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Administrators ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Administrators OFF;");
using (var reader = new StreamReader(DPath + "Coordinators.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Coordinators.AddRange(csv.GetRecords <Coordinator>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Coordinators ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Coordinators OFF;");
List <Competention> temp = new List <Competention>();
using (var reader = new StreamReader(DPath + "Competentions.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
temp.AddRange(csv.GetRecords <Competention>());
}
using (var reader = new StreamReader(DPath + "CompetentionDesc.txt", Encoding.Default))
{
Competention CurrC;
for (int Counter = 1; Counter <= temp.Count; Counter++)//relies on competencies being consequentioal from 1
{
CurrC = temp.FirstOrDefault(c => c.Id == Counter);
CurrC.Description = reader.ReadLine();
}
}
Competentions.AddRange(temp);
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Competentions ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Competentions OFF;");
using (var reader = new StreamReader(DPath + "Championships.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Championships.AddRange(csv.GetRecords <Championship>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Championships ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Championships OFF;");
using (var reader = new StreamReader(DPath + "Infrastructures.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Infrastructures.AddRange(csv.GetRecords <Infrastructure>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Infrastructures ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Infrastructures OFF;");
using (var reader = new StreamReader(DPath + "SMPs.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
SMPs.AddRange(csv.GetRecords <SMP>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.SMPs ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.SMPs OFF;");
using (var reader = new StreamReader(DPath + "Results.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Results.AddRange(csv.GetRecords <Result>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Results ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Results OFF;");
using (var reader = new StreamReader(DPath + "Sponsors.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Sponsors.AddRange(csv.GetRecords <Sponsor>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Sponsors ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Sponsors OFF;");
using (var reader = new StreamReader(DPath + "Volunteers.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Volunteers.AddRange(csv.GetRecords <Volunteer>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Volunteers ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Volunteers OFF;");
Database.CloseConnection();
}
}
/// <summary>Find out if a principal has a certain permission by default.</summary>
/// <param name="user">The principal to check for allowance.</param>
/// <param name="permission">The type of permission to map against.</param>
/// <returns>True if the system is configured to allow the user to the given permission.</returns>
public virtual bool IsAuthorized(IPrincipal user, Permission permission)
{
return((Administrators.MapsTo(permission) && Administrators.Contains(user)) ||
(Editors.MapsTo(permission) && Editors.Contains(user)) ||
(Writers.MapsTo(permission) && Writers.Contains(user)));
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
Administrators _admin = bAdministrator.List().Where(m => m.EmailId == txtUserName.Text).FirstOrDefault();
if (_admin == null)
{
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblErrorMessage.Text = "Oops!!! No entered email id exists in our database.";
}
else if (_admin.Admin_Status == "inactive")
{
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblErrorMessage.Text = "Oops!!! Cannot login to your account, becaues your account is inactive. Please raise request to activate your account.";
}
else if (_admin.Admin_Login_Attempt > 5)
{
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblErrorMessage.Text = "Oops!!! Cannot login to your account, becaues your account is locked. Please raise request to unlock your account.";
}
else if (_admin.Password != txtPassword.Text && _admin.Admin_Login_Attempt < 5)
{
_admin.Admin_Login_Attempt = (_admin.Admin_Login_Attempt + 1);
_admin.Admin_UpdatedDate = DateTime.Now;
_admin = bAdministrator.Update(_admin);
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblErrorMessage.Text = "Oops!!! Entered password is invalid for entered emailid.";
}
else
{
ActivityHelper.Create("Login", "Loogged In on " + DateTime.Now.ToString("D") + " Successfully", _admin.Administrators_Id);
pnlErrorMessage.Visible = false;
lblErrorMessage.Text = "";
if (_admin.Admin_Role != eRole.Vendor.ToString())
{
Session[ConfigurationSettings.AppSettings["SupportSession"].ToString()] = _admin.Administrators_Id;
if (_admin.Admin_Login_Attempt != 0)
{
_admin.Admin_Login_Attempt = 0;
_admin.Admin_UpdatedDate = DateTime.Now;
_admin = bAdministrator.Update(_admin);
}
if (Session["PreviousUrl"] != null)
{
Response.Redirect(Session["PreviousUrl"].ToString(), false);
}
else
{
Response.Redirect("/support/home/default.aspx?redirecturl=rachna-teracotta-home");
}
}
else
{
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblErrorMessage.Text = "Oops!! You are not authorized user to access this page.";
}
}
}
catch (Exception ex)
{
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblErrorMessage.Text = "Oops!! Server error occured, please contact administrator.";
}
}
private bool IsDuplicateName(string _name)
{
var q = Administrators.Count(x => x.Name == _name);
return(q > 1);
}
//Delete
private bool CanExecuteDelete(object obj)
{
return(Administrators.Count(x => x.Selected) > 0);
}
/*******Begin code to modify********/
/// <summary>
/// Create a new user of the LMS with the specified information.
/// Assigns the user a unique uID consisting of a 'u' followed by 7 digits.
/// </summary>
/// <param name="fName">First Name</param>
/// <param name="lName">Last Name</param>
/// <param name="DOB">Date of Birth</param>
/// <param name="SubjectAbbrev">The department the user belongs to (professors and students only)</param>
/// <param name="SubjectAbbrev">The user's role: one of "Administrator", "Professor", "Student"</param>
/// <returns>A unique uID that is not be used by anyone else</returns>
public string CreateNewUser(string fName, string lName, DateTime DOB, string SubjectAbbrev, string role)
{
string uID = "";
using (db = new Team77LMSContext())
{
var query =
(from p in db.Users
orderby p.UId descending
select p.UId).Take(1);
/*
* System.Diagnostics.Debug.WriteLine("----------");
* System.Diagnostics.Debug.WriteLine(query.ToArray()[0]);
* System.Diagnostics.Debug.WriteLine(query.ToArray()[1]);
* System.Diagnostics.Debug.WriteLine(query.ToArray()[2]);
* System.Diagnostics.Debug.WriteLine("----------");
*/
if (query.ToArray().Count() != 0)
{
// System.Diagnostics.Debug.WriteLine("0");
uID = query.ToArray()[0];
}
else
{
uID = "first";
}
}
if (uID != "first")
{
uID = uID.Substring(1, 7);
int temp = Int32.Parse(uID) + 1;
uID = 'u' + temp.ToString();
while (uID.Count() < 8)
{
uID = uID.Insert(1, "0");
}
}
else
{
uID = "u0000000";
}
using (db = new Team77LMSContext())
{
Users user = new Users();
user.UId = uID;
user.FName = fName;
user.LName = lName;
user.Dob = DOB;
db.Users.Add(user);
if (role == "Administrator")
{
Administrators admin = new Administrators();
admin.UId = uID;
db.Administrators.Add(admin);
}
else if (role == "Professor")
{
Professor pf = new Professor();
pf.UId = uID;
pf.Subject = SubjectAbbrev;
db.Professor.Add(pf);
}
else if (role == "Student")
{
Students st = new Students();
st.UId = uID;
st.Subject = SubjectAbbrev;
user.Students = st;
db.Students.Add(st);
System.Diagnostics.Debug.WriteLine("3");
}
db.SaveChanges();
}
return(uID);
}
public void Insert(Administrators admin)
{
_ctx.administrator.Add(admin);
_ctx.SaveChanges();
}
/*******Begin code to modify********/
/// <summary>
/// Create a new user of the LMS with the specified information.
/// Assigns the user a unique uID consisting of a 'u' followed by 7 digits.
/// </summary>
/// <param name="fName">First Name</param>
/// <param name="lName">Last Name</param>
/// <param name="DOB">Date of Birth</param>
/// <param name="SubjectAbbrev">The department the user belongs to (professors and students only)</param>
/// <param name="role">The user's role: one of "Administrator", "Professor", "Student"</param>
/// <returns>A unique uID that is not be used by anyone else</returns>
public string CreateNewUser(string fName, string lName, DateTime DOB, string SubjectAbbrev, string role)
{
string uID = "";
switch (role)
{
case "Administrator":
while (true)
{
uID = "u" + RandomNumber(0, 9999999).ToString();
var query =
from a in db.Administrators
where a.UId == uID
select a;
if (!query.Any())
{
Administrators admin = new Administrators {
UId = uID,
FirstName = fName,
LastName = lName,
Dob = DOB
};
db.Administrators.Add(admin);
try {
db.SaveChanges();
}
catch (Exception e) {
Console.WriteLine(e.Message);
}
break;
}
}
break;
case "Professor":
while (true)
{
uID = "u" + RandomNumber(0, 9999999).ToString();
var query =
from a in db.Professors
where a.UId == uID
select a;
if (!query.Any())
{
Professors prof = new Professors {
UId = uID,
FirstName = fName,
LastName = lName,
Dob = DOB,
Department = SubjectAbbrev
};
db.Professors.Add(prof);
try {
db.SaveChanges();
}
catch (Exception e) {
Console.WriteLine(e.Message);
}
break;
}
}
break;
case "Student":
while (true)
{
uID = "u" + RandomNumber(0, 9999999).ToString();
var query =
from a in db.Students
where a.UId == uID
select a;
if (!query.Any())
{
Students student = new Students {
UId = uID,
FirstName = fName,
LastName = lName,
Dob = DOB,
Major = SubjectAbbrev
};
db.Students.Add(student);
try {
db.SaveChanges();
}
catch (Exception e) {
Console.WriteLine(e.Message);
}
break;
}
}
break;
default:
Console.WriteLine("SOMETHING WENT WRONG");
break;
}
return(uID);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Invitations _invitation = bInvitations.List().Where(m => m.Invitation_EmailId == txtEmailId.Text).FirstOrDefault();
Administrators _administrators = bAdministrator.List().Where(m => m.EmailId == txtEmailId.Text).FirstOrDefault();
if (_invitation == null && _administrators == null)
{
Invitations invitations = new Invitations()
{
Store_Id = Convert.ToInt32(ddlStore.SelectedValue),
Invitation_Code = Guid.NewGuid().ToString(),
Invitation_EmailId = txtEmailId.Text,
Invitation_CreatedDate = DateTime.Now,
Invitation_Status = eStatus.Active.ToString(),
Role = ddlRole.Text,
Invitation_UpdatedDate = DateTime.Now,
Send_Activity_Mail = (chkGetActivityMail.Checked) ? 1 : 0
};
invitations = bInvitations.Create(invitations);
ActivityHelper.Create("New Invitation", "New Invitation Created On " +
DateTime.Now.ToString("D") + " Successfully, for EmailId " + invitations.Invitation_EmailId + ".",
Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()));
if (String.IsNullOrEmpty(invitations.ErrorMessage))
{
if (Convert.ToBoolean(ConfigurationSettings.AppSettings["IsEmailEnable"]))
{
txtEmailId.Text = "";
ddlRole.SelectedIndex = 0;
ddlStore.SelectedIndex = 0;
string host = ConfigurationSettings.AppSettings["DomainUrl"].ToString();
host = host + "account/invitation.aspx?code=" + invitations.Invitation_Code + "&emailid=" + invitations.Invitation_EmailId;
string body = MailHelper.InvitationLink(host);
MailHelper.SendEmail(invitations.Invitation_EmailId, "Hurray!!! You Are Invited To Rachna Teracotta.", body, "Rachna Teracotta Invitation");
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-success alert-dismissable";
pnlErrorMessage.Visible = true;
lblMessage.Text = "Success! New Invitation Successfully.";
}
else
{
txtEmailId.Text = "";
ddlRole.SelectedIndex = 0;
ddlStore.SelectedIndex = 0;
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-success alert-dismissable";
pnlErrorMessage.Visible = true;
lblMessage.Text = "Success! New Invitation Successfully.";
}
}
else
{
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblMessage.Text = "Failed!" + invitations.ErrorMessage;
}
_invitation = null;
invitations = null;
}
else
{
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblMessage.Text = "Oops!! Invitation cannot be created, because entered email id already exists in the database.";
}
}
catch (Exception ex)
{
pnlErrorMessage.Attributes.Remove("class");
pnlErrorMessage.Attributes["class"] = "alert alert-danger alert-dismissable";
pnlErrorMessage.Visible = true;
lblMessage.Text = ex.InnerException.InnerException.Message;
}
}
public bool IsUserAdministrator(User u)
{
bool ad = Administrators.Contains(u);
return(ad);
}
/// <summary>Find out if a princpial has admin access.</summary>
/// <param name="user">The princpial to check.</param>
/// <returns>A boolean indicating whether the principal has admin access.</returns>
public virtual bool IsAdmin(IPrincipal user)
{
return(Administrators.Contains(user));
}
protected void Button1_Click(object sender, EventArgs e)
{
string _res = string.Empty;
using (var ctx = new RachnaDBContext())
{
int productId = Convert.ToInt32(hdnOrderId.Value);
Order _productOrder = new Order();
_productOrder = ctx.Orders.ToList().Where(m => m.Order_Id == productId).FirstOrDefault();
if (_productOrder.Order_Status != eOrderStatus.Rejected.ToString())
{
if (_productOrder.Order_Status != ddlSorderStatus.Text)
{
if (_productOrder.Order_Status ==
eOrderStatus.Approved.ToString() &&
(ddlSorderStatus.Text == eOrderStatus.Placed.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Approved.ToString()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Order", "new Messi('update failed because, order status is lower then current.', { title: 'Failed!! ' });", true);
}
else if (_productOrder.Order_Status ==
eOrderStatus.Packed.ToString() &&
(ddlSorderStatus.Text == eOrderStatus.Placed.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Approved.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Packed.ToString()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Order", "new Messi('update failed because, order status is lower then current.', { title: 'Failed!! ' });", true);
}
else if (_productOrder.Order_Status == eOrderStatus.Shipped.ToString() &&
(ddlSorderStatus.Text == eOrderStatus.Placed.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Approved.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Packed.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Shipped.ToString()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Order", "new Messi('update failed because, order status is lower then current.', { title: 'Failed!! ' });", true);
}
else if (_productOrder.Order_Status == eOrderStatus.Delevery.ToString() &&
(ddlSorderStatus.Text == eOrderStatus.Placed.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Approved.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Packed.ToString() ||
ddlSorderStatus.Text == eOrderStatus.Shipped.ToString()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Order", "alert('update failed because, order status is lower then current');", true);
}
else
{
_productOrder.Order_Status = ddlSorderStatus.Text;
ctx.Entry(_productOrder).State = EntityState.Modified;
ctx.SaveChanges();
var adminId = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()]);
Administrators _adm = ctx.Administrator.Where(m => m.Administrators_Id == adminId).FirstOrDefault();
OrderHistory _orderCancel = new OrderHistory();
_orderCancel.Order_Id = Convert.ToInt32(hdnOrderId.Value);
_orderCancel.OrderHistory_Description = txtOrderDescription.Text;
_orderCancel.OrderHistory_Status = ddlSorderStatus.Text;
_orderCancel.OrderHistory_CreatedDate = DateTime.Now;
_orderCancel.OrderHistory_UpdatedDate = DateTime.Now;
_orderCancel.Administrators_Id = _adm.Administrators_Id;
_orderCancel.Store_Id = _adm.Store_Id;
ctx.OrderHistories.Add(_orderCancel);
ctx.SaveChanges();
if (pnlDeleveryTeam.Visible == true)
{
OrderDelivery OrderDelivery = new OrderDelivery()
{
Order_Id = _productOrder.Order_Id,
Administrators_Id = Convert.ToInt32(Session[ConfigurationSettings.AppSettings["AdminSession"].ToString()].ToString()),
TeamId = Convert.ToInt32(ddlDelieveryTeam.SelectedValue.ToString()),
Comment = txtOrderDescription.Text,
Status = eOrderDeliveryStatus.InTransist.ToString(),
Store_Id = _productOrder.Store_Id,
Customer_Id = _productOrder.Customer_Id,
DateCreated = DateTime.Now,
DateUpdated = DateTime.Now
};
ctx.OrderDelivery.Add(OrderDelivery);
ctx.SaveChanges();
}
Customers _cust = ctx.Customer.ToList().Where(m => m.Customer_Id == Convert.ToInt32(_productOrder.Customer_Id)).FirstOrDefault();
string productUrl = "http://rachnateracotta.com/product/index?id=" + _productOrder.Product_Id;
_res = _res + "<tr style='border: 1px solid black;'><td style='border: 1px solid black;'><img src='" + _productOrder.Product_Banner + "' width='100' height='100'/></td>"
+ "<td style='border: 1px solid black;'><a href='" + productUrl + "'>" + _productOrder.Product_Title + "</a></td><td style='border: 1px solid black;'> Total Quantity :" + _productOrder.Order_Qty + " </td><td style='border: 1px solid black;'> " + _productOrder.Order_Price + " </td></tr>";
if (Convert.ToBoolean(ConfigurationSettings.AppSettings["IsEmailEnable"]))
{
string host = string.Empty;
host = "<table style='width:100%'>" + _res + "</ table >";
string body = MailHelper.CustomerOrderProcessed(host, (_cust.Customers_FullName), txtOrderDescription.Text);
MailHelper.SendEmail(_cust.Customers_EmailId, "Success!!! " + txtOrderDescription.Text + " Rachna Teracotta Estore.", body, "Rachna Teracotta Order" + txtOrderDescription.Text);
}
Response.Redirect("/administration/salesmanagement/vorderdetail.aspx?orderId=" + hdnOrderId.Value + "&requesttype=view-order-detail.html");
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Order", "new Messi('update failed because, order status is same as current.', { title: 'Failed!! ' });", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Order", "new Messi('update failed because, order status is not valid.', { title: 'Failed!! ' });", true);
}
}
}