protected void Button2_Click(object sender, EventArgs e)
{
String id = Session["id"].ToString();
decimal dec = System.Convert.ToDecimal(id);
String acitvity_id = activity_name.SelectedItem.Value;
databaseDataContext up = new databaseDataContext();
//Get Single course which need to update
RefComplaint obj = up.RefComplaints.Single(c => c.complaint_id.Equals(dec));
//Field which will be update
int activity_id = System.Convert.ToInt16(activity_name.SelectedItem.Value);
obj.ActivityID = activity_id;
// executes the appropriate commands to implement the changes to the database
up.SubmitChanges();
databaseDataContext up1 = new databaseDataContext();
RefActivityDetail activity = new RefActivityDetail {
complaint_id = dec, ActivityID = activity_id
};
up1.RefActivityDetails.InsertOnSubmit(activity);
up1.SubmitChanges();
Response.Redirect("compaint_list.aspx");
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
String id = Session["id"].ToString();
decimal dec = System.Convert.ToDecimal(id);
string struserid = Session["UserID"].ToString();
Session["check"] = 1;
Session["subject"] = "complaint";
Session["subject"] = "complaint";
Session["to"] = "hh";
Session["date"] = DateTime.Now.ToString();
Session["channel"] = "";
Session["problem"] = "";
Session["system"] = "";
Session["module"] = "";
int actvity_id = System.Convert.ToInt16(activity.SelectedItem.Value);
string des = TextBox1.Text;
string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
databaseDataContext data = new databaseDataContext();
RefActivityDetail obj = new RefActivityDetail
{
complaint_id = dec,
ActivityID = actvity_id,
Activity_description = des,
Activity_time = System.Convert.ToDateTime(time),
Activity_performed_by = struserid
};
data.RefActivityDetails.InsertOnSubmit(obj);
RefComplaint obj11 = data.RefComplaints.Single(c => c.complaint_id.Equals(dec));
if (actvity_id.Equals(2) || actvity_id.Equals(10) || actvity_id.Equals(12))
{
obj11.status = "Close";
}
else
{
obj11.status = "Open";
}
obj11.ActivityID = actvity_id;
obj11.Assigne_to = struserid;
data.SubmitChanges();
SendEmail();
}
protected void Button2_Click(object sender, EventArgs e)
{
String subject = combProjectDesc.SelectedItem.Text;
String assinge_by = "Anonymous";
String priority = DropDownList3.SelectedItem.Text;
String location = cmbLocationID.SelectedItem.Text;
String description = txtRequestDes.Text;
Decimal Projectcategoryid = System.Convert.ToDecimal(combprojCat.SelectedItem.Value);
String status = "Open";
Decimal emp_idd = System.Convert.ToDecimal(emp_iddd.Text);
databaseDataContext data = new databaseDataContext();
RefComplaint obj = new RefComplaint {
date = DateTime.Now, ActivityID = 1, Reported_channel_ID = '1',
Assign_By = assinge_by, category = combprojCat.SelectedItem.Text, ProjectCatID = Projectcategoryid,
desription = description,
subject = subject,
Assigne_to = "mohsin",
priority = priority,
location = location,
status = status,
emp_id = emp_idd,
emp_designation = designation.Text,
emp_name = name.Text
};
data.RefComplaints.InsertOnSubmit(obj);
data.SubmitChanges();
decimal id = obj.complaint_id;
Session["comlaint_id"] = id;
/* decimal id = obj.complaint_id;
* Session["comlaint_id"] = id;
*
* // Session["UserID"] = name.Text;
* Session["subject"] = combprojCat.SelectedItem.Text + " category of " + subject + " (" + id + ")";
* Session["date"] = DateTime.Now.ToString();
* Session["to"] = "Mr.Mohsin";
* Session["channel"] = "U Microfinance Bank";
* Session["problem"] = combprojCat.SelectedItem.Text;
* Session["system"] = subject;
* Session["module"] = combprojCat.SelectedItem.Text;*/
Response.Redirect("incident_confirmation.aspx");
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
String id = Session["id"].ToString();
decimal dec = System.Convert.ToDecimal(id);
int actvity_id = System.Convert.ToInt16(activity.SelectedItem.Value);
string des = TextBox1.Text;
string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
databaseDataContext data = new databaseDataContext();
RefActivityDetail obj = new RefActivityDetail
{
complaint_id = dec,
ActivityID = actvity_id,
Activity_description = des,
Activity_time = System.Convert.ToDateTime(time),
Activity_performed_by = "Mohsin"
};
data.RefActivityDetails.InsertOnSubmit(obj);
RefComplaint obj11 = data.RefComplaints.Single(c => c.complaint_id.Equals(dec));
if (actvity_id.Equals(2) || actvity_id.Equals(10) || actvity_id.Equals(12))
{
obj11.status = "Close";
}
else
{
obj11.status = "Open";
}
obj11.ActivityID = actvity_id;
//obj11.Assigne_to = assinge_to.SelectedItem.Text;
data.SubmitChanges();
Response.Redirect("validation_resolve.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
if (FileUpload2.HasFile)
{
// Call a helper method routine to save the file.
SaveFile(FileUpload2.PostedFile);
}
String subject = combProjectDesc.SelectedItem.Text;
String assigne = combAssignename.SelectedItem.Value;
String priority = DropDownList3.SelectedItem.Text;
String location = cmbLocationID.SelectedItem.Text;
String description = txtRequestDes.Text;
Decimal Projectcategoryid = System.Convert.ToDecimal(combprojCat.SelectedItem.Value);
String status = "Open";
Decimal channel_id = System.Convert.ToDecimal(reported_channel.SelectedItem.Value);
// Decimal reported_problem = System.Convert.ToDecimal(problem_request.SelectedItem.Value);
String date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
databaseDataContext data = new databaseDataContext();
RefComplaint obj = new RefComplaint {
date = DateTime.Now, ActivityID = 1, Reported_channel_ID = channel_id, Reported_problem_ID = 11,
Assign_By = reported_by.Text.ToString(), category = combprojCat.SelectedItem.Text, ProjectCatID = Projectcategoryid,
desription = description, subject = subject, Assigne_to = assigne, priority = priority,
location = location, status = status, Reporters_email = reports_email.Text.ToString(), Reporters_number = reporters_number.Text.ToString()
};
data.RefComplaints.InsertOnSubmit(obj);
data.SubmitChanges();
decimal id = obj.complaint_id;
Session["comlaint_id"] = id;
Session["subject"] = combprojCat.SelectedItem.Text + " category of " + subject + " (" + id + ")";
Session["date"] = DateTime.Now.ToString();
Session["to"] = assigne;
Session["channel"] = reported_channel.SelectedItem.Value;
Session["problem"] = 11;
Session["system"] = subject;
Session["module"] = combprojCat.SelectedItem.Text;
var user = (from u in data.UserManagers
where u.UserID.Equals(assigne)
select u).FirstOrDefault();
String to = user.OrgEmail.ToString();
/* var user1 = (from u in data.UserManagers
* where u.UserID.Equals(reported_by.Text)
* select u).FirstOrDefault();*/
//checking all feilds
//string cc = user1.OrgEmail.ToString();
SendEmail(to, "Complaint Issue", "hello hello hello");
}
