public Result <PostAProject> Save(PostAProject PostAProject)
{
var result = new Result <PostAProject>();
try
{
var objtosave = DbContext.PostAProjects.FirstOrDefault(u => u.PostId == PostAProject.PostId);
if (objtosave == null)
{
objtosave = new PostAProject();
DbContext.PostAProjects.Add(objtosave);
}
objtosave.WUserId = PostAProject.WUserId;
objtosave.ProjectName = PostAProject.ProjectName;
objtosave.Price = PostAProject.Price;
objtosave.StartTime = PostAProject.StartTime;
objtosave.EndTime = PostAProject.EndTime;
objtosave.Description = PostAProject.Description;
objtosave.Members = PostAProject.Members;
if (!IsValid(objtosave, result))
{
return(result);
}
DbContext.SaveChanges();
}
catch (Exception ex)
{
result.HasError = true;
result.Message = ex.Message;
}
return(result);
}
private bool IsValid(PostAProject obj, Result <PostAProject> result)
{
if (!ValidationHelper.IsStringValid(obj.ProjectName))
{
result.HasError = true;
result.Message = "Invalid School Name";
return(false);
}
return(true);
}
private bool IsValid(PostAProject obj, Result <PostAProject> result)
{
if (!ValidationHelper.IsStringValid(obj.WUserId.ToString()))
{
result.HasError = true;
result.Message = "Invalid WUserId";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.ProjectName))
{
result.HasError = true;
result.Message = "Invalid ProjectName";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.Price.ToString()))
{
result.HasError = true;
result.Message = "Invalid Price";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.StartTime.ToString()))
{
result.HasError = true;
result.Message = "Invalid StartTime";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.EndTime.ToString()))
{
result.HasError = true;
result.Message = "Invalid EndTime";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.Description))
{
result.HasError = true;
result.Message = "Invalid Description";
return(false);
}
if (!ValidationHelper.IsStringValid(obj.Members.ToString()))
{
result.HasError = true;
result.Message = "Invalid Members";
return(false);
}
return(true);
}
private bool IsValidToSave(PostAProject obj, Result <PostAProject> result)
{
if (!ValidationHelper.IsIntValid(obj.PostId.ToString()))
{
result.HasError = true;
result.Message = "Invalid UserID";
return(false);
}
if (DbContext.PostAProjects.Any(u => u.PostId == obj.PostId))
{
result.HasError = true;
result.Message = "Email PostId";
return(false);
}
return(true);
}
public Result <PostAProject> Save(PostAProject PostAProject)
{
var result = new Result <PostAProject>();
try
{
string query = "select * from PostAProject where PostID=" + PostAProject.PostId;
var dt = DataAccess.GetDataTable(query);
if (dt == null || dt.Rows.Count == 0)
{
PostAProject.PostId = GetID();
var d = PostAProject.StartTime.ToString(string.Format("dd/MMM/yyyy"));
var b = PostAProject.EndTime.ToString(string.Format("dd/MMM/yyyy"));
query = "insert into PostAProject values(" + PostAProject.PostId + "," + 1 + ",'" + PostAProject.ProjectName + "'," + PostAProject.Price + ",'" + d + "','" + b + "','" + PostAProject.Description + "'," + PostAProject.Members + ")";
}
else
{
query = "update PostAProject set ProjectName='" + PostAProject.ProjectName + "',StartTime='" + PostAProject.StartTime + "',EndTime='" + PostAProject.EndTime + "',Description='" + PostAProject.Description + "',Price=" + PostAProject.Price + ",Members=" + PostAProject.Members + " where PostID=" + PostAProject.PostId;
}
if (!IsValid(PostAProject, result))
{
return(result);
}
result.HasError = DataAccess.ExecuteQuery(query) <= 0;
if (result.HasError)
{
result.Message = "Something Went Wrong";
}
else
{
result.Data = PostAProject;
}
}
catch (Exception ex)
{
result.HasError = true;
result.Message = ex.Message;
}
return(result);
}
public List <PostAProject> GetAll()
{
var result = new List <PostAProject>();
try
{
string query = "select * from PostAProject";
var dt = DataAccess.GetDataTable(query);
if (dt != null && dt.Rows.Count != 0)
{
for (int i = 0; i <= dt.Rows.Count; i++)
{
PostAProject u = ConvertToEntity(dt.Rows[i]);
result.Add(u);
}
}
}
catch (Exception ex)
{
return(result);
}
return(result);
}
private PostAProject ConvertToEntity(DataRow row)
{
try
{
PostAProject u = new PostAProject();
u.PostId = Int32.Parse(row["PostID"].ToString());
u.WUserId = Int32.Parse(row["WUserID"].ToString());
u.Price = Int32.Parse(row["Price"].ToString());
u.Members = Int32.Parse(row["Members"].ToString());
u.ProjectName = row["ProjectName"].ToString();
u.Description = row["Description"].ToString();
u.StartTime = Convert.ToDateTime(row["StartTime"]);
u.EndTime = Convert.ToDateTime(row["EndTime"]);
return(u);
}
catch (Exception)
{
return(null);
}
}