public void CheckDataProcess_PF_Monthly(object sender, EventArgs e) { if (!string.IsNullOrEmpty(TextMonthYear0.Text)) { alert_box.Visible = false; OracleConnection conn = new OracleConnection(strConnString); conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; string MakeAsOnDate = TextMonthYear0.Text; string[] MakeAsOnDateSplit = MakeAsOnDate.Split('-'); String AsOnDateTemp = MakeAsOnDateSplit[0].Replace("/", "-"); DateTime AsOnDateNewD = DateTime.ParseExact(AsOnDateTemp, "MM-yyyy", CultureInfo.InvariantCulture); DateTime LastDateTemp = AsOnDateNewD.AddMonths(1).AddDays(-1); string LastDate = LastDateTemp.ToString("dd-MM-yyyy"); cmd.CommandText = "select ITEM_ID from PF_RM_STOCK_INVENTORY_HISTORY where TO_CHAR(TO_DATE(CREATE_DATE), 'dd-mm-YYYY') = '" + LastDate + "'"; cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> Already Data Process for this Month (" + TextMonthYear0.Text + ")</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Red; TextMonthYear0.Focus(); BtnDataProcPf.Attributes.Add("aria-disabled", "false"); BtnDataProcPf.Attributes.Add("class", "btn btn-warning disabled"); } else { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa fa-check'></i> No Data Process for this Month (" + TextMonthYear0.Text + ")</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Green; BtnDataProcPf.Attributes.Add("aria-disabled", "true"); BtnDataProcPf.Attributes.Add("class", "btn btn-warning active"); } } else { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> Month is not blank</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Red; TextMonthYear0.Focus(); } }
public void TextMonthYear0_TextChanged(object sender, EventArgs e) { try{ if (!string.IsNullOrEmpty(TextMonthYear0.Text)) { alert_box.Visible = false; OracleConnection conn = new OracleConnection(strConnString); conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "select MONTH_YEAR from PF_MONTHLY_TARGET where ITEM_ID = '" + DropDownItemID.Text + "' and TO_CHAR(TO_DATE(MONTH_YEAR), 'mm/YYYY') = '" + TextMonthYear0.Text + "'"; cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> This Item Business Target already insert for this Month</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Red; TextMonthYear0.Focus(); BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); } else { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa fa-check'></i> This Item Business Target this Month Data is not entry</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Green; BtnAdd.Attributes.Add("aria-disabled", "true"); BtnAdd.Attributes.Add("class", "btn btn-primary active"); } } else { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> This Item Business Target is not blank</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Red; TextMonthYear0.Focus(); } } catch { Response.Redirect("~/ParameterError.aspx"); } }
public void TextMonthYear0_TextChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(TextMonthYear0.Text)) { alert_box.Visible = false; OracleConnection conn = new OracleConnection(strConnString); conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "select MONTH_YEAR from PF_PROCESSING_COST where TO_CHAR(TO_DATE(MONTH_YEAR), 'mm/YYYY') = '" + TextMonthYear0.Text + "'"; cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> This Month Data is already entry</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Red; TextMonthYear0.Focus(); BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); } else { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa fa-check'></i> This Month Data is not entry</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Green; BtnAdd.Attributes.Add("aria-disabled", "true"); BtnAdd.Attributes.Add("class", "btn btn-primary active"); } } else { CheckMonthYear.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> Customer name is not blank</label>"; CheckMonthYear.ForeColor = System.Drawing.Color.Red; TextMonthYear0.Focus(); } }