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);
}
}
