private void Dynamiccontrols()
{
try
{
cmd.Connection = con;
//cmd.CommandText = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='payroll_db' AND TABLE_NAME='salary_info' AND COLUMN_NAME NOT IN (SELECT 'id');";
cmd.CommandText = "SELECT salhead_name FROM salary_head;";
_sql.Con_switch(con);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string a = reader["salhead_name"].ToString();
salgen.Controls.Add(FL_Label_TextBox.FL_label_readonly_textbox_default(a));
}
reader.Close();
_sql.Con_switch(con);
}
catch (MySqlException)
{
Response.Write(_response.FL_message("Sorry..!! Unable to create the form. Please contact your developer for help."));
}
}
private void Dynamiccontrols()
{
try
{
var Count = cmd.Head_Count_DB(con, "attendance", "payroll_db", "id");
var ControlIds = cmd.Get_ControlIds_DB(con, "attendance", "payroll_db", "id");
for (var B = 0; B <= (Count - 1); B++)
{
if (ControlIds[B].Equals("Attendance"))
{
attendance_form.Controls.Add(FL_Label_CheckBox.FL_label_readonly_checkbox(ControlIds[B]));
}
else if (ControlIds[B].Equals("Date"))
{
attendance_form.Controls.Add(FL_Label_TextBox.FL_label_textbox_date(ControlIds[B]));
_controls.FL_SetControlString(attendance_form, ControlIds[B], DateTime.Now.ToString("yyyy-MM-dd"));
}
}
}
catch (Exception)
{
Response.Write(_response.FL_message("Sorry..!! Unable to create the form. Please contact your developer for help."));
}
}
private void get_value(string id)
{
if (!String.Equals(id, "0"))
{
var count = cmd.Head_Count_Salhead(con);
var controlids = cmd.get_ControlIds_Salhead(con);
var ids = cmd.Get_Ids_Salhead(con);
var groups = new string[count];
var sign = new string[count];
var amts = new double[count];
var formula = new string[count];
for (var i = 0; i <= (count - 1); i++)
{
cmd.CommandText =
"SELECT salhead_formula, salhead_group_id, group_name, group_code FROM salary_head LEFT JOIN head_group ho on salary_head.salhead_group_id = ho.group_id WHERE salhead_name = '" + ids[i] +
"';";
_sql.Con_switch(con);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
formula[i] = reader["salhead_formula"].ToString();
sign[i] = reader["group_code"].ToString();
}
reader.Close();
reader.Dispose();
_sql.Con_switch(con);
}
formula = rectified_formula(formula);
for (var i = 0; i <= (count - 1); i++)
{
Response.Write(_response.FL_printmessage_to_webpage(formula[i]));
cmd.CommandText = "SELECT " + formula[i] + " AS `" + ids[i] + "` FROM salary_info WHERE id=" +
int.Parse(id) + ";";
_sql.Con_switch(con);
var reader1 = cmd.ExecuteReader();
while (reader1.Read())
{
var a = reader1[ids[i]].ToString();
if (string.IsNullOrEmpty(a))
{
a = "0.00";
}
amts[i] = Math.Round(double.Parse(a), 2, MidpointRounding.AwayFromZero);
Response.Write(_response.FL_printmessage_to_webpage("<br/>" + formula[i]) + " " + amts[i]);
}
reader1.Close();
reader1.Dispose();
_sql.Con_switch(con);
if (!string.IsNullOrEmpty(amts[i].ToString()) && !string.Equals(amts[i].ToString(), "0"))
{
salgen.Controls.Add(FL_Label_TextBox.FL_label_readonly_textbox_default(ids[i]));
((TextBox)_controls.FL_GetChildControl(salgen, controlids[i])).Text = amts[i].ToString();
}
}
var amt = "";
double attendance = attendence_calc.attendence_month(con, cmd, int.Parse(id), set_date.Text.ToString());
double days = attendence_calc.no_days_month(con, cmd, set_date.Text);
for (var i = 0; i < (count - 1); i = i + 2)
{
if (i == 0)
{
amt = amt + sign[i] + precision_point((amts[i] * attendance / days)) + sign[i + 1] + precision_point(amts[i + 1]);
}
else
{
amt = amt + sign[i] + precision_point(amts[i]) + sign[i + 1] + precision_point(amts[i + 1]);
}
}
Response.Write(amt);
var val = FL_MathExpression.FL_Result(amt).ToString();
double final_salary = double.Parse(val);
if (!String.IsNullOrEmpty(amt) && !string.Equals(val, "0"))
{
salgen.Controls.Add(FL_Label_TextBox.FL_label_readonly_textbox_default("Total Salary"));
((TextBox)_controls.FL_GetChildControl(salgen, "TotalSalary")).Text = Math.Round(final_salary, 2, MidpointRounding.AwayFromZero).ToString();
}
}
}
