protected void btnAddProject_Click(object sender, EventArgs e) { try { var DC = new DataClassesDataContext(); //tblProject objpro = new tblProject(); //objpro.ClientID = Convert.ToInt32(ddClient.SelectedValue); //objpro.CategoryID = Convert.ToInt32(ddCategory.SelectedValue); //objpro.LanguageID = Convert.ToInt32(ddLanguage.SelectedValue); //objpro.Title = txtTitle.Text; //objpro.Description = txtDes.Text; //objpro.AssignDate = DateTime.Now; //objpro.DeadlineDate = Convert.ToDateTime(txtDeadline.Text); //DC.tblProjects.InsertOnSubmit(objpro); //DC.SubmitChanges(); DateTime DeadLineDate = DateTime.Now.AddDays(Convert.ToInt32(txtDays.Text)); string Date = Convert.ToDateTime(DeadLineDate).ToString("dddd, MMMM dd, yyyy h:mm:ss tt"); int LanguageID; if (ddLanguage.SelectedValue != "") { LanguageID = Convert.ToInt32(ddLanguage.SelectedValue); } else { LanguageID = Convert.ToInt32(0); } ProjectObject.AddProject(txtPname.Text, Convert.ToInt32(ddClient.SelectedValue), Convert.ToInt32(ddCategory.SelectedValue), LanguageID, txtDes.Text, Convert.ToInt32(Session["AdminID"]), Convert.ToDateTime(Date)); //PostProejct Assign=true if (Request.QueryString["PostProjectID"] != null) { tblPostProject Assign = (from obj in DC.tblPostProjects where obj.ProjectID == Convert.ToInt32(Request.QueryString["PostProjectID"]) select obj).Single(); Assign.IsAssign = true; DC.SubmitChanges(); } Response.Redirect("ViewProject.aspx"); } catch (Exception ex) { int session = Convert.ToInt32(Session["AdminID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["AdminID"] == null) { Response.Redirect("Login.aspx"); } if (!IsPostBack) { fillCatDrop(); fillClientDrop(); var DC = new DataClassesDataContext(); tblAdmin AdminData = DC.tblAdmins.Single(ob => ob.AdminID == Convert.ToInt32(Session["AdminID"])); if (AdminData.IsInsert == false) { divPage.Visible = false; divError.Visible = true; } if (Request.QueryString["PostProjectID"] != null) { tblPostProject Data = (from ob in DC.tblPostProjects where ob.ProjectID == Convert.ToInt32(Request.QueryString["PostProjectID"]) select ob).Single(); txtPname.Text = Data.Title; ddClient.SelectedValue = Data.ClientID.ToString(); string SuperID; try { SuperID = (from obj in DC.tblCategories where obj.CategoryID == Convert.ToInt32(Data.CategoryID) select obj.SuperID).Single().ToString(); } catch (Exception Ex) { SuperID = "0"; lblOther.Text = "(Other)"; lblOther.Visible = true; } IQueryable <tblCategory> Category; if (SuperID != null && SuperID != "0") { Category = (from obCat in DC.tblCategories where obCat.SuperID == Convert.ToInt32(SuperID) select obCat); } else { Category = (from obCat in DC.tblCategories where obCat.SuperID == null select obCat); } ddCategory.DataSource = Category; ddCategory.DataValueField = "CategoryID"; ddCategory.DataTextField = "CategoryName"; ddCategory.DataBind(); ddCategory.SelectedValue = Data.CategoryID.ToString(); int super = 0; ddLanguage.DataSource = ProjectObject.FillLanguageProject(Convert.ToInt32(Data.CategoryID), super); ddLanguage.DataTextField = "LanguageName"; ddLanguage.DataValueField = "LanguageID"; ddLanguage.DataBind(); ddLanguage.Items.Insert(0, new ListItem("Select Language", "")); TimeSpan Days = Convert.ToDateTime(Data.DeadlineDate) - Convert.ToDateTime(Data.CreateOn); txtDays.Text = Convert.ToInt32(Days.TotalDays).ToString(); txtDes.Text = Data.Description; } } } catch (Exception ex) { int session = Convert.ToInt32(Session["AdminID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }