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);
}
