Exemple #1
0
    protected void btnSendMail_Click(object sender, EventArgs e)
    {
        try
        {
            DataView  dv;
            DataTable dt;
            string    emailID;
            string    trans_no;
            string    B_STORE_ID;
            string    B_STORE;
            string    type_id              = "2";
            string    uname                = Session["USER_NAME"].ToString().ToUpper();
            string    user_id              = WebTools.GetExpr("USER_ID", "USERS", " WHERE UPPER(USER_NAME)='" + uname + "'");
            string    userEmail            = WebTools.GetExpr("EMAIL", "USERS", " WHERE UPPER(USER_NAME)='" + uname + "'");
            DataSourceSelectArguments args = new DataSourceSelectArguments();
            dv = MailDataSource.Select(args) as DataView;
            dt = dv.ToTable() as DataTable;
            string TRANSF_ID = IssueGridView.SelectedValue.ToString();
            trans_no   = WebTools.GetExpr("TRANSF_NO", "VIEW_ADAPTER_MAT_TRANSF", " WHERE TRANSF_ID='" + TRANSF_ID + "'");
            B_STORE_ID = WebTools.GetExpr("B_STORE_ID", "VIEW_ADAPTER_MAT_TRANSF", " WHERE TRANSF_ID='" + TRANSF_ID + "'");
            B_STORE    = WebTools.GetExpr("B_STORE", "VIEW_ADAPTER_MAT_TRANSF", " WHERE TRANSF_ID='" + TRANSF_ID + "'");
            string STATUS_FLG = WebTools.GetExpr("STATUS_FLG", "PIP_MAT_TRANSF", " WHERE TRANSF_ID='" + TRANSF_ID + "'");
            if (STATUS_FLG == "N")
            {
                foreach (DataRow myRow in dt.Rows)
                {
                    emailID = WebTools.GetExpr("EMAIL", "USERS_PDF_MAIL_LIST", " WHERE USER_NAME='" + myRow["USER_NAME"] + "' AND STORE_ID ='" + B_STORE_ID + "' AND UPPER(MODULE_NAME) ='MATERIAL TRANSFER'");

                    if (emailID != "")
                    {
                        string str = AmoghPdfMail.SendEmail(emailID, trans_no, uname, userEmail, type_id);
                    }
                }
                string query = "UPDATE PIP_MAT_TRANSF SET STATUS_FLG ='Y' WHERE TRANSF_ID =" + TRANSF_ID;
                WebTools.ExeSql(query);
                Master.ShowSuccess("Email Sent To : " + B_STORE + " Users");
            }
            else
            {
                Master.ShowWarn("Status Already Updated");
            }
        }
        catch (Exception ex)
        {
            Master.ShowMessage(ex.Message);
        }
    }
    protected void btnSendMail_Click(object sender, EventArgs e)
    {
        try
        {
            DataView  dv;
            DataTable dt;
            string    emailID;
            string    mr_no;
            string    type_id              = "1";
            string    uname                = Session["USER_NAME"].ToString().ToUpper();
            string    user_id              = WebTools.GetExpr("USER_ID", "USERS", " WHERE UPPER(USER_NAME)='" + uname + "'");
            string    userEmail            = WebTools.GetExpr("EMAIL", "USERS", " WHERE UPPER(USER_NAME)='" + uname + "'");
            DataSourceSelectArguments args = new DataSourceSelectArguments();
            dv = MailDataSource.Select(args) as DataView;
            dt = dv.ToTable() as DataTable;
            string mr_id = RadGrid1.SelectedValue.ToString();
            mr_no = WebTools.GetExpr("MAT_REQ_NO", "MATERIAL_REQUEST", " WHERE MAT_REQ_ID='" + mr_id + "'");
            string STATUS_FLG = WebTools.GetExpr("STATUS_FLG", "MATERIAL_REQUEST", " WHERE MAT_REQ_ID='" + mr_id + "'");
            if (STATUS_FLG == "N")
            {
                foreach (DataRow myRow in dt.Rows)
                {
                    emailID = WebTools.GetExpr("EMAIL", "USERS_PDF_MAIL_LIST", " WHERE USER_NAME='" + myRow["USER_NAME"] + "' AND UPPER(MODULE_NAME) ='MATERIAL REQUEST'");

                    if (emailID != "")
                    {
                        string str = AmoghPdfMail.SendEmail(emailID, mr_no, uname, userEmail, type_id);
                    }
                }
                string query = "UPDATE MATERIAL_REQUEST SET STATUS_FLG ='Y' WHERE MAT_REQ_ID =" + mr_id;
                WebTools.ExeSql(query);
                Master.ShowSuccess("Email Sent To : WAREHOUSE CENTRE users:");
            }
            else
            {
                Master.ShowWarn("Status Already Updated ");
            }
        }
        catch (Exception ex)
        {
            Master.ShowMessage(ex.Message);
        }
    }