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);
        }
Beispiel #4
0
        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>&nbsp; " + txtaddlogssn.Text + "<br/><b>Mail Clerk :</b> &nbsp;" + ddlmailclerk.SelectedItem.Text + "<br/> <b>Forward To :</b> &nbsp;" + ddlforward.SelectedItem.Text + "<br/> <b>Name/License # :</b> &nbsp;" + 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();
        }