public call_center Insert_call_center_select(int ID)
{
call_center = call_center.Select(ID);
Insert_address_id_txt.Text = Convert.ToString(call_center.address_id);
Insert_call_center_name_txt.Text = Convert.ToString(call_center.call_center_name);
return(call_center);
}
public call_center Delete_call_center_select(int ID)
{
call_center = call_center.Select(ID);
Delete_call_center_id_txt_lbl.Text = Convert.ToString(call_center.call_center_id);
Delete_address_id_txt_lbl.Text = Convert.ToString(call_center.address_id);
Delete_call_center_name_txt_lbl.Text = Convert.ToString(call_center.call_center_name);
return(call_center);
}
public call_center Delete_call_center_select(int ID)
{
call_center = call_center.Select(ID);
Delete_call_center_id_txt_lbl.Text = Convert.ToString(call_center.call_center_id);
Delete_address_id_txt_lbl.Text = Convert.ToString(call_center.address_id);
Delete_call_center_name_txt_lbl.Text = Convert.ToString(call_center.call_center_name);
return call_center;
}
public call_center call_center_insert()
{
call_center.address_id = Convert.ToInt32(Insert_address_id_txt.Text);
call_center.call_center_name = Insert_call_center_name_txt.Text;
call_center = call_center.Insert(call_center);
Insert_call_center_GridView.DataBind();
Update_call_center_GridView.DataBind();
Delete_call_center_GridView.DataBind();
return(call_center);
}
public call_center call_center_insert()
{
call_center.address_id = Convert.ToInt32(Insert_address_id_txt.Text);
call_center.call_center_name = Insert_call_center_name_txt.Text;
call_center = call_center.Insert(call_center);
Insert_call_center_GridView.DataBind();
Update_call_center_GridView.DataBind();
Delete_call_center_GridView.DataBind();
return call_center;
}
public call_center call_center_update(int ID)
{
call_center = call_center.Select(ID);
call_center.call_center_id = Convert.ToInt32(Update_call_center_id_txt.Text);
call_center.address_id = Convert.ToInt32(Update_address_id_txt.Text);
call_center.call_center_name = Update_call_center_name_txt.Text;
call_center.Update(call_center);
Insert_call_center_GridView.DataBind();
Update_call_center_GridView.DataBind();
Delete_call_center_GridView.DataBind();
return(call_center);
}
public call_center call_center_update(int ID)
{
call_center = call_center.Select(ID);
call_center.call_center_id = Convert.ToInt32(Update_call_center_id_txt.Text);
call_center.address_id = Convert.ToInt32(Update_address_id_txt.Text);
call_center.call_center_name = Update_call_center_name_txt.Text;
call_center.Update(call_center);
Insert_call_center_GridView.DataBind();
Update_call_center_GridView.DataBind();
Delete_call_center_GridView.DataBind();
return call_center;
}
protected void updateDatabase()
{
//product_id_array has all product ids
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//case_intake
case_intake = case_intake_insert();
//encounter
encounter = encounter_insert();
//requestor
requestor = requestor_insert();
//requestor_Order
requestor_Order = requestor_Order_insert();
//Order_product
Order_Product = Order_Product_insert();
}
public call_center Insert_call_center_select(int ID)
{
call_center = call_center.Select(ID);
Insert_address_id_txt.Text = Convert.ToString(call_center.address_id);
Insert_call_center_name_txt.Text = Convert.ToString(call_center.call_center_name);
return call_center;
}
protected void Insert_Select_Record(object sender, EventArgs e)
{
call_center = Insert_call_center_select(Convert.ToInt32(Insert_call_center_GridView.SelectedValue));
}
protected void INSERT(object sender, EventArgs e)
{
call_center = call_center_insert();
}
protected void UPDATE(object sender, EventArgs e)
{
call_center = call_center_update(Convert.ToInt32(Update_call_center_GridView.SelectedValue));
}
protected void createEmail()
{
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//email
callcenter_Address = call_center.call_center_name + "<br />" + "(219) 564 5567";// +address.str_add + "<br />" + address.city + " " + address.state + " " + address.zip_plus_four + "<br />" + "(219) 564 5567";
NameOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Product Name: </b><br/><br/>";
TypeOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Type: </b><br/><br/>";
DescriptionOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Item Discription: </b><br/><br/>";
for (int i = 0; i < EName.Count; i++)
{
NameOrderData += EName[i] + "<br/>";
TypeOrderData += EType[i] + "<br/>";
DescriptionOrderData += EDescription[i] + "<br/>";
}
NameOrderData += "</td>";
TypeOrderData += "</td>";
DescriptionOrderData += "</td>";
var result = string.Join("|", EName.ToArray());
var message = new MailMessage("*****@*****.**", "*****@*****.**");
// here is an important part:
message.Subject = result + " -Has just been assigned a new location";
message.Body =
"<Table><tr><tb><b><font size='3'>The following product has been assigned a new location:</b></font></td></tr></table>" +
"<table id='Table1' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td colspan='12' align='left' style='border-style: none'>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
"<td rowspan='3' align='left' valign='top'>" +
"<font size='6' color='red'>DMCS</font>" +
"<br />" +
"Disaster Management Communication System" +
"<br />" +
"<br />" +
"<b>This order was placed at: </b><br />" +
callcenter_Address +
"</td>" +
"<td align='right' style='font-size: x-large; color: #808080; font-family: 'Times New Roman'; font-weight: bold;'>" + "<b>INVOICE</b>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td>" +
"<br />" +
"<br />" +
"</td>" +
"</tr>" +
"<tr>" +
"<td align='right' style='color: #000000'>" +
"<b>Invoice/Case/Order</b> #3" +
"<br />" +
Convert.ToString(System.DateTime.Now) +
"</td>" +
"</tr>" +
"</table>" +
"<table id='Table2' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td width='50%' align='left'>" +
"<b>Shipping To:</b>" + "<br />" +
"United States Steel Corporation" + "<br />" +
"1 Broadway" + "<br />" +
"Gary,IN" + "<br />" +
"(219) 888-2000" + "<br />" +
"</td>" +
"<td width='50%' align='left'>" +
"<b>Shiping From:</b>" + "<br />" +
selected_Warehouse.warehouse_name + "<br />" +
address.str_add + "<br />" +
address.city + " " + address.state + " " + address.zip_plus_four + "<br />" +
"(219) 564 5567" + "<br />" +
"</td>" +
"</tr>" +
"</table>" +
"<table id='Table7' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td colspan='10' width='100%' align='left'>" +
"<br />" +
"<b>ORDER:</b>" +
"<br />" +
"</td>" +
"</tr>" +
"<tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
NameOrderData +
TypeOrderData +
DescriptionOrderData +
"</tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
"</table>" +
"<table><tr><tb></td></tr>" +
"<tr><tb><br/><br/><br/><br/>DO NOT RESPOND TO THIS MESSAGE." + "</td></tr>" +
"<tr><tb>THIS WAS A AUTOMATED MESSAGE SENT FROM THE DMSC SERVERS. </td></tr></table>";
//Set html to true! This allows for more then just a string with no breaks.
message.IsBodyHtml = true;
var client = new SmtpClient();
client.EnableSsl = true;
client.Send(message);
/////////////////////////////////////////////////////// EMAIL SENT
}
protected void updateDatabase()
{
//product_id_array has all product ids
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//case_intake
case_intake = case_intake_insert();
//encounter
encounter = encounter_insert();
//requestor
requestor = requestor_insert();
//requestor_Order
requestor_Order = requestor_Order_insert();
//Order_product
Order_Product = Order_Product_insert();
}
protected void INSERT(object sender, EventArgs e)
{
call_center = call_center_insert();
}
protected void UPDATE(object sender, EventArgs e)
{
call_center = call_center_update(Convert.ToInt32(Update_call_center_GridView.SelectedValue));
}
protected void Update_Select_Record(object sender, EventArgs e)
{
call_center = Update_call_center_select(Convert.ToInt32(Update_call_center_GridView.SelectedValue));
}
protected void Save_Disaster_Enconter_info()
{
clientencounter.case_id = GlobalVariables.CaseID;
clientencounter.client_id = GlobalVariables.ClientID;
clientencounter.encounter_id = GlobalVariables.EncounterID;
clientencounter.call_center_id = Convert.ToInt32(DDL_Call_Center.SelectedValue);
clientencounter.create_date = DateTime.Now;
clientencounter.close_date = Convert.ToDateTime("9/9/9999");
EncCallCenter = EncCallCenter.Select(clientencounter.call_center_id);
if (clientencounter.encounter_id == 0)
{
clientencounter = clientencounter.Insert(clientencounter);
}
else
{
clientencounter.Update(clientencounter);
}
disasterEncounter.disaster_id = Convert.ToInt32(DDlDisasters.SelectedValue);
GlobalVariables.DisasterID = disasterEncounter.disaster_id;
disasterEncounter.encounter_id = clientencounter.encounter_id;
GlobalVariables.EncounterID = clientencounter.encounter_id;
//disasterEncounter.address_id = EncCallCenter.address_id;
if (disasterEncounter.disaster_encounter_id == 0)
{
disasterEncounter = disasterEncounter.Insert(disasterEncounter);
}
else
{
disasterEncounter.Update(disasterEncounter);
}
}
protected void createEmail()
{
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//email
callcenter_Address = call_center.call_center_name + "<br />" + "(219) 564 5567";// +address.str_add + "<br />" + address.city + " " + address.state + " " + address.zip_plus_four + "<br />" + "(219) 564 5567";
NameOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Product Name: </b><br/><br/>";
TypeOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Type: </b><br/><br/>";
DescriptionOrderData = "<td colspan='1' width='10%' align='left' style='height: 87px'>" + "<b>Item Discription: </b><br/><br/>";
for (int i = 0; i < EName.Count; i++)
{
NameOrderData += EName[i] + "<br/>";
TypeOrderData += EType[i] + "<br/>";
DescriptionOrderData += EDescription[i] + "<br/>";
}
NameOrderData += "</td>";
TypeOrderData += "</td>";
DescriptionOrderData += "</td>";
var result = string.Join("|", EName.ToArray());
var message = new MailMessage("*****@*****.**", "*****@*****.**");
// here is an important part:
message.Subject = result + " -Has just been assigned a new location";
message.Body =
"<Table><tr><tb><b><font size='3'>The following product has been assigned a new location:</b></font></td></tr></table>" +
"<table id='Table1' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td colspan='12' align='left' style='border-style: none'>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
"<td rowspan='3' align='left' valign='top'>" +
"<font size='6' color='red'>DMCS</font>" +
"<br />" +
"Disaster Management Communication System" +
"<br />" +
"<br />" +
"<b>This order was placed at: </b><br />" +
callcenter_Address +
"</td>" +
"<td align='right' style='font-size: x-large; color: #808080; font-family: 'Times New Roman'; font-weight: bold;'>" + "<b>INVOICE</b>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td>" +
"<br />" +
"<br />" +
"</td>" +
"</tr>" +
"<tr>" +
"<td align='right' style='color: #000000'>" +
"<b>Invoice/Case/Order</b> #3" +
"<br />" +
Convert.ToString(System.DateTime.Now) +
"</td>" +
"</tr>" +
"</table>" +
"<table id='Table2' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td width='50%' align='left'>" +
"<b>Shipping To:</b>" + "<br />" +
"United States Steel Corporation" + "<br />" +
"1 Broadway" + "<br />" +
"Gary,IN" + "<br />" +
"(219) 888-2000" + "<br />" +
"</td>" +
"<td width='50%' align='left'>" +
"<b>Shiping From:</b>" + "<br />" +
selected_Warehouse.warehouse_name + "<br />" +
address.str_add + "<br />" +
address.city + " " + address.state + " " + address.zip_plus_four + "<br />" +
"(219) 564 5567" + "<br />" +
"</td>" +
"</tr>" +
"</table>" +
"<table id='Table7' width='100%' cellspacing='10' bgcolor='Silver'>" +
"<tr>" +
"<td colspan='10' width='100%' align='left'>" +
"<br />" +
"<b>ORDER:</b>" +
"<br />" +
"</td>" +
"</tr>" +
"<tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
NameOrderData +
TypeOrderData +
DescriptionOrderData +
"</tr>" +
"<tr>" +
"<td colspan='12' style='background-color: Gray' height='5px'>" + "</td>" +
"</tr>" +
"<tr>" +
"</table>" +
"<table><tr><tb></td></tr>" +
"<tr><tb><br/><br/><br/><br/>DO NOT RESPOND TO THIS MESSAGE." + "</td></tr>" +
"<tr><tb>THIS WAS A AUTOMATED MESSAGE SENT FROM THE DMSC SERVERS. </td></tr></table>";
//Set html to true! This allows for more then just a string with no breaks.
message.IsBodyHtml = true;
var client = new SmtpClient();
client.EnableSsl = true;
client.Send(message);
/////////////////////////////////////////////////////// EMAIL SENT
}
