private bool IsValid(OwnerInfo obj, Result <OwnerInfo> result) { if (!ValidationHelper.IsStringValid(obj.CompanyName)) { result.HasError = true; result.Message = "Invalid CompanyName"; return(false); } if (!ValidationHelper.IsStringValid(obj.CompanyAddress)) { result.HasError = true; result.Message = "Invalid CompanyAddress"; return(false); } if (!ValidationHelper.IsStringValid(obj.CompanyCode)) { result.HasError = true; result.Message = "Invalid CompanyCode"; return(false); } if (!ValidationHelper.IsStringValid(obj.Position)) { result.HasError = true; result.Message = "Invalid Position"; return(false); } return(true); }
public Result <OwnerInfo> Save(OwnerInfo userinfo) { var result = new Result <OwnerInfo>(); try { var objtosave = DbContext.OwnerInfos.FirstOrDefault(u => u.UserId == userinfo.UserId); if (objtosave == null) { objtosave = new OwnerInfo(); DbContext.OwnerInfos.Add(objtosave); } objtosave.CompanyName = userinfo.CompanyName; objtosave.CompanyAddress = userinfo.CompanyAddress; objtosave.CompanyCode = userinfo.CompanyCode; objtosave.Position = userinfo.Position; if (!IsValid(objtosave, result)) { return(result); } DbContext.SaveChanges(); } catch (Exception ex) { result.HasError = true; result.Message = ex.Message; } return(result); }
private OwnerInfo ConvertToEntity(DataRow row) { try { OwnerInfo u = new OwnerInfo(); u.UserId = Int32.Parse(row["UserId"].ToString()); u.CompanyName = row["CompanyName"].ToString(); u.CompanyAddress = row["CompanyAddress"].ToString(); u.CompanyCode = row["CompanyCode"].ToString(); u.Position = row["Position"].ToString(); return(u); } catch (Exception) { return(null); } }
public Result <OwnerInfo> Save(OwnerInfo OwnerInfo) { var result = new Result <OwnerInfo>(); try { string query = "select * from OwnerInfo where UserId=" + OwnerInfo.UserId; var dt = DataAccess.GetDataTable(query); if (dt == null || dt.Rows.Count == 0) { // OwnerInfo.UserId = GetID(); query = "insert into OwnerInfo values(" + OwnerInfo.UserId + ",'" + OwnerInfo.CompanyName + "','" + OwnerInfo.CompanyAddress + "','" + OwnerInfo.CompanyCode + "','" + OwnerInfo.Position + "')"; } else { query = "update OwnerInfo set CompanyName='" + OwnerInfo.CompanyName + "',CompanyCode='" + OwnerInfo.CompanyCode + "',CompanyAddress='" + OwnerInfo.CompanyAddress + "',Position='" + OwnerInfo.Position + "' where UserId=" + OwnerInfo.UserId; } if (!IsValid(OwnerInfo, result)) { return(result); } result.HasError = DataAccess.ExecuteQuery(query) <= 0; if (result.HasError) { result.Message = "Something Went Wrong"; } else { result.Data = OwnerInfo; } } catch (Exception ex) { result.HasError = true; result.Message = ex.Message; } return(result); }
//private int GetID() //{ // string query = "select * from OwnerInfo 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 <OwnerInfo> GetAll() { var result = new List <OwnerInfo>(); try { string query = "select * from OwnerInfo"; var dt = DataAccess.GetDataTable(query); if (dt != null && dt.Rows.Count != 0) { for (int i = 0; i <= dt.Rows.Count; i++) { OwnerInfo u = ConvertToEntity(dt.Rows[i]); result.Add(u); } } } catch (Exception ex) { return(result); } return(result); }