public void DbRefMapsToOtherDocumentsByCustomId()
{
const string databaseName = "NormTests";
const string userId = "Tim Berners-Lee";
const string roleName = "Administrator";
using (var session = new Session())
{
session.Drop<User>();
session.Drop<Role>();
session.Add(new User
{
Id = userId,
EmailAddress = "*****@*****.**"
});
session.Add(new Role
{
Id = roleName,
Users = new List<DbReference<User, string>>
{
new DbReference<User, string>(userId)
}
});
}
var server = Mongo.Create("mongodb://localhost/" + databaseName);
var role = server.GetCollection<Role>().Find().First();
var user = role.Users[0].Fetch(() => server);
Assert.Equal(userId, user.Id);
}
public void DbRefMapsToOtherDocumentsByOid()
{
const string databaseName = "NormTests";
var id = ObjectId.NewObjectId();
using (var session = new Session())
{
session.Drop<Product>();
session.Drop<ProductReference>();
session.Add(new Product { _id = id, Name = "RefProduct" });
var productReference = new DbReference<Product>(id);
session.Add(new ProductReference
{
Id = ObjectId.NewObjectId(),
Name = "FullCart",
ProductsOrdered = new[] { productReference }
});
}
var server = Mongo.Create("mongodb://localhost/" + databaseName);
var reference = server.GetCollection<ProductReference>().Find().First();
var product = reference.ProductsOrdered[0].Fetch(() => server);
Assert.Equal(id.Value, product._id.Value);
}
public void DBRefMapsToOtherDocumentsByOid()
{
var id = ObjectId.NewObjectId();
using (var session = new Session())
{
session.Add(new Product { Id = id, Name = "RefProduct" });
var productReference = new DBReference
{
Collection = MongoConfiguration.GetCollectionName(typeof(Product)),
DatabaseName = "test",
ID = id,
};
session.Add(new ProductReference
{
Id = ObjectId.NewObjectId(),
Name = "FullCart",
ProductsOrdered = new[] { productReference }
});
}
var server = Mongo.ParseConnection("mongodb://localhost/NoRMTests");
var reference = server.GetCollection<ProductReference>().Find().First();
var product = reference.ProductsOrdered[0].Fetch(() => GetReferenceCollection());
Assert.Equal(id.Value, product.Id.Value);
}
public void AvgShouldReturn20WhenThreeProductsInDBWIthSumPrice60()
{
using (var session = new Session()) {
session.Add(new Product { Name = "1", Price = 10 });
session.Add(new Product { Name = "2", Price = 20 });
session.Add(new Product { Name = "3", Price = 30 });
var result = session.Products.Average(x => x.Price);
Assert.Equal(20, result);
}
}
public void OneProductsShouldBeReturnedWhen3InDbWithPriceEqual10()
{
using (var session = new Session()) {
session.Add(new Product { Name = "Test3", Price = 10 });
session.Add(new Product { Name = "Test4", Price = 22 });
session.Add(new Product { Name = "Test5", Price = 33 });
var products = session.Products.Where(x => x.Price ==10).ToList();
Assert.Equal(1, products.Count);
}
}
public void AnyShouldReturnTrueWhenProductPrice10()
{
using (var session = new Session()) {
session.Add(new Product { Name = "1", Price = 10 });
session.Add(new Product { Name = "2", Price = 20 });
session.Add(new Product { Name = "3", Price = 30 });
Assert.True(session.Products.Any(x=>x.Price==10));
}
}
public void CountShouldReturn2WhenThreeProductsInDBAndWherePriceGreaterThan20()
{
using (var session = new Session()) {
session.Add(new Product { Name = "1", Price = 10 });
session.Add(new Product { Name = "2", Price = 22 });
session.Add(new Product { Name = "3", Price = 33 });
var result = session.Products.Where(x=>x.Price>20).Count();
Assert.Equal(2, result);
}
}
public void OneProductShouldBeReturnedWhen3InDbWithSingle()
{
using (var session = new Session())
{
session.Add(new Product {Name = "Test1", Price = 10});
session.Add(new Product {Name = "Test2", Price = 22});
session.Add(new Product {Name = "Test3", Price = 33});
var result = session.Products.SingleOrDefault(x => x.Price == 22);
Assert.Equal(22, result.Price);
}
}
public void OneProductShouldBeReturnedWhenNestedSupplierQueried()
{
using (var session = new Session())
{
session.Add(new TestProduct { Name = "Test3", Price = 10, Supplier = new Supplier { Name = "Steve" } });
session.Add(new TestProduct { Name = "Test4", Price = 22 });
session.Add(new TestProduct { Name = "Test5", Price = 33 });
var products = session.Products.Where(x => x.Supplier.Name == "Steve").ToList();
Assert.Equal(1, products.Count);
}
}
public void LastTwoProductsofThreeShouldBeReturnedWithSkipTake()
{
using (var session = new Session()) {
session.Add(new Product { Name = "Test1", Price = 10 });
session.Add(new Product { Name = "Test2", Price = 22 });
session.Add(new Product { Name = "Test3", Price = 33 });
var products = session.Products.Skip(1).Take(2).ToList();
Assert.Equal(22.0, products[0].Price);
Assert.Equal(33.0, products[1].Price);
}
}
public void AvgShouldReturn15WhenThreeProductsInDBWIthSumPrice60AndLessThan30()
{
using (var session = new Session())
{
session.Add(new TestProduct { Name = "1", Price = 10 });
session.Add(new TestProduct { Name = "2", Price = 20 });
session.Add(new TestProduct { Name = "3", Price = 30 });
var result = session.Products.Where(x => x.Price < 30).Average(x => x.Price);
Assert.Equal(15, result);
}
}
public void SupplierShouldBeQuerybleByAddress()
{
using (var session = new Session())
{
var add = new Address { State = "HI", Street = "100 Main" };
session.Add(new TestProduct { Name = "Test3", Price = 10, Supplier = new Supplier { Name = "Steve", CreatedOn = new DateTime(2000, 2, 1), Address = add } });
session.Add(new TestProduct { Name = "Test4", Price = 22, Supplier = new Supplier { Name = "Steve", CreatedOn = new DateTime(2001, 2, 1) } });
session.Add(new TestProduct { Name = "Test5", Price = 33, Supplier = new Supplier { Name = "Steve", CreatedOn = new DateTime(2002, 2, 1) } });
var products = session.Products.Where(x => x.Supplier.Address.State == "HI").ToList();
Assert.Equal(1, products.Count);
}
}
public void OneProductShouldBeReturnedWhen3InDbWithFirst()
{
using (var session = new Session())
{
session.CreateCappedCollection("Product"); //only capped collections return in insertion order
session.Add(new Product {Name = "Test1", Price = 10});
session.Add(new Product {Name = "Test2", Price = 22});
session.Add(new Product {Name = "Test3", Price = 33});
var result = session.Products.First();
Assert.Equal("Test1", result.Name);
}
}
public void CountShouldReturn2WhenThreeProductsInDBAndWherePriceGreaterThan20()
{
using (var session = new Session())
{
session.Add(new TestProduct { Name = "1", Price = 10 });
session.Add(new TestProduct { Name = "2", Price = 22 });
session.Add(new TestProduct { Name = "3", Price = 33 });
var queryable = session.Products;
var result = queryable.Where(x => x.Price > 20).Count();
Assert.Equal(2, result);
Assert.Equal(false, queryable.QueryStructure().IsComplex);
}
}
public void FourProductsShouldBeReturnedWhenStartsOrEndsWithX()
{
using (var session = new Session())
{
session.Add(new Product {Name = "Test3X", Price = 10});
session.Add(new Product {Name = "Test4X", Price = 22});
session.Add(new Product {Name = "Test5", Price = 33});
session.Add(new Product {Name = "XTest3", Price = 10});
session.Add(new Product {Name = "XTest4", Price = 22});
var products = session.Products.Where(x => x.Name.StartsWith("X") || x.Name.EndsWith("X")).ToList();
Assert.Equal(4, products.Count);
}
}
public void SumShouldReturn60WhenThreeProductsInDBWIthSumPrice60()
{
using (var session = new Session())
{
session.Add(new TestProduct { Name = "dd", Price = 10 });
session.Add(new TestProduct { Name = "ss", Price = 20 });
session.Add(new TestProduct { Name = "asdasddds", Price = 30 });
var queryable = session.Products;
var result = queryable.Sum(x => x.Price);
Assert.Equal(60, result);
Assert.Equal(false, queryable.QueryStructure().IsComplex);
}
}
public void One_Product_Should_Be_Returned_When_Nested_Supplier_Queried()
{
var session = new Session();
session.Drop<Product>();
session.Add(new Product() { Name = "Test3", Price = 10, Supplier = new Supplier() { Name = "Steve" } });
session.Add(new Product() { Name = "Test4", Price = 22 });
session.Add(new Product() { Name = "Test5", Price = 33 });
var products = session.Products.Where(x => x.Supplier.Name == "Steve").ToList();
Assert.AreEqual(1, products.Count);
}
public void FiltersBasedOnObjectId()
{
var targetId = ObjectId.NewObjectId();
using (var session = new Session())
{
session.Add(new Product { Name = "Test1", Price = 10, Id = targetId });
session.Add(new Product { Name = "Test2", Price = 22 });
session.Add(new Product { Name = "Test3", Price = 33 });
var products = session.Products.Where(p => p.Id == targetId).ToList();
Assert.Equal(1, products.Count);
Assert.Equal(targetId, products[0].Id);
}
}
public void SupplierShouldBeQuerybleByAddressAndWorkWithAndExpression()
{
using (var session = new Session())
{
var add = new Address { State = "HI", Street = "100 Main" };
session.Add(new TestProduct { Name = "Test3", Price = 10, Supplier = new Supplier { Name = "Steve", CreatedOn = new DateTime(2000, 2, 1), Address = add } });
session.Add(new TestProduct { Name = "Test4", Price = 22, Supplier = new Supplier { Name = "Steve", CreatedOn = new DateTime(2001, 2, 1) } });
session.Add(new TestProduct { Name = "Test5", Price = 33, Supplier = new Supplier { Name = "Steve", CreatedOn = new DateTime(2002, 2, 1) } });
var queryable = session.Products;
var products = queryable.Where(x => x.Supplier.Address.State == "HI" && x.Price == 10).ToList();
Assert.Equal(1, products.Count);
Assert.Equal(false, queryable.QueryStructure().IsComplex);
}
}
public void Count_Should_Return_One_When_Id_Matches()
{
var target = ObjectId.NewObjectId();
using (var session = new Session())
{
session.Add(new TestProduct { Name = "1", Price = 40, _id = target });
session.Add(new TestProduct { Name = "2", Price = 22, _id = ObjectId.NewObjectId() });
session.Add(new TestProduct { Name = "3", Price = 33, _id = ObjectId.NewObjectId() });
var queryable = session.Products;
var result = queryable.Where(x => x._id == target).Count();
Assert.Equal(1, result);
Assert.Equal(false, queryable.QueryStructure().IsComplex);
}
}
public void Supplier_Should_Be_Queryble_By_Address_And_Work_With_Or_Expression()
{
var session = new Session();
session.Drop<Product>();
var add = new Address() { State = "HI", Street = "100 Main" };
session.Add(new Product() { Name = "Test3", Price = 10, Supplier = new Supplier() { Name = "Steve", CreatedOn = new DateTime(2000, 2, 1), Address = add } });
session.Add(new Product() { Name = "Test4", Price = 22, Supplier = new Supplier() { Name = "Steve", CreatedOn = new DateTime(2001, 2, 1) } });
session.Add(new Product() { Name = "Test5", Price = 33, Supplier = new Supplier() { Name = "Steve", CreatedOn = new DateTime(2002, 2, 1) } });
var products = session.Products.Where(x => x.Supplier.Address.State == "HI" || x.Price == 33).ToList();
Assert.AreEqual(2, products.Count);
}
public void CountShouldReturn3WhenThreeProductsInDB()
{
using (var session = new Session())
{
session.Add(new TestProduct { Name = "1", Price = 10 });
session.Add(new TestProduct { Name = "2", Price = 22 });
session.Add(new TestProduct { Name = "3", Price = 33 });
var productQueryable = session.Products;
Assert.Equal(3, productQueryable.Count());
Assert.Equal(false, productQueryable.QueryStructure().IsComplex);
}
}
public void Supplier_Should_Be_Queryble_By_DateMath()
{
var session = new Session();
session.Drop<Product>();
var add = new Address() { State = "HI", Street = "100 Main" };
session.Add(new Product() { Name = "Test3", Price = 10, Supplier = new Supplier() { Name = "Steve", CreatedOn = new DateTime(2000, 2, 1), Address = add } });
session.Add(new Product() { Name = "Test4", Price = 22, Supplier = new Supplier() { Name = "Steve", CreatedOn = new DateTime(2001, 2, 1) } });
session.Add(new Product() { Name = "Test5", Price = 33, Supplier = new Supplier() { Name = "Steve", CreatedOn = new DateTime(2002, 2, 1) } });
var products = session.Products.Where(x => x.Supplier.CreatedOn.Year<2001).ToList();
//this is returning all three for some reason...
Assert.AreEqual(1, products.Count);
}
static void Main(string[] args)
{
DateTime start = DateTime.Now;
using (var session = new Session<PostCodes>(Settings.DocumentDatabaseName))
{
using(var dc = new CodePointOpenDataContext())
{
var postcodes = from pc in dc.PostCodeGeoDatas
select
new PostCodes
{
PostCode = pc.PostCode,
loc = new[] { (double)pc.Latitude, (double)pc.Longitude }
};
foreach (var postCodeEntry in postcodes)
{
session.Add(postCodeEntry);
}
//Parallel.ForEach(postcodes, postcode => session.Add(postcode));
}
}
DateTime end = DateTime.Now;
TimeSpan result = end - start;
Console.WriteLine(result.TotalMilliseconds);
Console.ReadKey();
}
public void MongoQueryExplainsExecutionPlansForFlyweightQueries()
{
using (var session = new Session())
{
session.Add(new Product
{
Name = "ExplainProduct",
Price = 10,
Supplier = new Supplier { Name = "Supplier", CreatedOn = DateTime.Now }
});
// NOTE: these unit tests aren't 100% valid since adding an index in code isn't
// supported yet. In order to see meaningful results you have to manually
// add an index for now.
// Run the following command in Mongo.exe against the Product collection
// db.Product.ensureIndex({"Supplier.Name":1})
// Then you can run this command to see a hydrated explain plan
// db.Product.find({"Supplier.Name":"abc"})
// The following is the same as runging: db.Product.find({"Supplier.Name":"abc"}).explain()
var query = new Flyweight();
query["Supplier.Name"] = Q.Equals("Supplier");
var result = session.Provider.DB.GetCollection<Product>().Explain(query);
Assert.NotNull(result.cursor);
}
}
public void MongoQueryExplainsExecutionPlansForFlyweightQueries()
{
using (var session = new Session())
{
session.Drop<TestProduct>();
session.DB.GetCollection<TestProduct>().CreateIndex(p => p.Supplier.Name, "TestIndex", true, IndexOption.Ascending);
session.Add(new TestProduct
{
Name = "ExplainProduct",
Price = 10,
Supplier = new Supplier { Name = "Supplier", CreatedOn = DateTime.Now }
});
// To see this manually you can run the following command in Mongo.exe against
//the Product collection db.Product.ensureIndex({"Supplier.Name":1})
// Then you can run this command to see a detailed explain plan
// db.Product.find({"Supplier.Name":"abc"})
// The following query is the same as running: db.Product.find({"Supplier.Name":"abc"}).explain()
var query = new Expando();
query["Supplier.Name"] = Q.Equals("Supplier");
var result = session.DB.GetCollection<TestProduct>().Explain(query);
Assert.Equal("BtreeCursor TestIndex", result.Cursor);
}
}
public void CanQueryAndReturnSubClassedObjects()
{
using (var session = new Session())
{
session.Drop<SuperClassObject>();
session.Add<SuperClassObject>(new SubClassedObject { Title = "Find This", ABool = true });
session.Add<SuperClassObject>(new SubClassedObject { Title = "Don't Find This", ABool = false });
var query = new MongoQuery<SuperClassObject>(session.Provider);
var dtos = query.Where(dto => dto.Title == "Find This").ToList();
Assert.Equal(1, dtos.Count);
Assert.Equal("Find This", dtos[0].Title);
}
}
public void CanQueryAndReturnSubClassedObjects()
{
using (var session = new Session())
{
session.Drop<SuperClassObject>();
session.Add<SuperClassObject>(new SubClassedObject { Title = "Find This", ABool = true });
session.Add<SuperClassObject>(new SubClassedObject { Title = "Don't Find This", ABool = false });
var queryable = session.DB.GetCollection<SuperClassObject>().AsQueryable();
var dtos = queryable.Where(dto => dto.Title == "Find This").ToList();
Assert.Equal(1, dtos.Count);
Assert.Equal("Find This", dtos[0].Title);
Assert.Equal(false, queryable.QueryStructure().IsComplex);
}
}
public void CountShouldReturn3WhenThreeProductsInDB()
{
using (var session = new Session()) {
session.Add(new Product { Name = "1", Price = 10 });
session.Add(new Product { Name = "2", Price = 22 });
session.Add(new Product { Name = "3", Price = 33 });
var result = session.Products.Count();
Assert.Equal(3, result);
}
}
public void AvgShouldReturn500Point5WhenSumOfAllNumbersUpTo1000()
{
using (var session = new Session())
{
for (var i = 0; i < 1000; i++)
{
session.Add(new Product { Name = i.ToString(), Price = i + 1 });
}
var result = session.Products.Average(x => x.Price);
Assert.Equal(500.5, result);
}
}
public ActionResult QuenMatKhau(TaiKhoan tk)
{
// var result = db.CheckAcount(l.UserName, Encrypter.MD5Hash(l.PassWord));
if (ModelState.IsValid)
{
var lk = db.QuenMatKhau(tk.UserName);
var result = Convert.ToInt32(lk[0]);
switch (result)
{
case 0:
ModelState.AddModelError("", "Tài khoản không tồn tại");
break;
case 1:
matkhausesion acc = lk[1] as matkhausesion;
Session.Add("matkhau_Session", acc);
//SessionHelper.SetSession(new UserSession() { UserName = l.UserName });
return(RedirectToAction("DoiMatKhau", "LoginAdmin", acc));
case -1:
ModelState.AddModelError("", "Tài khoản đang bị khóa");
break;
default:
ModelState.AddModelError("", "User name không đúng");
break;
}
;
}
else
{
ModelState.AddModelError("", "User name không đúng");
}
return(View(tk));
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
// Response.Write("<script>window.alert('your message')</script>");
Session.Add("cindex", DropDownList1.SelectedIndex);
if (DropDownList1.SelectedIndex >= 0)
{
sel1 = DropDownList1.SelectedIndex;
// Response.Write(@"<script>window.alert('"+sel1+@"')</script>");
classinfo cin = lclinfo[sel1];
lce = getclexerl(cin);
erl = getexerl2(cin);
GridView1.DataSource = null;
GridView1.DataBind();
// persons.Join(cities, p => p.CityID, c => c.ID, (p, c) => new { PersonName = p.Name, CityName = c.Name });
var q1 = lce.Join(erl, p => p.eid, c => c.id, (p, c) => new extime(p.eid, c.name, p.starttime, p.endtime));
ltemp = q1.OrderBy(s => s.stime).ToList <extime>();
GridView1.DataSource = ltemp;
GridView1.DataBind();
Session.Add("ltemp", ltemp);
//
var questionQuery = from o in pp.context.View_class_exp
where (o.classid == cin.classid)
orderby o.con
select o;
if (questionQuery.Count() > 0)
{
lvce = questionQuery.ToList <View_class_exp>();
}
GridView2.DataSource = lvce;
GridView2.DataBind();
Session.Add("lvce", lvce);
//
}
}
protected void btnSifreYenile_Click1(object sender, EventArgs e)
{
kullaniciMail = txtSifremiUnuttumMail.Text;
kullaniciNumara = txtSifremiUnuttumTelNo.Text;
if (kullaniciMail != "" && kullaniciNumara != "")
{
SqlConnection baglanti = new SqlConnection("Server=.;Database=urunKayitListeleme;Integrated Security = True");
sorgu = "Select * from tblMusteri where musteriUser=@user AND musteriNo=@numara";
SqlCommand komut = new SqlCommand(sorgu, baglanti);
komut.Parameters.AddWithValue("@numara", kullaniciNumara);
komut.Parameters.AddWithValue("@user", kullaniciMail);
baglanti.Open();
SqlDataReader oku = komut.ExecuteReader();
try
{
if (oku.Read())
{
Session["numara"] = kullaniciNumara;
Session.Add("kullanici", kullaniciMail);
Response.Redirect("SifreYenile.aspx");
}
else
{
lblinfo.Text = "Giriş Başarısız !!!";
}
baglanti.Close();
}
catch (Exception)
{
lblinfo.Text = "Giriş Başarısız !!!";
}
}
else
{
lblinfo.Text = "Girdiler Boş Geçilemez !";
}
}
protected void imbLogin_Click(object sender, ImageClickEventArgs e)
{
DataTable dt = BINROTA.BUS.Members.GetMemberInfoForLogin(txtUserName.Text, CARETTA.COM.Encryption.Encrypt(txtPassword.Text.Trim()));
if (dt.Rows.Count > 0)
{
if (bool.Parse(dt.Rows[0]["isActive"].ToString()))
{
SessionRoot objSession = new SessionRoot(int.Parse(dt.Rows[0]["MemberID"].ToString()));
objSession.FullName = dt.Rows[0]["FirstName"].ToString() + " " + dt.Rows[0]["LastName"].ToString();
objSession.NickName = dt.Rows[0]["NickName"].ToString();
objSession.LoginType = (int)Enumerations.LoginType.Member;
Session.Add("SessionRoot", objSession);
Common.GotoDefaultPage(this.Response);
}
else
{
Response.Write("<script language='javascript'> {window.open('Result.aspx?Message=' + 'Henüz hesabýnýz aktif edilmemiþtir. Lütfen tekrar deneyin', 'BinrotaResult', 'width=490,height=300,toolbar=no,resizable=no,scrollbars=no,');}</script>");
}
}
else
{
dt = BINROTA.BUS.Users.GetUserInfoForLogin(txtUserName.Text, CARETTA.COM.Encryption.Encrypt(txtPassword.Text.Trim()));
if (dt.Rows.Count > 0)
{
SessionRoot objSession = new SessionRoot(int.Parse(dt.Rows[0]["UserID"].ToString()));
objSession.FullName = dt.Rows[0]["FirstName"].ToString() + " " + dt.Rows[0]["LastName"].ToString();
objSession.NickName = objSession.FullName;
objSession.LoginType = (int)Enumerations.LoginType.User;
Session.Add("SessionRoot", objSession);
Common.GotoDefaultPage(this.Response);
}
else
{
Response.Write("<script language='javascript'> {window.open('Result.aspx?Message=' + 'Yanlýþ kullanýcý adý ya da þifre girdiniz. Lütfen tekrar deneyin', 'BinrotaResult', 'width=490,height=300,toolbar=no,resizable=no,scrollbars=no,');}</script>");
}
}
}
//Đăng nhập có validate login
public ActionResult Login(LoginViewModel model)
{
if (ModelState.IsValid)
{
var dao = new UserDao();
//gọi Login trong UserDao để xử lý tài khoản và mật khẩu
//Đồng thời mã hóa mật khẩu
var result = dao.Login(model.UserName, Encryptor.MD5Hash(model.Password));
//result == 1 đăng nhập đúng chuyển đến trang trủ
if (result == 1)
{
var user = dao.GetById(model.UserName);
var userSession = new UserLogin();
userSession.UserName = user.UserName;
userSession.UserID = user.ID;
//gán session
Session.Add(CommonConstants.USER_SESSION, userSession);
return(RedirectToAction("Index", "Home"));
}
else if (result == 0)
{
ModelState.AddModelError("", "Tài khoản không tồn tại.");
}
else if (result == -2)
{
ModelState.AddModelError("", "Tài khoản đang bị khóa.");
}
else if (result == -1)
{
ModelState.AddModelError("", "Mật khẩu không đúng.");
}
else
{
ModelState.AddModelError("", "Đăng nhập không đúng.");
}
}
return(View("Index"));
}
protected void GestioneGrafica()
{
this.btnApriRubrica.Attributes.Add("onmouseover", "this.src='../../images/proto/rubrica_hover.gif'");
this.btnApriRubrica.Attributes.Add("onmouseout", "this.src='../../images/proto/rubrica.gif'");
this.btnApriRubrica.OnClientClick = String.Format("_ApriRubricaRicercaRuoliSottoposti();");
this.btn_img_doc.Attributes.Add("onmouseover", "this.src='../Images/icon_admin_up.gif'");
this.btn_img_doc.Attributes.Add("onmouseout", "this.src='../Images/icon_admin.gif'");
this.btn_img_doc.OnClientClick = String.Format("OpenDocumentFormat();");
this.lblA.Visible = false;
this.lbl_dataCreazioneA.Visible = false;
this.lblAP.Visible = false;
this.lbl_dataCreazioneAP.Visible = false;
DocsPaWR.Utente ut = new SAAdminTool.DocsPaWR.Utente();
string[] amministrazione = ((string)Session["AMMDATASET"]).Split('@');
string codiceAmministrazione = amministrazione[0];
string idAmministrazione = IdAmministrazione.ToString();
ut.codiceAmm = codiceAmministrazione;
ut.idAmministrazione = idAmministrazione;
ut.tipoIE = "I";
Session.Add("userData", ut);
DocsPaWR.Ruolo rl = new SAAdminTool.DocsPaWR.Ruolo();
rl.codiceAmm = codiceAmministrazione;
rl.idAmministrazione = idAmministrazione;
rl.tipoIE = "I";
rl.systemId = idAmministrazione;
rl.uo = new SAAdminTool.DocsPaWR.UnitaOrganizzativa();
rl.uo.codiceRubrica = codiceAmministrazione;
Session.Add("userRuolo", rl);
DocsPaWR.Registro reg = new SAAdminTool.DocsPaWR.Registro();
reg.codAmministrazione = codiceAmministrazione;
reg.idAmministrazione = idAmministrazione;
Session.Add("userRegistro", reg);
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
var dao = new UserDao();
var result = dao.Login(model.UserName, model.Password);
if (result == 1)
{
var user = dao.GetById(model.UserName);
var userSession = new UserLogin();
userSession.UserName = user.UserName;
userSession.UserID = user.ID;
userSession.Password = user.Password;
userSession.Email = user.Email;
userSession.Address = user.Address;
userSession.Phone = user.Phone;
Session.Add(CommonConstants.USER_SESSION, userSession);
return(RedirectToAction("Index", "HomeAdmin"));
}
else if (result == 0)
{
ModelState.AddModelError("", "Tài khoản không tồn tại.");
}
else if (result == -1)
{
ModelState.AddModelError("", "Tài khoản đang bị khoá.");
}
else if (result == -2)
{
ModelState.AddModelError("", "Mật khẩu không đúng.");
}
else
{
ModelState.AddModelError("", "đăng nhập không đúng.");
}
}
return(View("Index"));
}
public ActionResult Login(MyViewModel model)
{
var mode = model.Login;
if (ModelState.IsValid)
{
var dao = new UserDAO();
var result = dao.Login(mode.UserName, Encrytor.MD5Hash(mode.PassWord));
if (result == 1)
{
var us = dao.GetByID(mode.UserName);
var usSession = new UserLogin();
usSession.UserName = us.displayname;
usSession.UserID = us.id;
usSession.UserEmail = us.email;
usSession.UserPhone = us.phone;
usSession.UserAddress = us.address;
usSession.UserImage = us.thunbar;
Session.Add(CommonConstants.USER_SESSION, usSession);
return(RedirectToAction("Index", "HomeClient"));
}
else if (result == 0)
{
ModelState.AddModelError("", "Tài khoản không tồn tại !!!");
}
else if (result == -1)
{
ModelState.AddModelError("", "Sai mật khẩu. Vui lòng nhập lại !!!");
}
else
{
ModelState.AddModelError("", "Đăng nhập không thành công !!!");
}
}
return(View("Index"));
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
var dao = new AccountDao();
string res = dao.Login(model.UserName, Encryptor.MD5Hash(model.PassWord));
if (res == "ok")
{
var acc = dao.getByUserName(model.UserName);
var accSession = new AccountLogin();
accSession.UserName = acc.user_name;
accSession.accID = acc.acc_ID;
Session.Add(CommonConst.USER_SESSION, accSession);
return(RedirectToAction("Index", "Home"));
}
else
if (res == "wrong-pass")
{
ModelState.AddModelError("", "Mật khẩu sai!");
}
else
if (res == "blocked")
{
ModelState.AddModelError("", "Tài khoản bị khóa!");
}
else
if (res == "not-allowed")
{
ModelState.AddModelError("", "Truy cập bị từ chối!");
}
else
if (res == "user-404")
{
ModelState.AddModelError("", "Tài khoản không tồn tại!");
}
}
return(View("Index"));
}
private void cercaModelliSelezionati()
{
string[] amministrazione = ((string)Session["AMMDATASET"]).Split('@');
string codiceAmministrazione = amministrazione[0];
idAmministrazione = Utils.getIdAmmByCod(codiceAmministrazione, this);
if (this.ddl_ricTipo.SelectedItem.Value.Equals("S"))
{
modelliTrasmissioneApp = new ArrayList(ModelliTrasmManager.getModelliAssDiagrammi(idTipoFasc, idDiagramma, idStato, idAmministrazione, true, "F", this));
}
else
{
modelliTrasmissioneApp = new ArrayList(ModelliTrasmManager.getModelliAssDiagrammi(idTipoFasc, idDiagramma, idStato, idAmministrazione, false, "F", this));
}
modelliTrasmissione = new ArrayList();
for (int i = 0; i < modelliTrasmissioneApp.Count; i++)
{
DocsPaWR.ModelloTrasmissione modello = (DocsPAWA.DocsPaWR.ModelloTrasmissione)modelliTrasmissioneApp[i];
if (modello.CHA_TIPO_OGGETTO == "F")
{
modelliTrasmissione.Add(modelliTrasmissioneApp[i]);
}
}
Session.Add("modelliTrasmissione", modelliTrasmissione);
modelliTrasmAssociati = new ArrayList(ProfilazioneFascManager.getIdModelliTrasmAssociatiFasc(idTipoFasc, idDiagramma, idStato, this));
Session.Add("modelliTrasmAssociati", modelliTrasmAssociati);
caricaDgModelliTrasm();
if (modelliTrasmAssociati.Count != 0)
{
impostaSelezioneModelliTrasmAssociati();
}
impostaAbilitazioneSelezioneModelli();
}
protected void LoginButton_Click(object sender, EventArgs e)
{
string username = UserTextBox.Text;
string password = PassTextBox.Text;
string checkUsername = utility.CheckUsername(username, "login");
string checkPassword = utility.CheckPassword(password, "login");
if (checkUsername == "OK" && checkPassword == "OK")
{
user = user.Login(username, password);
if (user != null)
{
DateTime lastLogIn = user.LastLoginDate;
user.LastLoginDate = DateTime.Now;
user.UpdateUser(user);
Session.Add("loggedInUser", user);
Session.Add("LastLogIn", lastLogIn);
User _user = (User)(Session["loggedInUser"]);
Response.Redirect("Boards.aspx");
}
}
else
{
if (count < 3)
{
UserLabel.Text = checkUsername;
PassLabel.Text = checkPassword;
count++;
}
else
{
Response.Redirect("Register.aspx");
}
}
}
protected void Buttoniniciar_Click(object sender, EventArgs e)
{
switch (DropDownListRol.SelectedValue)
{
case "1":
if (UsuarioLogeado != null)
{
WAlumnoVista.ValidarAlumno(1, UsuarioLogeado);
if (objLoggerinfAlumno != null)
{
Session.Add("AlumnoSesion", objLoggerinfAlumno); //Creamos la variable de sesion en donde la podremos utlizar cuando nos mande a la master
Response.Redirect("/Paginas/Alumno/Default.aspx", true); // no direcciona a la pagina default de la master
}
}
break;
case "3":
if (ObjSecretaria != null)
{
WSecreatriaVista.ValidarSecretaria(1, ObjSecretaria);
if (objLoggerinfSecretaria != null)
{
Session.Add("SecretariaSesion", objLoggerinfSecretaria); //Creamos la variable de sesion en donde la podremos utlizar cuando nos mande a la master
Response.Redirect("/Paginas/Secretaria/Default.aspx", true); // no direcciona a la pagina default de la master
}
}
else
{
//via jquey mensaje
}
break;
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//HttpCookie Session = Request.Cookies["BEPiDUCB.Site"];
//if (Session == null || Session["I"].ToString().Equals("0"))
//{
// Response.Redirect("Login");
//}
if (Session != null)
{
int idAluno = int.Parse(Request.Params["id"].ToString());
AlunoDTO dto = new AlunoDTO();
dto.idAluno = idAluno;
BEPiD.Business.BRL.AlunoBRL alunoBRL = new BEPiD.Business.BRL.AlunoBRL();
DataTable dtAluno = alunoBRL.searchDadosPrincipais(dto);
if (dtAluno != null && dtAluno.Rows.Count > 0)
{
Session.Add("Endereco", dtAluno.Rows[0]["endereco"].ToString());
Session.Add("Cidade", dtAluno.Rows[0]["cidade"].ToString());
Session.Add("Identidade", dtAluno.Rows[0]["Identidade"].ToString());
Session.Add("Orgao", dtAluno.Rows[0]["orgao"].ToString());
Session.Add("Nacionalidade", dtAluno.Rows[0]["Nacionalidade"].ToString());
Session.Add("EstadoCivil", dtAluno.Rows[0]["EstadoCivil"].ToString());
Session.Add("Curso", dtAluno.Rows[0]["Curso"].ToString());
Session.Add("NomeUniversidade", dtAluno.Rows[0]["NomeUniversidade"].ToString());
Session.Add("N", dtAluno.Rows[0]["Nome"].ToString());
Session.Add("C", dtAluno.Rows[0]["CPF"].ToString());
gerarWord(sender, e);
}
}
}
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
var dao = new UserDao();
var result = dao.Login(model.UserName, Encryptor.MD5Hash(model.PassWord), true);
if (result == 1)
{
var user = dao.GetByID(model.UserName);
var userSession = new UserLogin();
userSession.UserName = user.UserName;
userSession.UserID = user.ID;
Session.Add(CommonConstant.ADMIN_SESSION, userSession);
return(RedirectToAction("Index", "Home"));
}
else if (result == 0)
{
ModelState.AddModelError("", "Tài khoản không tồn tại");
}
else if (result == -1)
{
ModelState.AddModelError("", "Tài khoản đang bị khóa");
}
else if (result == -2)
{
ModelState.AddModelError("", "Mật khẩu không đúng");
}
else if (result == -3)
{
ModelState.AddModelError("", "Tài khoản của bạn không có quyền đăng nhập.");
}
else
{
ModelState.AddModelError("", "Đăng nhập không đúng");
}
}
return(View("Index"));
}
protected void Page_Load(object sender, EventArgs e)
{
Session.Clear();
Session.Add("User", "kabambora");
userName = Session["User"].ToString();
using (ScheduleEntities dbcon = new ScheduleEntities())
{
var userToRole =
(from x in dbcon.UserTables
where x.UserName == userName
select x.UserRole).First();
if (userToRole == "Student")
{
isStudent = true;
var studentNameToId =
(from stu in dbcon.StudentTables
where stu.StudentUserName == userName
select stu).First();
Session.Add("StdID", studentNameToId.StudentID);
}
else
{
isStudent = false;
var advisorNameToId =
(from adv in dbcon.AdvisorTables
where adv.AdvisorUserName == userName
select adv).First();
Session.Add("AdvID", advisorNameToId.AdvisorID);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Test"].ToString());
try
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from laptech_register where username = @username and password = @password", con);
cmd.Parameters.Add("@username", SqlDbType.VarChar, 10).Value = txtLname.Text;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 10).Value = txtPwd.Text;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Session.Add("labtechid", dr["labtechid"]);
Session.Add("name", dr["name"]);
dr.Close();
Response.Redirect("lapteachHomePage.aspx");
}
else
{
MessageBox.Show("Invalid Login!");
dr.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("Error --> " + ex.Message);
}
finally
{
con.Close();
}
}
public ActionResult Buy()
{
string id = Request["txtID"];
string name = Request["txtName"];
float price = float.Parse(Request["txtPrice"]);
string description = Request["txtDescription"];
int quantity = int.Parse(Request["txtQuantity"]);
string image = Request["txtImage"];
ProductDTO p = new ProductDTO(id, name, price, description, image);
CartItem c = (CartItem)Session["CART"];
if (c == null)
{
c = new CartItem();
c.AddToCart(p, quantity);
Session.Add("CART", c);
}
else
{
c.AddToCart(p, quantity);
}
//
if (TempData["PreviousPage"] != null)
{
if ((int)TempData["PreviousPage"] == 1)
{
return(RedirectToAction("SearchRandom"));
}
else if ((int)TempData["PreviousPage"] == 2)
{
return(RedirectToAction("ViewCart"));
}
}
return(RedirectToAction("SearchProduct"));
}
protected void btn_login_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["itiuser"].ConnectionString);
SqlCommand cmd = new SqlCommand("select dept_Id from users where user_Name=@name and user_Pass=@pass", con);
cmd.Parameters.AddWithValue("name", txt_name.Text);
cmd.Parameters.AddWithValue("pass", txt_password.Text);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Session.Add("Dept_Id", dr["dept_Id"]);
if (chb_remeberme.Checked)
{
//define obj
HttpCookie co = new HttpCookie("user");
//add values
co.Values.Add("dept_Id", dr["dept_Id"].ToString());
co.Expires = DateTime.Now.AddDays(15);
Response.Cookies.Add(co);
}
Response.Redirect("~/profile.aspx");
}
else
{
lbl_failed.Text = "invalid username or password";
}
con.Close();
}
private bool AuthenticateUser(string username, string password)
{
lblLoginError.Text = "";
bool isUser = false;
using (UniversalEntities entity = new UniversalEntities())
{
User user = (from i in entity.Users
where i.Username == username
select i).FirstOrDefault();
if (user == null)
{
isUser = false;
lblLoginError.Text = "User not found in database";
}
else if (user.Password == "" || user.Password == null)
{
isUser = false;
lblLoginError.Text = "No password saved in the database. Please register as a user.";
}
else if (user.Password != password)
{
isUser = false;
lblLoginError.Text = "Password Incorrect";
}
else if (!user.IsCompCare.HasValue || !user.IsCompCare.Value)
{
isUser = false;
lblLoginError.Text = "You are not a CompCare member and may not access this website";
}
else
{
isUser = true;
Session.Add("IdMember", user.IdMember);
}
}
return(isUser);
}
public ActionResult Password(FormCollection formCollection, int id, string shortName)
{
// Get question from database.
var question = Current.DB.Questions.Get(id);
if (question == null)
{
return(NotFound());
}
ViewBag.ID = id;
ViewBag.ShortName = shortName;
var password = formCollection["Password"];
if (!password.HasValue())
{
this.ModelState.AddModelError("Password", "Incorrect password. Try again.");
return(View());
}
password = Encryption.ComputerHash(password, new SHA256CryptoServiceProvider(), Encoding.UTF8.GetBytes(CANNED_SALT));
if (password != question.Password)
{
this.ModelState.AddModelError("Password", "Incorrect password. Try again.");
return(View());
}
string passwordKey = "Question:" + id;
// Add password to session.
Session.Add(passwordKey, password);
return(RedirectToAction("view", new { id = id, shortName = shortName }));
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
var dao = new UserDao();
var res = dao.Login(model.UserName, MaHoaMd5.MD5Hash(model.PassWord));
if (res == 1)
{
var user = dao.GetByID(model.UserName);
var userSession = new UserLogin();
userSession.UserName = model.UserName;
userSession.UserID = user.ID;
Session.Add(CommonConstants.USER_SESSION, userSession);
return(RedirectToAction("Index", "Home"));
}
else if (res == 0)
{
ModelState.AddModelError("", "Tài khoản không tồn tại.");
}
else if (res == -1)
{
ModelState.AddModelError("", "Tài khoản đang bị khóa.");
}
else if (res == -2)
{
ModelState.AddModelError("", "Mật khẩu không đúng.");
}
else
{
ModelState.AddModelError("", "Đăng nhập không đúng.");
}
}
return(View("index"));
}
private void SignIn(User user, int OrganizationId, bool isPersistent, HttpCookieCollection cookiecollection)
{
var Organization = new OrganizationRepository().GetOrganization(OrganizationId);
Session.Add("OrganizationName", Organization.OrganizationName);
var userData = String.Format("{0}|{1}|{2}|{3}|{4}|{5}",
user.UserId, user.UserName, user.UserPassword, user.UserEmail, "0", OrganizationId);
var ticket = new FormsAuthenticationTicket(1, userData, DateTime.UtcNow, DateTime.UtcNow.AddMinutes(360), isPersistent, userData, FormsAuthentication.FormsCookiePath);
var encryptedTicket = FormsAuthentication.Encrypt(ticket);
var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket)
{
HttpOnly = true
};
cookiecollection.Add(authCookie);
HttpCookie userCookie = new HttpCookie("userCookie")
{
HttpOnly = true
};
userCookie.Values.Add("UserId", user.UserId.ToString());
userCookie.Values.Add("UserName", user.UserName.ToString());
userCookie.Values.Add("publicKey", ConvertPasswordToPublicKey(user.UserPassword));
userCookie.Values.Add("UserEmail", user.UserEmail.ToString());
userCookie.Values.Add("UserRole", "0");
userCookie.Values.Add("Organization", OrganizationId.ToString());
cookiecollection.Add(userCookie);
Session.Add("user", userCookie);
Session.Timeout = 360;
UserRepository repo = new UserRepository();
string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
repo.InsertLoginHistory(user, Session.SessionID.ToString(), ip, OrganizationId.ToString());
//return userCookie;
}
public ActionResult Checkout()
{
List <Souvenir> ShoppingBag; // reference to null
if (Session["Cart"] == null) // the cart is empty!
{
Session.Add("Cart", new List <Souvenir>());
ShoppingBag = new List <Souvenir>();
}
else// user has items in the cart, so go and retrive it!
{
ShoppingBag = (List <Souvenir>)Session["Cart"];
}
///////////////////////////
double stotal = 0;
for (int i = 0; i < ShoppingBag.Count; i++)
{
stotal = stotal + double.Parse(ShoppingBag[i].Price);
// gtotal = stotal * Quantity;
}
ViewBag.gtotal = stotal;
// Session["GrandTotal"] = gtotal;
return(View());
}
public ActionResult Login(User user)
{
bool loginCheck = false;
User userDetails;
try { userDetails = db.Users.First(u => u.Username == user.Username); }
catch (Exception ex) {
return(RedirectToAction("login", "user"));
}
foreach (var userlist in db.Users)
{
if (userlist.Username.Equals(user.Username) && userlist.Password.Equals(user.Password))
{
loginCheck = true;
break;
}
}
Session.Add("login", loginCheck);
try
{
Session.Add("ID", userDetails.User_id);
if ((bool)Session["login"] == true)
{
Session.Add("Username", user.Username);
if (userDetails.PermissionLEvel == 1)
{
Session.Add("isAdmin", true);
}
return(RedirectToAction("index", "home"));
}
return(RedirectToAction("index", "home"));
}
catch
{
return(RedirectToAction("index", "home"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Limpa Cache
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetExpires(DateTime.Now);
Response.Cache.SetNoServerCaching();
Response.Cache.SetNoStore();
//Fim Limpa Cache
if ((String)Session["IdSessao"] == null)
{
Session.Add("fimdesessao", "A Sessão foi expirada, reinicie o sistema!");
Response.Redirect("~\\LoginTimeOut.aspx");
}
if (!Page.IsPostBack)
{
//Combo Produto
cbproduto.Items.Clear();
uProduto.MontaComboProduto(cbproduto, true);
//
}
}
//Validar login
public ActionResult Logar(string email, string senha)
{
try
{
using (var context = new Context())
{
var SQL = context.Conta
.Where(c => c.email == email && c.senha == senha).First();
Session.Timeout = 20;
Session.Add("id", SQL.contaId);
Session.Add("nome", SQL.nome);
Session.Add("email", SQL.email);
return(RedirectToAction($"Details/{SQL.contaId}"));
}
}
catch
{
return(new HttpStatusCodeResult(HttpStatusCode.Unauthorized));
}
}
public ActionResult ConfirmOrReject(string id, bool isReject = false, bool isConfirm = false)
{
if (string.IsNullOrEmpty(id))
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User user = db.Users.Find(id);
if (isConfirm)
{
user.Confirmed = true;
user.Rejected = false; //anaa kudaray markan confirm baroobe kadib
user.Blocked = false; //anaa kudaray markan confirm baroobe kadib
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
else if (isReject)
{
Session.Add("rejectedUserId", id);
return(View("ConfirmReject", user));
}
return(RedirectToAction("Index"));
}
protected void Page_Load(object sender, EventArgs e)
{
this.Page.MaintainScrollPositionOnPostBack = true;
string idOggetto = Request.QueryString["IdOggCustom"];
if (!string.IsNullOrEmpty(idOggetto))
{
this.idOggettoCustom = idOggetto;
}
template = (SAAdminTool.DocsPaWR.Templates)Session["template"];
lbl_titolo.Text = "Abilitazione incremento differito";
if (!IsPostBack)
{
Session.Add("reloadHTFasc", false);
this.Inizialize();
}
else
{
impostaSelezione();
}
}
public ActionResult RequestLogin(RequestLogin requestLogin)
{
Account account = accountRepository.GetAccountByUsernameAndPassword(requestLogin.Username, requestLogin.Password);
if (account != null && account.IsActive == false)
{
return(Json(new ResponseResult(403, "Tài khoản hiện đang bị khóa", null)));
}
else if (account == null)
{
return(Json(new ResponseResult(403, "Sai tên truy cập hoặc mật khẩu", null)));
}
Session.Add(CommonConstants.USER_SESSION, account);
var accountJson = JsonConvert.SerializeObject(account,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(Json(new ResponseResult(200, "success", accountJson), JsonRequestBehavior.AllowGet));
}
protected void dgvMarca_RowCommand(object sender, GridViewCommandEventArgs e)
{
ListaMarcas = negocio.listarMarcas();
int index = Convert.ToInt32(e.CommandArgument);
string IDSeleccionado = dgvMarca.Rows[index].Cells[0].Text;
int idSeleccionado = Convert.ToInt32(IDSeleccionado);
Marca aux = ListaMarcas.Find(A => A.Id == idSeleccionado);
if (ListaMarcas != null)
{
if (e.CommandName == "Select2")
{
Session.Add(Session.SessionID + "Marca", aux);
Response.Redirect("ModificarMarca.aspx");
}
if (e.CommandName == "Select")
{
negocio.eliminarMarca(aux.Id);
Response.Redirect("ListaMarca.aspx");
}
}
}
