public static void OperationsDelete(tbl_Add_Log AddLog) { using (OperationsDataContext dbUpdate = new OperationsDataContext()) { dbUpdate.USP_OperationsAddlog(103, Convert.ToInt32(AddLog.Add_log_ID), null, null, null, null, null, null, null, null, null, null, null, null); dbUpdate.SubmitChanges(); } }
public static void OperationsUpdateValues(tbl_Add_Log AddLog, string uname) { using (OperationsDataContext dbUpdate = new OperationsDataContext()) { dbUpdate.USP_OperationsAddlog(102, Convert.ToInt32(AddLog.Add_log_ID), AddLog.Date_Received.ToString(), AddLog.From_Received, AddLog.SSN, AddLog.Forward_To, AddLog.MailClerk, AddLog.SpecialEntries, AddLog.PaymentType, AddLog.Amount.ToString(), AddLog.CheckNumber, AddLog.Walkin, AddLog.Feetype, uname); dbUpdate.SubmitChanges(); } }
protected void btndel_click1(object sender, EventArgs e) { tbl_Add_Log ObjAddLog = new tbl_Add_Log(); ObjAddLog.Add_log_ID = Convert.ToInt32(hfdselid.Value); OperationsLink.Operations.OperationsDelete(ObjAddLog); ScriptManager.RegisterStartupScript(Page, GetType(), "js", "Afterdel()", true); }
protected void btnaddlog_Click(object sender, EventArgs e) { string walkin = ""; if (chk_walkin.Checked == true) { walkin = "True"; } else { walkin = "false"; } tbl_Add_Log ObjAddLog = new tbl_Add_Log(); ObjAddLog.Add_log_ID = 0; ObjAddLog.Date_Received = Convert.ToDateTime(txtdatetreceive.Text); ObjAddLog.From_Received = txtaddlogfrom.Text; ObjAddLog.SSN = txtaddlogssn.Text; ObjAddLog.Forward_To = ddlforward.SelectedValue.ToString(); ObjAddLog.MailClerk = ddlmailclerk.SelectedValue.ToString(); ObjAddLog.SpecialEntries = txtspecialentry.Text; ObjAddLog.PaymentType = ddlpaymenttype.SelectedValue.ToString(); if (txtamount.Text != "") { ObjAddLog.Amount = Convert.ToDecimal(txtamount.Text); } ObjAddLog.CheckNumber = txtchecknumber.Text; ObjAddLog.Walkin = walkin; ObjAddLog.Feetype = ddlsfeetype.SelectedValue.ToString(); OperationsLink.Operations.OperationsInsertValues(ObjAddLog, Session["Uname"].ToString()); // Mail.SendMail(ddlforward.SelectedItem.Text, AdminLinq.Admin.Getemail(ddlforward.SelectedValue), "", "Log Entry", " This email is to alert you that a check or file is on its way to you.<br/> <b>Payer :</b> " + txtaddlogssn.Text + "<br/><b>Mail Clerk :</b> " + ddlmailclerk.SelectedItem.Text + "<br/> <b>Forward To :</b> " + ddlforward.SelectedItem.Text + "<br/> <b>Name/License # :</b> " + txtaddlogfrom.Text); altbox("Log added successfully."); Clear(); }
protected void btnupdateaddlog_Click(object sender, EventArgs e) { string walkin = ""; if (chk_walkin.Checked == true) { walkin = "True"; } else { walkin = "false"; } // utilities_Person.Insert_addlogInfo("102", lbladdlogid.Text, txtdatetreceiveedit.Text, txtaddlogfrom.Text, txtaddlogssn.Text, ddlforward.SelectedValue.ToString(), ddlmailclerk.SelectedValue.ToString(), txtspecialentry.Text, ddlpaymenttype.SelectedValue, txtamount.Text, txtchecknumber.Text, walkin, ddlfeetype.SelectedValue.ToString()); // bindaddlog(); tbl_Add_Log ObjAddLog = new tbl_Add_Log(); ObjAddLog.Add_log_ID = Convert.ToInt32(hfdautoid.Value); ObjAddLog.Date_Received = Convert.ToDateTime(txtdatetreceiveedit.Text); ObjAddLog.From_Received = txtaddlogfrom.Text; ObjAddLog.SSN = txtaddlogssn.Text; ObjAddLog.Forward_To = ddlforward.SelectedValue.ToString(); ObjAddLog.MailClerk = ddlmailclerk.SelectedValue.ToString(); ObjAddLog.SpecialEntries = txtspecialentry.Text; ObjAddLog.PaymentType = ddlpaymenttype.SelectedValue.ToString(); ObjAddLog.Amount = Convert.ToDecimal(txtamount.Text); ObjAddLog.CheckNumber = txtchecknumber.Text; ObjAddLog.Walkin = walkin; ObjAddLog.Feetype = ddlfeetype.SelectedValue.ToString(); OperationsLink.Operations.OperationsUpdateValues(ObjAddLog, Session["Uname"].ToString()); string js = "afterupdate();"; ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true); Clear(); }