private void button2_Click(object sender, EventArgs e)
{
Rno.Clear();
Lno.Clear();
Date.Clear();
Redate.Clear();
}
private void button3_Click(object sender, EventArgs e)
{
Rno.Clear();
Rname.Clear();
//Rsex.Clear();
//Rdep.Clear();
//Rage.Clear();
//Ldate.Clear();
}
public void FormControls(string CLR)
{
if (CLR == "CLR")
{
Rno.Clear();
RouteName.Clear();
FAmount.Clear();
cmbdestination.Text = "Select";
cmbstartpoint.Text = "Select";
TTime.Clear();
TDistance.Clear();
Arrivaltime.Value = Convert.ToDateTime(DateTime.Now);
Departuretime.Value = Convert.ToDateTime(DateTime.Now);
Rno.Enabled = false;
RouteName.Enabled = false;
FAmount.Enabled = false;
cmbdestination.Enabled = false;
cmbstartpoint.Enabled = false;
Arrivaltime.Enabled = false;
Departuretime.Enabled = false;
btnsave.Enabled = false;
btnedit.Enabled = false;
btndelete.Enabled = false;
btnadd.Enabled = true;
btnfind.Enabled = true;
btngenerate.Enabled = false;
Left1.Enabled = false;
Right1.Enabled = false;
}
if (CLR == "Save")
{
RouteName.Enabled = true;
FAmount.Enabled = true;
cmbdestination.Enabled = true;
cmbstartpoint.Enabled = true;
Arrivaltime.Enabled = true;
Departuretime.Enabled = false;
RouteName.Focus();
btnsave.Enabled = true;
btnadd.Enabled = false;
btnfind.Enabled = false;
btndelete.Enabled = false;
btnedit.Enabled = false;
btngenerate.Enabled = true;
}
}
protected void btn_update_click(object sender, EventArgs e)
{
try
{
q1 = " select COUNT(a.roll_no) as rollnocount,a.roll_no,a.month_year,a.roll_no+'-'+CONVERT(varchar(20), a.month_year)as rollmonthyear from attendance a,Registration r where a.roll_no=r.Roll_No and r.Batch_Year in (2013,2014,2015,2016,2017,2018) group by a.roll_no,a.month_year having count(a.roll_no) > 1";//and month_year =24205 and r.roll_no in('15CS002','13CS005','13CS034','15CS001','15CS002')
ds.Clear(); int rowaffected = 0;
ds = d2.select_method_wo_parameter(q1, "text");
if (ds.Tables[0].Rows.Count > 0)
{
string duplicaterollno = GetSelectedItemsValueAsString(ds, "Roll_no");
string duplicaterollnocomma = GetSelectedItemsValueAsStringcomma(ds, "rollmonthyear");
string monthandyearSingle = GetSelectedItemsValueAsString(ds, "month_year");
string monthandyearcomma = GetSelectedItemsValueAsStringcomma(ds, "month_year");
DataView dv = new DataView(); DataView dv1 = new DataView();
q1 = " select CONVERT(varchar(10), a.Att_CollegeCode) Att_CollegeCode,convert(varchar(10),r.college_code) college_code, * from attendance a,Registration r where a.roll_no=r.Roll_No and r.Batch_Year in (2013,2014,2015,2016,2017,2018) and r.roll_no in('" + duplicaterollno + "') and a.month_year in('" + monthandyearSingle + "') order by r.roll_no";
q1 += " select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='attendance' and column_name <>'roll_no' and column_name<>'month_year' and column_name<>'Att_App_no' and column_name<>'Att_CollegeCode'";
ds.Clear();
ds = d2.select_method_wo_parameter(q1, "text");
if (ds.Tables[0].Rows.Count > 0)
{
string[] rollnoA = duplicaterollnocomma.Split(',');
string sqlcolum = ""; string updatemonthyear = "";
string regclgcode = "";
foreach (string Rno in rollnoA)
{
string[] rollmonyear = Rno.Split('-'); sqlcolum = ""; updatemonthyear = "";
if (rollmonyear.Length > 1)
{
ds.Tables[0].DefaultView.RowFilter = "roll_no ='" + rollmonyear[0].ToString() + "' and month_year='" + rollmonyear[1].ToString() + "'";//Convert.ToString(monthyear[m])
dv = ds.Tables[0].DefaultView;
DataTable temp = dv.ToTable();
if (temp.Rows.Count > 0)
{
foreach (DataRow dr1 in temp.Rows)
{
string attclgcode = Convert.ToString(dr1["Att_CollegeCode"]);
regclgcode = Convert.ToString(dr1["college_code"]);
string monthandyear = Convert.ToString(dr1["month_year"]);
if (attclgcode != regclgcode)
{
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow colname in ds.Tables[1].Rows)
{
string col = Convert.ToString(colname["column_name"]);
temp.DefaultView.RowFilter = col + " is not null and Att_CollegeCode<>college_code";// OR " + col + "='2' OR " + col + "='3' ";
dv1 = temp.DefaultView;
if (dv1.Count > 0)
{
sqlcolum += "," + col + "='" + Convert.ToString(dv1[0][col]).Trim() + "'";
updatemonthyear = "," + monthandyear;
}
}
}
}
}
}
if (sqlcolum.Trim() != "")
{
q1 = " update attendance set " + sqlcolum.TrimStart(',') + " where roll_no='" + rollmonyear[0].ToString() + "' and month_year in(" + updatemonthyear.TrimStart(',') + ") and Att_CollegeCode='" + regclgcode + "'";
rowaffected += d2.update_method_wo_parameter(q1, "text");
}
}
q1 = "";
}
}
}
lbl_error.Text = Convert.ToString("No of Rows Affected (" + rowaffected + ")");
lbl_error.ForeColor = System.Drawing.Color.Green;
}
catch (Exception ex)
{
lbl_error.Text = Convert.ToString(ex);
lbl_error.ForeColor = System.Drawing.Color.Red;
}
}
