private bool IsValid(EducationalBackground obj, Result <EducationalBackground> result)
{
if (!ValidationHelper.IsStringValid(obj.School))
{
result.HasError = true;
result.Message = "Invalid School";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.Collage))
{
result.HasError = true;
result.Message = "Invalid Collage";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.UniversityPost))
{
result.HasError = true;
result.Message = "Invalid UniversityPost";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.UniversityUnder))
{
result.HasError = true;
result.Message = "Invalid UniversityUnder";
return(false);
}
return(true);
}
public Result <EducationalBackground> Save(EducationalBackground userinfo)
{
var result = new Result <EducationalBackground>();
try
{
var objtosave = DbContext.EducationalBackgrounds.FirstOrDefault(u => u.UserId == userinfo.UserId);
if (objtosave == null)
{
objtosave = new EducationalBackground();
DbContext.EducationalBackgrounds.Add(objtosave);
}
objtosave.School = userinfo.School;
objtosave.Collage = userinfo.Collage;
objtosave.UniversityPost = userinfo.UniversityPost;
objtosave.UniversityUnder = userinfo.UniversityUnder;
objtosave.Others = userinfo.Others;
if (!IsValid(objtosave, result))
{
return(result);
}
DbContext.SaveChanges();
}
catch (Exception ex)
{
result.HasError = true;
result.Message = ex.Message;
}
return(result);
}
public Result <EducationalBackground> Save(EducationalBackground EducationalBackground)
{
var result = new Result <EducationalBackground>();
try
{
string query = "select * from EducationalBackground where UserId=" + EducationalBackground.UserId;
var dt = DataAccess.GetDataTable(query);
if (dt == null || dt.Rows.Count == 0)
{
EducationalBackground.UserId = CurrentUser.User.UserId;
query = "insert into EducationalBackground values(" + EducationalBackground.UserId + ",'" + EducationalBackground.School + "','" + EducationalBackground.Collage + "','" + EducationalBackground.UniversityPost + "','" + EducationalBackground.UniversityUnder + "','" + EducationalBackground.Others + "')";
}
else
{
query = "update EducationalBackground set School='" + EducationalBackground.School + "',Collage='" + EducationalBackground.Collage + "',UniversityPost='" + EducationalBackground.UniversityPost + "',UniversityUnder='" + EducationalBackground.UniversityUnder + "',Others='" + EducationalBackground.Others + "' where UserId=" + EducationalBackground.UserId;
}
//if (!IsValid(EducationalBackground, result))
//{
// return result;
//}
result.HasError = DataAccess.ExecuteQuery(query) <= 0;
if (result.HasError)
{
result.Message = "Something Went Wrong";
}
else
{
result.Data = EducationalBackground;
}
}
catch (Exception ex)
{
result.HasError = true;
result.Message = ex.Message;
}
return(result);
}
//private bool IsValid(EducationalBackground obj, Result<EducationalBackground> result)
//{
// if (!ValidationHelper.IsStringValid(obj.School))
// {
// result.HasError = true;
// result.Message = "Invalid School Name";
// return false;
// }
// if (!ValidationHelper.IsStringValid(obj.Collage))
// {
// result.HasError = true;
// result.Message = "Invalid Collage Name";
// return false;
// }
// if (!ValidationHelper.IsStringValid(obj.UniversityPost))
// {
// result.HasError = true;
// result.Message = "Invalid University Name";
// return false;
// }
// if (!ValidationHelper.IsStringValid(obj.UniversityUnder))
// {
// result.HasError = true;
// result.Message = "Invalid University Name";
// return false;
// }
// return true;
//}
private EducationalBackground ConvertToEntity(DataRow row)
{
try
{
EducationalBackground u = new EducationalBackground();
u.UserId = Int32.Parse(row["UserId"].ToString());
u.School = row["School"].ToString();
u.Collage = row["Collage"].ToString();
u.UniversityPost = row["UniversityPost"].ToString();
u.UniversityUnder = row["UniversityUnder"].ToString();
u.Others = row["Others"].ToString();
return(u);
}
catch (Exception)
{
return(null);
}
}
//private int GetID()
//{
// string query = "select * from EducationalBackground order by UserId desc";
// var dt = DataAccess.GetDataTable(query);
// int id = 1;
// if (dt != null && dt.Rows.Count != 0)
// id = Int32.Parse(dt.Rows[0]["ID"].ToString()) + 1;
// return id;
//}
public List <EducationalBackground> GetAll()
{
var result = new List <EducationalBackground>();
try
{
string query = "select * from EducationalBackground";
var dt = DataAccess.GetDataTable(query);
if (dt != null && dt.Rows.Count != 0)
{
for (int i = 0; i <= dt.Rows.Count; i++)
{
EducationalBackground u = ConvertToEntity(dt.Rows[i]);
result.Add(u);
}
}
}
catch (Exception ex)
{
return(result);
}
return(result);
}
