private Reg_User ConvertToEntity(DataRow row) { try { Reg_User rg = new Reg_User() { UserInfo = new UserInfo() }; rg.ID = Int32.Parse(row["ID"].ToString()); string dob = row["DOB"].ToString(); if (dob != "") { rg.DOB = Convert.ToDateTime(dob); } rg.Contact = row["Contact"].ToString(); rg.Profession = row["Profession"].ToString(); rg.Gender = row["Gender"].ToString(); rg.Address = row["Address"].ToString(); rg.RefID = -1; rg.UserInfo.ID = Int32.Parse(row["ID"].ToString()); rg.UserInfo.Name = row["UName"].ToString(); rg.UserInfo.Email = row["Email"].ToString(); rg.UserInfo.Password = row["Password"].ToString(); rg.UserInfo.UserTypeID = Int32.Parse(row["UserTypeID"].ToString()); rg.UserInfo.StatusID = Int32.Parse(row["StatusID"].ToString()); return(rg); } catch (Exception ex) { return(null); } }
public List <Reg_User> GetAll(string key) { var result = new List <Reg_User>(); try { //string query = "DECLARE CURSOR USERS_cur is select * from userinfo left outer join reg_user using (ID) WHERE ID NOT IN(1,2);USERS_rec USERS_cur%rowtype; BEGIN OPEN USERS_cur; LOOP FETCH USERS_cur into USERS_rec; EXIT WHEN USERS_cur%notfound; DBMS_OUTPUT.put_line(USERS_rec.id || ' ' || USERS_rec.Uname); END LOOP; END; "; string query = "select * from UserView"; if (ValidationHelper.IsStringValid(key)) { query += " where UName like '%" + key + "%' or Email like '%" + key + "%'"; } var dt = DataAccess.GetDataTable(query); if (dt != null && dt.Rows.Count != 0) { for (int i = 0; i < dt.Rows.Count; i++) { Reg_User u = ConvertToEntity(dt.Rows[i]); result.Add(u); } } } catch (Exception ex) { } return(result); }
public ActionResult EditProfile() { var model = new Reg_User() { ID = HttpUtil.UserProfile.ID, DOB = DateTime.Now }; return(View(model)); }
private bool IsValid(Reg_User value, Result <Reg_User> result) { if (!ValidationHelper.IsStringValid(value.Contact)) { result.HasError = true; result.Message = "Invalid Contact"; return(true); } if (!ValidationHelper.IsStringValid(value.Profession)) { result.HasError = true; result.Message = "Invalid Profession"; return(true); } return(true); }
public ActionResult EditProfile(Reg_User model) { if (!ModelState.IsValid) { return(View(model)); } var result = Reg_UserService.Save(model); if (result.HasError) { ViewBag.Message = result.Message; return(View(model)); } return(RedirectToAction("Profile")); }
public Result <Reg_User> Save(Reg_User value) { var result = new Result <Reg_User>(); try { string query = "select * from Reg_User where ID=" + value.ID; var dt = DataAccess.GetDataTable(query); if (dt == null || dt.Rows.Count == 0) { query = "insert into Reg_User values(" + value.ID + ",'" + value.Address + "','" + value.Contact + "','" + value.Profession + "',TO_DATE('" + value.DOB.ToString("yyyy/MM/dd") + "', 'yyyy/mm/dd'),'" + value.Gender + "',111)"; } else { result.HasError = true; result.Message = "Update not implemented yet"; return(result); } if (!IsValid(value, result)) { return(result); } result.HasError = DataAccess.ExecuteQuery(query) <= 0; if (result.HasError) { result.Message = "Something Went Wrong"; } else { result.Data = value; } } catch (Exception ex) { result.HasError = true; result.Message = ex.Message; } return(result); }