public static int EmailExist(String EmailID) { try { int result = 0; using (var ctx = new ExponentPortalEntities()) { var _objuserdetail = (from data in ctx.MSTR_User where data.EmailId == EmailID select data); result = _objuserdetail.Count(); } return result; } catch (Exception ex) { Util.ErrorHandler(ex); System.Web.HttpContext.Current.Response.Write("<script>alert('Please Check Database Connection');</script>"); return -1; } }
public bool isValidated(int ThisCheckListID, int DroneID) { String SQL; String sFieldValue; Decimal FieldValue = 0; bool Validated = true; SQL = "SELECT FieldValue, FieldNote FROM [DroneCheckListItem] WHERE\n" + " [DroneCheckListID] = " + ThisCheckListID + " AND\n" + " [DroneCheckListItemID] = " + ID; var Result = Util.getDBRow(SQL); sFieldValue = Result["FieldValue"].ToString(); this.FieldNote = Result["FieldNote"].ToString(); this.FieldValue = sFieldValue; try { FieldValue = Convert.ToDecimal(sFieldValue); } catch(Exception ex) { Util.ErrorHandler(ex); //error in parsing data. set to zero FieldValue = 0; } SQL = "SELECT MinValue, MaxValue FROM [DroneCheckListValidation] WHERE \n" + " [DroneID]= " + DroneID + " AND\n" + " [DroneCheckListID] = " + CheckListID + " AND\n" + " [DroneCheckListItemID] = " + ID; Result = Util.getDBRow(SQL); if ((bool)Result["hasRows"]) { Decimal MinValue = (Decimal)Result["MinValue"]; Decimal MaxValue = (Decimal)Result["MaxValue"]; if (MinValue > 0 && MaxValue > 0 && FieldValue >= MinValue && FieldValue <= MaxValue) { Validated = true; } else if (MinValue == 0 && MaxValue == 0) { Validated = true; } else { Validated = false; } } this.isValid = Validated; return Validated; }//function isValidated
public static int UserIsActive(String UserName, String Password) { try { string PasswordCrypto = Util.GetEncryptedPassword(Password); int result = 0; using (var ctx = new ExponentPortalEntities()) { var _objuserdetail = (from data in ctx.MSTR_User where (data.UserName == UserName && data.Password == PasswordCrypto) select data.IsActive).ToList(); if (_objuserdetail.Count > 0) { string isactive = _objuserdetail[0].ToString(); if (isactive == "True") { result = 1; } else { result = 0; } } else { result = 0; } } return result; } catch (Exception ex) { Util.ErrorHandler(ex); System.Web.HttpContext.Current.Response.Write("<script>alert('Please Check Database Connection');</script>"); return -1; } }
public static IList<MenuModel> BuildMenu() { IList<MenuModel> mmList = new List<MenuModel>(); try { var menu_items = db.MSTR_Menu; var UserId = System.Web.HttpContext.Current.Session["UserId"] == null ? 0 : System.Web.HttpContext.Current.Session["UserId"]; String SQL = "select * from MSTR_Menu where Visible=1 and MenuId" + " in(select b.MenuId from MSTR_Profile a left join M2M_ProfileMenu b" + " on a.ProfileId = b.ProfileId left join MSTR_User c on b.ProfileId = c.UserProfileId" + " where c.UserId =" + UserId + ") order by SortOrder asc "; var MenuName = db.Database.SqlQuery<MSTR_Menu>(SQL); foreach (MSTR_Menu mnu in MenuName) { MenuModel model = new MenuModel(); model.Id = mnu.MenuId; model.Name = mnu.MenuName; model.ParentId = mnu.ParentId.GetValueOrDefault(); model.SortOrder = mnu.SortOrder.GetValueOrDefault(); model.PageUrl = mnu.PageUrl; mmList.Add(model); if(mnu.MenuName == "Home") { AddCmsMenuTo(mmList, mnu.MenuId); } } } catch (Exception ex) { Util.ErrorHandler(ex); } return mmList; }