private ProjectInfo GetModel() { ProjectInfo projectInfo = new ProjectInfo(); projectInfo.ProjectName = txtProjectName.Text.Trim(); projectInfo.CreatedUserId = LoginUser.UserId; projectInfo.CreateDate = DateTime.Now; projectInfo.ModiftyUserId = LoginUser.UserId; projectInfo.ModiftyDate = DateTime.Now; projectInfo.CustomerId = Convert.ToInt32(ddlCustomerList.SelectedValue); projectInfo.BussinessUserId = Convert.ToInt32(hidUserId.Value); return projectInfo; }
public ProjectInfo GetProjectById(int projectId) { ProjectInfo projectInfo = new ProjectInfo(); ProjectDal dal = new ProjectDal(); DataSet ds = dal.GetProjectById(projectId); if(ds!=null &&ds.Tables.Count>0&&ds.Tables[0].Rows.Count>0) { projectInfo = ConvertToModel(ds.Tables[0].Rows[0]); } return projectInfo; }
public void Add(ProjectInfo projectInfo) { string sql = " insert into P_Project(ProjectName,CreatedUserId,CreateDate,CustomerId,BussinessUserId) values(@ProjectName,@CreatedUserId,@CreateDate,@CustomerId,@BussinessUserId)"; List<SqlParameter> lstParamter = new List<SqlParameter>(); SqlParameter paramter = new SqlParameter("@ProjectName", projectInfo.ProjectName); lstParamter.Add(paramter); paramter = new SqlParameter("@CreatedUserId", projectInfo.CreatedUserId); lstParamter.Add(paramter); paramter = new SqlParameter("@CreateDate", projectInfo.CreateDate); lstParamter.Add(paramter); paramter = new SqlParameter("@CustomerId", projectInfo.CustomerId); lstParamter.Add(paramter); paramter = new SqlParameter("@BussinessUserId", projectInfo.BussinessUserId); lstParamter.Add(paramter); SQLHelp.ExecuteNonQuery(sql, lstParamter); }
public void Update(ProjectInfo projectInfo) { string sql = " update P_Project set ProjectName = @ProjectName, ModiftyUserId = @ModiftyUserId, ModiftyDate = @ModiftyDate, CustomerId = @CustomerId, BussinessUserId = @BussinessUserId "; sql += " where ProjectId =@ProjectId"; List<SqlParameter> lstParamter = new List<SqlParameter>(); SqlParameter paramter = new SqlParameter("@ProjectName", projectInfo.ProjectName); lstParamter.Add(paramter); paramter = new SqlParameter("@ModiftyUserId", projectInfo.ModiftyUserId); lstParamter.Add(paramter); paramter = new SqlParameter("@ModiftyDate", projectInfo.ModiftyDate); lstParamter.Add(paramter); paramter = new SqlParameter("@CustomerId", projectInfo.CustomerId); lstParamter.Add(paramter); paramter = new SqlParameter("@BussinessUserId", projectInfo.BussinessUserId); lstParamter.Add(paramter); paramter = new SqlParameter("@ProjectId", projectInfo.ProjectId); lstParamter.Add(paramter); SQLHelp.ExecuteNonQuery(sql, lstParamter); }
private ProjectInfo ConvertToModel(DataRow dr) { ProjectInfo projectInfo = new ProjectInfo(); if(dr!=null) { if(dr["ProjectId"] is DBNull ==false) { int projectId = 0; int.TryParse(dr["ProjectId"].ToString(), out projectId); projectInfo.ProjectId = projectId; } if (dr["ProjectName"] is DBNull == false) { projectInfo.ProjectName = dr["ProjectName"].ToString(); } if (dr["CreatedUserId"] is DBNull == false) { int createdUserId = 0; int.TryParse(dr["CreatedUserId"].ToString(), out createdUserId); projectInfo.CreatedUserId = createdUserId; } if (dr["CreateDate"] is DBNull == false) { DateTime createDate = DateTime.MaxValue; DateTime.TryParse(dr["CreateDate"].ToString(), out createDate); projectInfo.CreateDate = createDate; } if (dr["ModiftyUserId"] is DBNull == false) { int modiftyUserId = 0; int.TryParse(dr["ModiftyUserId"].ToString(), out modiftyUserId); projectInfo.ModiftyUserId = modiftyUserId; } if (dr["ModiftyDate"] is DBNull == false) { DateTime modiftyDate = DateTime.MaxValue; DateTime.TryParse(dr["ModiftyDate"].ToString(), out modiftyDate); projectInfo.ModiftyDate = modiftyDate; } if (dr["CustomerId"] is DBNull == false) { int customerId = 0; int.TryParse(dr["CustomerId"].ToString(), out customerId); projectInfo.CustomerId = customerId; } if (dr["BussinessUserId"] is DBNull == false) { int bussinessUserId = 0; int.TryParse(dr["BussinessUserId"].ToString(), out bussinessUserId); projectInfo.BussinessUserId = bussinessUserId; } if (dr["ResponseUserId"] is DBNull == false) { int responseUserId = 0; int.TryParse(dr["ResponseUserId"].ToString(), out responseUserId); projectInfo.ResponseUserId = responseUserId; } } return projectInfo; }
public void Update(ProjectInfo projectInfo) { ProjectDal dal = new ProjectDal(); dal.Update(projectInfo); }
public void Add(ProjectInfo projectInfo) { ProjectDal dal = new ProjectDal(); dal.Add(projectInfo); }