private Salhead_repo Modify_data_allocation()
{
var gdata = new Salhead_repo {
_id = int.Parse(salheadid.SelectedValue)
};
cmd.CommandText = "SELECT salhead_code,salhead_name,salhead_group_id,salhead_formula,salhead_add_to_salinfo,salhead_start_date FROM salary_head WHERE salhead_id = " + gdata._id + ";";
_sql.Con_switch(con);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
gdata._code = reader["salhead_code"].ToString();
gdata._name = reader["salhead_name"].ToString();
gdata._groupcode = reader["salhead_group_id"].ToString();
gdata._formula = reader["salhead_formula"].ToString();
var a = reader["salhead_add_to_salinfo"].ToString();
if (a == "1")
{
gdata._add_to_salinfo = true;
}
else
{
gdata._add_to_salinfo = false;
}
gdata._startdate = DateTime.Parse(reader["salhead_start_date"].ToString());
}
_sql.Con_switch(con);
gdata._oldname = gdata._name;
return(gdata);
}
private void Insert_data(Salhead_repo ins)
{
cmd.Connection = con;
cmd.CommandText = "INSERT INTO salary_head (salhead_code, salhead_name, salhead_group_id, salhead_formula,salhead_add_to_salinfo, salhead_start_date) VALUES " +
"('" + ins._code + "','" + ins._name + "','" + ins._groupcode + "','" + ins._formula + "'," + ins._add_to_salinfo + ",'"
+ ins._startdate.ToString("yyyy-MM-dd") + "');";
_sql.Con_switch(con);
int r = cmd.ExecuteNonQuery();
cmd.CommandText = "";
_sql.Con_switch(con);
if (r == 1)
{
if (add_checkbox.Checked.Equals(true))
{
try
{
cmd.CommandText = "ALTER TABLE salary_info ADD COLUMN `" + ins._name + "` DECIMAL(20,2);";
_sql.Con_switch(con);
var q = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
cmd.CommandText = "ALTER TABLE salary_generate ADD COLUMN `" + ins._name + "` DECIMAL(20,2);";
_sql.Con_switch(con);
var t = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
if (q == t && q == 1)
{
Response.Write(_response.FL_message("Salary Head " + ins._name.ToUpper() + " Successfully Created...!!!",
"salaryhead.aspx';"));
}
}
catch (MySqlException x)
{
Response.Write(_response.FL_message(x.Code + "\\n\\n" + x.SqlState + "\\n\\n" + x.StackTrace + "\\n\\n" + x.Message));
}
catch (Exception ex)
{
Response.Write(_response.FL_message("Message 1:" + ex.Message));
}
}
else
{
Response.Write(_response.FL_message("Salary Head " + ins._name.ToUpper() + " Successfully Created...!!!",
"salaryhead.aspx';"));
}
}
else
{
Response.Write(_response.FL_message("Salary Head Is Already Present With Name " +
add_name.ToString().ToUpper()));
}
}
private void Set_data_for_updating()
{
char[] a = new char[]
{
'~', '!', '@', '#', '$', '%', '^', '&', '*', '(', ')', '-', '+', '=', '`', '|'
, ';', '"', ':', '>', '?', '<', ',', '.', '{', '}', '[', ']', '/', '*', '-', '+'
};
var set = new Salhead_repo
{
_name = edit_name.Text,
_code = edit_name.Text.Trim(a).Replace(" ", string.Empty),
_formula = edit_formula.Text,
_groupcode = edit_ddl_group.SelectedValue,
_id = int.Parse(salheadid.SelectedValue),
_add_to_salinfo = edit_checkbox.Checked,
_oldname = edit_oldname.Text,
_startdate = DateTime.ParseExact(edit_startdate.Text, "yyyy-MM-dd", null)
};
Update_data(set);
}
private void add_controls_clear()
{
var gdata = new Salhead_repo {
_code = "", _formula = "", _name = "", _groupcode = "", _startdate = DateTime.Today
};
add_code.Text = gdata._code;
add_name.Text = gdata._name;
add_ddl_group.ClearSelection();
try
{
// ReSharper disable once AssignNullToNotNullAttribute
add_ddl_group.Items.FindByValue(gdata._groupcode).Selected = true;
}
catch (Exception cv)
{
Console.WriteLine(cv.Message + enter + spaces + cv.StackTrace + enter + spaces + cv.Data + enter + spaces + cv.HelpLink +
enter + spaces + cv.Source + enter + spaces + cv.HResult + enter + spaces + cv.InnerException);
}
add_formula.Text = gdata._formula;
add_startdate.Text = gdata._startdate.ToString("yyyy-MM-dd");
}
private void Set_data_for_saving()
{
char[] a = new char[]
{
'~', '!', '@', '#', '$', '%', '^', '&', '*', '(', ')', '-', '+', '=', '`', '|'
, ';', '"', ':', '>', '?', '<', ',', '.', '{', '}', '[', ']', '/', '*', '-', '+'
};
var setData = new Salhead_repo
{
_name = add_name.Text,
_code = add_name.Text.Trim(a).Replace(" ", string.Empty),
_groupcode = add_ddl_group.SelectedItem.Value,
_formula = add_formula.Text,
_add_to_salinfo = add_checkbox.Checked,
_startdate = DateTime.Parse(add_startdate.Text)
};
Insert_data(setData);
Listing_add_ddl();
}
private void Update_data(Salhead_repo set)
{
Response.Write(set._id);
cmd.Connection = con;
var cmdtxt = "UPDATE salary_head SET " +
"salhead_code = '" + set._code + "', salhead_name = '" + set._name + "', salhead_group_id = '" +
set._groupcode + "', " +
"salhead_formula = '" + set._formula + "', salhead_add_to_salinfo = " + set._add_to_salinfo + "," +
" salhead_start_date = '" + set._startdate.ToString("yyyy-MM-dd") + "' WHERE salhead_id = " + set._id + "; ";
/*cmd.CommandText = "CALL salary_head_update(" + set._id + ",'" + set._code + "','" + set._name + "','" +
* set._groupcode + "','" + set._formula + "',"+set._add_to_salinfo+",'" + set._startdate.ToString("yyyy-MM-dd") + "');";*/
cmd.CommandText = cmdtxt;
_sql.Con_switch(con);
var r = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
cmd.CommandText = "";
if (r == 1)
{
if (edit_checkbox.Checked.Equals(true))
{
if (_repo.Column_Exists("salary_info", edit_oldname.Text) && _repo.Column_Exists("salary_generate", edit_oldname.Text))
{
var q = 0;
var t = 0;
cmd.CommandText = "ALTER TABLE salary_info CHANGE COLUMN `" + edit_oldname.Text + "` `" + set._name + "` DECIMAL(20,2);";
_sql.Con_switch(con);
q = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
cmd.CommandText = "ALTER TABLE salary_generate CHANGE COLUMN `" + edit_oldname.Text + "` `" + set._name + "` DECIMAL(20,2);";
_sql.Con_switch(con);
t = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
if (q == t && q == 1)
{
Listing_edit_ddl();
Response.Write(_response.FL_message("Salary Head Column " + edit_oldname.Text.ToUpper() + " Changed To" + set._name.ToUpper() +
" Successfully...!!!", "~/salaryhead.aspx"));
}
}
else
{
try
{
var q = 0;
var t = 0;
if (_repo.Column_Exists("salary_info", edit_oldname.Text))
{
cmd.CommandText = "ALTER TABLE salary_info CHANGE COLUMN `" + edit_oldname.Text + "` `" + set._name + "` DECIMAL(20,2);";
_sql.Con_switch(con);
q = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
}
else
{
cmd.CommandText = "ALTER TABLE salary_info ADD COLUMN `" + set._name + "` DECIMAL(20,2);";
_sql.Con_switch(con);
q = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
}
if (_repo.Column_Exists("salary_generate", edit_oldname.Text))
{
cmd.CommandText = "ALTER TABLE salary_generate CHANGE COLUMN `" + edit_oldname.Text + "` `" + set._name + "` DECIMAL(20,2);";
_sql.Con_switch(con);
t = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
}
else
{
cmd.CommandText = "ALTER TABLE salary_generate ADD COLUMN `" + set._name + "` DECIMAL(20,2);";
_sql.Con_switch(con);
t = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
}
if (q == t && t == 1)
{
Response.Write(_response.FL_message("Salary Head " + set._name.ToUpper() + " Successfully Created...!!!",
"salaryhead.aspx';"));
}
}
catch (MySqlException x)
{
Response.Write(_response.FL_message(x.Code + "\\n\\n" + x.SqlState + "\\n\\n" + x.StackTrace + "\\n\\n" + x.Message));
}
catch (Exception ex)
{
Response.Write(_response.FL_message("Message 1:" + ex.Message));
}
}
}
else
{
/*if (_repo.Column_Exists("salary_info", edit_oldname.Text))
* {
* cmd.CommandText = "ALTER TABLE salary_info drop COLUMN `" + edit_oldname.Text + "`;";
* _sql.Con_switch(con);
* var q = cmd.ExecuteNonQuery();
* _sql.Con_switch(con);
* cmd.CommandText = "ALTER TABLE salary_generate drop COLUMN `" + edit_oldname.Text + "`;";
* _sql.Con_switch(con);
* var t = cmd.ExecuteNonQuery();
* _sql.Con_switch(con);
* if (q == t && t == 1)
* {
* Response.Write(_response.FL_message("Salary Head Column " + edit_oldname.Text.ToUpper() +
* " Changed To" + set._name.ToUpper() +
* " Successfully...!!!", "~/salaryhead.aspx"));
* }
* }*/
var q = 0;
var t = 0;
if (_repo.Column_Exists("salary_info", edit_oldname.Text))
{
cmd.CommandText = "ALTER TABLE salary_info drop COLUMN `" + edit_oldname.Text + "`;";
_sql.Con_switch(con);
q = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
}
if (_repo.Column_Exists("salary_generate", edit_oldname.Text))
{
cmd.CommandText = "ALTER TABLE salary_generate drop COLUMN `" + edit_oldname.Text + "`;";
_sql.Con_switch(con);
t = cmd.ExecuteNonQuery();
_sql.Con_switch(con);
}
if (q == t && t == 1)
{
Response.Write(_response.FL_message("Salary Head Column " + edit_oldname.Text.ToUpper() +
" Changed To" + set._name.ToUpper() +
" Successfully...!!!", "~/salaryhead.aspx"));
}
}
}
else
{
Response.Write(_response.FL_message("Salary Head Is Already Present With Name " +
set._name.ToUpper()));
}
}