protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
binddata();
}
var DC = new DataClassesDataContext();
var str = (from ob in DC.tblAdmins
join obj in DC.tblImages
on ob.ImageID equals obj.ImagesID
where ob.AdminID == Convert.ToInt32(Session["AdminID"])
select new
{
obj.Name,
UName = ob.FirstName + " " + ob.LastName
}).SingleOrDefault();
DC.SubmitChanges();
imgUserPic.ImageUrl = "~/Admin/Upload/" + str.Name;
lblUserName.Text = str.UName.ToString();
tblAdmin result = (from u in DC.tblAdmins
where u.AdminID == Convert.ToInt32(Session["AdminID"])
select u).Single();
if (result.IsSuper == false)
{
//Panel1.Visible = false;
lnkAdView.Visible = false;
}
var dc = new DataClassesDataContext();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["AdminID"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
BindData();
}
var DC = new DataClassesDataContext();
tblAdmin AdminData = DC.tblAdmins.Single(ob => ob.AdminID == Convert.ToInt32(Session["AdminID"]));
if (AdminData.IsInsert == false)
{
divPage.Visible = false;
divError.Visible = true;
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public IHttpActionResult PuttblAdmin(int id, tblAdmin tblAdmin)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblAdmin.AdminID)
{
return(BadRequest());
}
db.Entry(tblAdmin).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblAdminExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected void Page_Load(object sender, EventArgs e)
{
try {
if (Session["AdminID"] == null)
{
Response.Redirect("Adlogin.aspx");
}
var DC = new DataClassesDataContext();
if (!IsPostBack)
{
BindData();
BindData1();
}
tblAdmin result = (from u in DC.tblAdmins
where u.AdminID == Convert.ToInt32(Session["AdminID"])
select u).Single();
if (result.IsSuper == false)
{
rptrefrd.Visible = false;
rptservice.Visible = false;
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try {
if (Session["AdminID"] == null)
{
Response.Redirect("Adlogin.aspx");
}
var DC = new DataClassesDataContext();
tblAdmin AdminData = DC.tblAdmins.Single(ob => ob.AdminID == Convert.ToInt32(Session["AdminID"]));
if (AdminData.IsUpdate == false || AdminData.IsInsert == false)
{
divPage.Visible = false;
divError.Visible = true;
}
if (!IsPostBack)
{
var strCMSFillDD = from obj in DC.tblCMs where obj.IsActive == true select obj;
ddCMSList.DataSource = strCMSFillDD;
ddCMSList.DataValueField = "CMSID";
ddCMSList.DataTextField = "Title";
ddCMSList.DataBind();
ddCMSList.Items.Insert(0, new ListItem("Select CMS Page", ""));
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void BtnSubmit_OnClick(object Source, EventArgs e)
{
if (CurrentMember != null)
{
Response.Redirect("admin/default.aspx");
}
tblAdmin memberList = tblAdmin.loginCheck(txtUsername.Text, txtPass.Text);
if (memberList == null)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<script language=\"javascript\">");
sb.Append("document.getElementById(\"errMsgHtml\").className=\"error-msg-show\";");
sb.Append("</script>");
Page.ClientScript.RegisterStartupScript(this.GetType(), "MyScript", sb.ToString());
}
else
{
Session["tblUser"] = memberList;
if (Session["UrlReferrer"] == null)
{
Response.Redirect("admin/default.aspx");
}
}
}
// Method that add Admin to database
public void AddAdmin(vwAdmin admin)
{
try
{
using (CompanyDBEntities context = new CompanyDBEntities())
{
tblUser newUser = new tblUser();
tblAdmin newAdmin = new tblAdmin();
newUser.FirstName = admin.FirstName;
newUser.LastName = admin.LastName;
newUser.JMBG = admin.JMBG;
newUser.Gender = admin.Gender;
newUser.Residence = admin.Residence;
newUser.MarriageStatus = admin.MarriageStatus;
newUser.Username = admin.Username;
newUser.UserPassword = SecurePasswordHasher.Hash(admin.UserPassword);
context.tblUsers.Add(newUser);
context.SaveChanges();
admin.UserID = newUser.UserID;
newAdmin.UserID = admin.UserID;
newAdmin.ExpirationDate = DateTime.Now.AddDays(7);
newAdmin.AdminType = admin.AdminType;
context.tblAdmins.Add(newAdmin);
context.SaveChanges();
admin.AdminID = newAdmin.AdminID;
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
private void BtnLogin_Click(object sender, EventArgs e)
{
LogAdminBLL logAdminBLL = new LogAdminBLL();
tblAdmin admin = new tblAdmin();
admin.Username = txtUserName.Text;
admin.Password = txtPassword.Text;
if (logAdminBLL.getLogin(admin).HasRows)
{
tblLogTrail log = new tblLogTrail();
LogTrailBLL bll = new LogTrailBLL();
log.Dater = lblDateTime.Text;
log.Descrip = "User: "******" has successfully Logged In!";
log.Authority = "Admin";
bll.Insert(log);
frmStart frmStart = (frmStart)Application.OpenForms["frmStart"];
frmStart.Hide();
frmAdminMenu frmAdminMenu = new frmAdminMenu();
frmAdminMenu.Show();
this.Hide();
}
else
{
DialogResult = MessageBox.Show("Không được phép truy cập! ", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
public async Task <IActionResult> Edit(int id, [Bind("AdminId,Name,ExamDate,MarksSubmitDate,ResultPublishDate")] tblAdmin tblAdmin)
{
if (id != tblAdmin.AdminId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tblAdmin);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tblAdminExists(tblAdmin.AdminId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tblAdmin));
}
public HttpResponseMessage PostLogin(string username, string Password_)
{
bool Exists = false;
tblAdmin admin = new tblAdmin();
List <tblAdmin> admins = db.tblAdmins.ToList();
foreach (var item in admins)
{
if (item.username == username)
{
Exists = true;
admin = item;
break;
}
}
if (Exists)
{
if (admin.Password_ == Password_)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "Wrong Password"));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "Invalid User"));
}
}
private void BindAppraisal()
{
try
{
var DC = new DataClassesDataContext();
tblAdmin AdminData = DC.tblAdmins.Single(ob => ob.AdminID == Convert.ToInt32(Session["AdminID"]));
if (AdminData.IsInsert == false)
{
btnGenerate.Visible = false;
}
IQueryable <tblEmpAppraisal> Appraisal = (from ob in DC.tblEmpAppraisals
select ob);
rptViewAppraisal.DataSource = Appraisal;
rptViewAppraisal.DataBind();
foreach (RepeaterItem item in rptViewAppraisal.Items)
{
HiddenField hdnEmpID = (HiddenField)item.FindControl("hdnEmpID");
Literal ltrEmpName = (Literal)item.FindControl("ltrEmpName");
tblEmployee EmpID = (from obj in DC.tblEmployees
where obj.EmpID == Convert.ToInt32(hdnEmpID.Value)
select obj).Single();
ltrEmpName.Text = EmpID.FirstName + " " + EmpID.LastName;
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public IHttpActionResult PosttblAdmin(tblAdmin tblAdmin)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblAdmins.Add(tblAdmin);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (tblAdminExists(tblAdmin.AdminID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = tblAdmin.AdminID }, tblAdmin));
}
public ActionResult Index(string txtEmail, string txtPwd)
{
tblAdmin ad = (from ob in dc.tblAdmins where ob.EmailId == txtEmail && ob.Password == txtPwd && ob.IsActive == true select ob).Take(1).SingleOrDefault();
if (ad != null)
{
//parul
Session["loginId"] = ad.Name;
Session["LogID"] = ad.AdminId;
if (ad.IsSuper == true)
{
Session["AdminType"] = "Super";
Session["Insert"] = ad.IsInsert;
Session["Edit"] = ad.IsEdit;
Session["Delete"] = ad.IsDelete;
return(RedirectToAction("Dashboard", "Admin"));
}
else
{
//Session["AdminType"] = "Sub";
Session["Insert"] = ad.IsInsert;
Session["Edit"] = ad.IsEdit;
Session["Delete"] = ad.IsDelete;
return(RedirectToAction("Dashboard", "Admin"));
}
}
else
{
ViewBag.message = "*Inavalid email or password";
return(View());
//return RedirectToAction("Dashboard", "Admin");
}
}
public ActionResult Edit(int id)
{
TempData["id"] = id;
tblAdmin ad = dc.tblAdmins.SingleOrDefault(ob => ob.AdminId == id);
return(View(ad));
}
private void SaveExecute()
{
try
{
using (CompanyDBEntities db = new CompanyDBEntities())
{
tblUser user = db.tblUsers.Where(u => u.UserID == Admin.UserID).FirstOrDefault();
user.FirstName = Admin.FirstName;
user.LastName = Admin.LastName;
user.JMBG = Admin.JMBG;
user.Gender = Gender.ToString();
user.Residence = Admin.Residence;
user.MarriageStatus = Status;
user.Username = Admin.Username;
user.UserPassword = Admin.UserPassword;
tblAdmin admin = db.tblAdmins.Where(a => a.AdminID == Admin.AdminID).FirstOrDefault();
admin.ExpirationDate = Admin.ExpirationDate;
admin.AdminType = Type;
db.SaveChanges();
}
MessageBox.Show("Admin Updated Successfully!");
main.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
protected void btnChPwd_Click(object sender, EventArgs e)
{
try {
if ((txtPwd.Text) == (txtRPwd.Text))
{
var DC = new DataClassesDataContext();
int ID = Convert.ToInt32(Session["AdminID"]);
int count = (from u in DC.tblAdmins
where u.AdminID == ID && u.Password == Encryptdata(txtCPwd.Text)
select u).Count();
if (count > 0)
{
tblAdmin result1 = (from u in DC.tblAdmins
where u.AdminID == ID && u.Password == Encryptdata(txtCPwd.Text)
select u).Single();
result1.Password = (Encryptdata(txtPwd.Text));
DC.SubmitChanges();
Response.Redirect("empgrid.aspx");
}
else
{
pnlError.Visible = true;
}
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public ActionResult YeniAdmin(tblAdmin a)
{
db.tblAdmin.Add(a);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id)
{
tblAdmin ad = dc.tblAdmins.SingleOrDefault(ob => ob.AdminId == id);
dc.tblAdmins.Remove(ad);
dc.SaveChanges();
return(RedirectToAction("List", "Admin"));
}
public IList <string> GetAdminDetail(int AdminID)
{
var DC = new DataClassesDataContext();
tblAdmin Data = DC.tblAdmins.SingleOrDefault(ob => ob.AdminID == AdminID);
IList <string> list = new string[] { Data.FirstName, Data.LastName, Data.UserName, Data.EmailID, Data.ContactNo };
return(list);
}
//public string code()
//{
// string code = DateTime.Now.ToString("dd-mm-yyyy-HH-mm-ss-ff").Replace("-", "");
// return code;
//}
public ActionResult Detail(int id)
{
tblAdmin ad = dc.tblAdmins.SingleOrDefault(ob => ob.AdminId == id);
//ViewBag.AdminName = (from ob in dc.tblAdmins where ob.AdminId == ad.CreatedBy select ob).Take(1).SingleOrDefault().Name;
//string name = ViewBag.AdminName;
return(View(ad));
}
public CreateAdminViewModel(CreateAdminView mainOpen)
{
main = mainOpen;
User = new tblUser();
Admin = new tblAdmin();
Genders = GetAllGenders();
MarriageStatuses = GetMariageStatuses();
AdminTypes = GetAdminTypes();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["AdminID"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
BindData();
}
var DC = new DataClassesDataContext();
tblAdmin AdminData = DC.tblAdmins.Single(ob => ob.AdminID == Convert.ToInt32(Session["AdminID"]));
if (AdminData.IsUpdate == false)
{
foreach (RepeaterItem item in rptViewAdmin.Items)
{
PlaceHolder Update = (PlaceHolder)item.FindControl("PlaceHolderUpdate");
Update.Visible = false;
}
PlaceHolderUpdateHeader.Visible = false;
}
if (AdminData.IsDelete == false)
{
foreach (RepeaterItem item in rptViewAdmin.Items)
{
PlaceHolder Delete = (PlaceHolder)item.FindControl("PlaceHolderDelete");
Delete.Visible = false;
}
PlaceHolderDeleteHeader.Visible = false;
}
if (AdminObject.ResSubAdmin(Convert.ToInt32(Session["AdminID"])) == false)
{
rptViewAdmin.Visible = false;
divPage.Visible = false;
divError.Visible = true;
}
else
{
divPage.Visible = true;
divError.Visible = false;
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public ActionResult Edit([Bind(Include = "ID,KullaniciAd,Sifre")] tblAdmin tblAdmin)
{
if (ModelState.IsValid)
{
db.Entry(tblAdmin).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblAdmin));
}
public ActionResult ThemAd(tblAdmin ad)
{
if (ModelState.IsValid)
{
ad.created = DateTime.Now;
data.tblAdmins.InsertOnSubmit(ad);
data.SubmitChanges();
}
return(RedirectToAction("Index"));
}
private void BindData()
{
try {
var DC = new DataClassesDataContext();
var str = from obj in DC.tblPackages
//where obj.IsActive == true
select new
{
CBy = (from ob in DC.tblAdmins
where ob.AdminID == obj.CreatedBy
select new
{
Data = ob.FirstName + " " + ob.LastName
}).Take(1).SingleOrDefault().Data,
img = (from obj1 in DC.tblImages
where obj1.ImagesID == obj.ImageID
select new
{
str1 = obj1.Name
}).Take(1).SingleOrDefault().str1,
obj.PackagesID,
obj.Name,
obj.Duration,
obj.Description,
cv = Convert.ToDouble(obj.Price),
obj.CreatedOn,
obj.IsActive
};
DC.SubmitChanges();
rptadmin.DataSource = str;
rptadmin.DataBind();
tblAdmin AdminData = DC.tblAdmins.Single(ob => ob.AdminID == Convert.ToInt32(Session["AdminID"]));
if (AdminData.IsUpdate == false)
{
foreach (RepeaterItem item in rptadmin.Items)
{
PlaceHolder PlaceHolderActive = (PlaceHolder)item.FindControl("PlaceHolderActive");
PlaceHolderActive.Visible = false;
}
PlaceHolderActiveHeader.Visible = false;
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public async Task <IActionResult> Create([Bind("AdminId,Name,ExamDate,MarksSubmitDate,ResultPublishDate")] tblAdmin tblAdmin)
{
if (ModelState.IsValid)
{
_context.Add(tblAdmin);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblAdmin));
}
public ActionResult ProfileAd()
{
tblAdmin ad = (tblAdmin)Session["TKadmin"];
if (ad == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(ad));
}
private void bindata()
{
try
{
var DC = new DataClassesDataContext();
var str = from obj in DC.tblAddresses
select new
{
data = (from ob in DC.tblClients
where ob.AddressID == obj.AddressID
select new
{
Da = ob.FirstName + " " + ob.LastName
}).Take(1).SingleOrDefault().Da,
city = (from obj1 in DC.CityMasters
where obj1.ID == obj.CityID
select new
{
Da1 = obj1.Name,
}).Take(1).SingleOrDefault().Da1,
obj.AddressID,
obj.Address,
obj.Area,
obj.CityID,
obj.IsActive,
obj.Landmark,
obj.PincodeNo,
};
DC.SubmitChanges();
rptCliadd.DataSource = str;
rptCliadd.DataBind();
tblAdmin AdminData = DC.tblAdmins.Single(ob => ob.AdminID == Convert.ToInt32(Session["AdminID"]));
if (AdminData.IsUpdate == false)
{
foreach (RepeaterItem item in rptCliadd.Items)
{
PlaceHolder PlaceHolderActive = (PlaceHolder)item.FindControl("PlaceHolderActive");
PlaceHolderActive.Visible = false;
}
PlaceHolderActiveHeader1.Visible = false;
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public ActionResult Edit(FormCollection form)
{
int id = Convert.ToInt32(TempData["id"]);
tblAdmin ad = dc.tblAdmins.SingleOrDefault(ob => ob.AdminId == id);
ad.Name = form["txtName"];
// ad.EmailId = form["txtEmail"];
ad.ContactNo = form["txtCno"];
// ad.ImageUrl = form["txtFile"];
dc.SaveChanges();
return(RedirectToAction("List"));
}
public IHttpActionResult PosttblAdmin(tblAdmin tblAdmin)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblAdmins.Add(tblAdmin);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblAdmin.adm_Id }, tblAdmin));
}
partial void DeletetblAdmin(tblAdmin instance);
partial void UpdatetblAdmin(tblAdmin instance);
partial void InserttblAdmin(tblAdmin instance);
