//private void GetTaskBoardPersonalToDo(HttpContext context) //{ //} private void AddTaskPersonal(HttpContext context) { BLL.TaskPersonal bll = new BLL.TaskPersonal(); Model.TaskPersonal model = new Model.TaskPersonal(); model.TP_Title = context.Request["TP_Title"]; model.TP_DateStart = Convert.ToDateTime(context.Request["TP_DateStart"]).ToString("yyyy-MM-dd"); model.TP_DateEnd = Convert.ToDateTime(context.Request["TP_DateEnd"]).ToString("yyyy-MM-dd"); model.TP_Owner = context.Request["TP_Owner"]; model.TP_Comments = context.Request["TP_Comments"]; model.TP_Status = "Pending"; model.TP_IsDelete = "0"; model.TP_CreateUser = context.Request["User_ID"]; model.TP_Progress = "0"; model.TP_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); int AddRes = bll.Add(model); if (AddRes > 0) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }
public int Add(Model.TaskPersonal model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TaskPersonal (TP_Title,TP_DateStart,TP_DateEnd,TP_Progress,TP_CreateUser,TP_Owner,TP_Comments,TP_Status,TP_IsDelete,TP_CreateDate) "); strSql.Append("values (@TP_Title,@TP_DateStart,@TP_DateEnd,@TP_Progress,@TP_CreateUser,@TP_Owner,@TP_Comments,@TP_Status,@TP_IsDelete,@TP_CreateDate);"); strSql.Append("select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TP_Title", SqlDbType.VarChar, 300), new SqlParameter("@TP_DateStart", SqlDbType.VarChar, 20), new SqlParameter("@TP_DateEnd", SqlDbType.VarChar, 20), new SqlParameter("@TP_Progress", SqlDbType.VarChar, 10), new SqlParameter("@TP_CreateUser", SqlDbType.VarChar, 50), new SqlParameter("@TP_Owner", SqlDbType.VarChar, 50), new SqlParameter("@TP_Comments", SqlDbType.VarChar), new SqlParameter("@TP_Status", SqlDbType.VarChar, 10), new SqlParameter("@TP_IsDelete", SqlDbType.VarChar, 5), new SqlParameter("@TP_CreateDate", SqlDbType.VarChar, 20) }; parameters[0].Value = model.TP_Title; parameters[1].Value = model.TP_DateStart; parameters[2].Value = model.TP_DateEnd; parameters[3].Value = model.TP_Progress; parameters[4].Value = model.TP_CreateUser; parameters[5].Value = model.TP_Owner; parameters[6].Value = model.TP_Comments; parameters[7].Value = model.TP_Status; parameters[8].Value = model.TP_IsDelete; parameters[9].Value = model.TP_CreateDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public int Add(Model.TaskPersonal model) { return(dal.Add(model)); }