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