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