private bool IsValid(SelectedWorker obj, Result <SelectedWorker> result)
        {
            if (!ValidationHelper.IsStringValid(obj.UserId.ToString()))
            {
                result.HasError = true;
                result.Message  = "Invalid UserId";
                return(false);
            }


            if (!ValidationHelper.IsStringValid(obj.Price.ToString()))
            {
                result.HasError = true;
                result.Message  = "Invalid Price";
                return(false);
            }
            if (!ValidationHelper.IsStringValid(obj.SubmissionDate.ToString()))
            {
                result.HasError = true;
                result.Message  = "Invalid SubmissionDate";
                return(false);
            }

            return(true);
        }
        public Result <SelectedWorker> Save(SelectedWorker userinfo)
        {
            var result = new Result <SelectedWorker>();

            try
            {
                var objtosave = DbContext.SelectedWorkers.FirstOrDefault(u => u.PostId == userinfo.PostId);
                if (objtosave == null)
                {
                    objtosave = new SelectedWorker();
                    DbContext.SelectedWorkers.Add(objtosave);
                }
                objtosave.UserId         = userinfo.UserId;
                objtosave.Price          = userinfo.Price;
                objtosave.SubmissionDate = userinfo.SubmissionDate;



                if (!IsValid(objtosave, result))
                {
                    return(result);
                }
                DbContext.SaveChanges();
            }
            catch (Exception ex)
            {
                result.HasError = true;
                result.Message  = ex.Message;
            }
            return(result);
        }
        //public bool Delete(int id)
        //{
        //    var result = new Result<SelectedWorker>();
        //    try
        //    {
        //        string query = "delete from SelectedWorker where SavedFileId=" + id;
        //        return DataAccess.ExecuteQuery(query) > 0;
        //    }
        //    catch (Exception ex)
        //    {
        //        return false;
        //    }
        //}



        private SelectedWorker ConvertToEntity(DataRow row)
        {
            try
            {
                SelectedWorker u = new SelectedWorker();
                u.PostId         = Int32.Parse(row["PostId"].ToString());
                u.UserId         = Int32.Parse(row["UserID"].ToString());
                u.Price          = Int32.Parse(row["Price"].ToString());
                u.SubmissionDate = Convert.ToDateTime(row["SubmissionDate"]);



                return(u);
            }
            catch (Exception)
            {
                return(null);
            }
        }
Exemple #4
0
        public Result <SelectedWorker> Save(SelectedWorker SelectedWorker)
        {
            var result = new Result <SelectedWorker>();

            try
            {
                string query = "select * from SelectedWorker where PostId=" + SelectedWorker.PostId;
                //var dt = DataAccess.GetDataTable(query);

                //if (dt == null || dt.Rows.Count == 0)
                //{
                // SelectedWorker.SavedFileId = GetID();
                var d = SelectedWorker.SubmissionDate.ToString(string.Format("dd/MMM/yyyy"));

                query = "insert into SelectedWorker values(" + SelectedWorker.PostId + "," + SelectedWorker.UserId + "," + SelectedWorker.Price + ",'" + d + "')";
                //}
                //else
                //{
                //    query = "update SelectedWorker set ProjectName='" + SelectedWorker.ProjectName + "',StartTime='" + SelectedWorker.StartTime + "',EndTime='" + SelectedWorker.EndTime + "',Description='" + SelectedWorker.Description + "',ProjectSection='" + SelectedWorker.ProjectSection + "',Price=" + SelectedWorker.Price + ",Members=" + SelectedWorker.Members + " where PostID=" + SelectedWorker.PostId;
                //}



                result.HasError = DataAccess.ExecuteQuery(query) <= 0;

                if (result.HasError)
                {
                    result.Message = "Something Went Wrong";
                }
                else
                {
                    result.Data = SelectedWorker;
                }
            }
            catch (Exception ex)
            {
                result.HasError = true;
                result.Message  = ex.Message;
            }
            return(result);
        }
        //private int GetID()
        //{
        //    string query = "select * from SelectedWorker 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]["SavedFileId"].ToString()) + 1;

        //    return id;
        //}
        public List <SelectedWorker> GetAll()
        {
            var result = new List <SelectedWorker>();

            try
            {
                string query = "select * from SelectedWorker";
                var    dt    = DataAccess.GetDataTable(query);

                if (dt != null && dt.Rows.Count != 0)
                {
                    for (int i = 0; i <= dt.Rows.Count; i++)
                    {
                        SelectedWorker u = ConvertToEntity(dt.Rows[i]);
                        result.Add(u);
                    }
                }
            }
            catch (Exception ex)
            {
                return(result);
            }
            return(result);
        }