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