protected void btnYes_Click(object sender, EventArgs e)
{
try
{
PlFU = new PlUpload();
PlFU.ExamYear = Convert.ToInt32(ddlExamName.SelectedItem.Text);
PlFU.ExamSession = ddlSession.SelectedItem.Text;
//PlFU.tableName = "TblUniversityData_" + PlFU.ExamSession + "_" + PlFU.ExamYear + "_RD";
bool tblCount = dlFU.CheckRDRL(PlFU);
if (tblCount)
{
DataSet ds = dlFU.CreateRDRL(PlFU);
if (ds.Tables.Count != 2)
{
}
}
}
catch (Exception ex)
{
}
finally
{
ClearAll();
}
}
protected void btnYes_Click(object sender, EventArgs e)
{
try
{
PlFU = new PlUpload();
PlFU.ExamYear = Convert.ToInt32(ddlExamYear.SelectedItem.Text);
PlFU.ExamSession = ddlSession.SelectedItem.Text;
//PlFU.tableName = "TblUniversityData_" + PlFU.ExamSession + "_" + PlFU.ExamYear + "_RD";
DataRow[] row = VsdtExamCategory.Select("ExamTypeID='" + ddlExamCategory.SelectedValue + "'");
if (row.Count() > 0)
{
int gradeExam = Convert.ToInt16(row[0]["GradeExam"]);
if (gradeExam == 1)
{
if (ddlExamCategory.SelectedItem.Text == "CBCS" || ddlExamCategory.SelectedItem.Text == "MECG")
{
PlFU.Ind = 61;
}
else if (ddlExamCategory.SelectedItem.Text == "ENCG" || ddlExamCategory.SelectedItem.Text == "HSC")
{
PlFU.Ind = 62;
}
PlFU.ExamCategory = ddlExamCategory.SelectedItem.Text;
}
else if (gradeExam == 0)
{
bool tblCount = dlFU.CheckRDRL(PlFU);
if (tblCount)
{
}
PlFU.Ind = 6;
}
DataSet ds = dlFU.CreateRDRL(PlFU);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
lblMsg.Text = "Data Merge Successfully.";
lblMsg.Style.Add("color", "#1e983b");
ClearAll();
}
else
{
lblMsg.Text = "Data Not Merge Successfully.";
lblMsg.Style.Add("color", "red");
}
}
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
lblMsg.Style.Add("color", "red");
confirmationModal.Style.Add("display", "none");
}
}
public DataTable GetExamName(PlUpload Plobjfu)
{
cmd = new SqlCommand("SPGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 3);
dt = new DataTable();
sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
return(dt);
}
public void TruncateTable(PlUpload PlFU)///
{
cmd = new SqlCommand("SPFileUpload", LocalCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 2);
cmd.Parameters.AddWithValue("@tableName", PlFU.tableName);
LocalCon.Open();
cmd.ExecuteNonQuery();
LocalCon.Close();
}
public void DeleteData(PlUpload PlFU)
{
cmd = new SqlCommand("SPFileUpload", LocalCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 4);
cmd.Parameters.AddWithValue("@TableName", PlFU.tableName);
cmd.Parameters.AddWithValue("@FileName", PlFU.FileName);
dt = new DataTable();
sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
}
public DataSet CreateRDRL(PlUpload PlFU)
{
cmd = new SqlCommand("SPFileUpload", LocalCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@Ind", 6);
cmd.Parameters.AddWithValue("@ExamYear", PlFU.ExamYear);
cmd.Parameters.AddWithValue("@ExamSession", PlFU.ExamSession);
DataSet ds = new DataSet();
sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
return(ds);
}
void UploadDataTable(StructUpload StructObj)
{
try
{
PlFU = new PlUpload();
PlFU.tableName = StructObj.TableName;
bool tblCount = dlFU.CheckTable(PlFU);
string Query = "";
int count = 0;
if (tblCount == false)
{
Query += "Create Table " + PlFU.tableName + "(";
foreach (DataColumn item in StructObj.BulkDT.Columns)
{
Query += item + " varchar(130)";
count++;
Query += ", ";
}
Query += ")";
int Status = dlFU.DynamicTable(Query);
}
PlFU.FileName = StructObj.FileName;
bool status = dlFU.FileNameCheck(PlFU);
if (status == true)
{
dlFU.DeleteData(PlFU);
}
dlFU.BulkDataInsert(StructObj.BulkDT, StructObj.TableName);
}
catch (Exception ex)
{
if (DtErrorFILE == null)
{
DtErrorFILE = ErrorData();
}
DataRow dr = DtErrorFILE.NewRow();
dr["ExcelName"] = StructObj.FileName;
dr["TableName"] = StructObj.TableName;
dr["Exception"] = ex.Message;
DtErrorFILE.Rows.Add(dr);
//lblException.Text += "<i class='fa fa-frown-o'></i> " + ++errorCount + ". ";
//lblException.Text += "Problem In File Please Check File - " + StructObj.FileName + " This Is Not Create Because of - <br />" + ex.Message + "<br />";
//continue;
}
}
public DataSet UniversityAndOccplBind(PlUpload PlFU)
{
ds = new DataSet();
cmd = new SqlCommand("SPFileUpload", LocalCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 10);
cmd.Parameters.AddWithValue("@ExamSession", PlFU.ExamSession);
cmd.Parameters.AddWithValue("@ExamYear", PlFU.ExamYear);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds = null);
}
public bool CheckTable(PlUpload PlFU)//
{
cmd = new SqlCommand("SPFileUpload", LocalCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 2);
cmd.Parameters.AddWithValue("@TableName", PlFU.tableName);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
//int i;
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
return(true);
//i = dt.Rows.Count;
}
else
{
return(false);
//i = 0;
}
//return i;
}
public bool FileNameCheck(PlUpload PlFU)
{
cmd = new SqlCommand("SPFileUpload", LocalCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 3);
cmd.Parameters.AddWithValue("@TableName", PlFU.tableName);
cmd.Parameters.AddWithValue("@FileName", PlFU.FileName);
dt = new DataTable();
sda = new SqlDataAdapter(cmd);
bool i;
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
i = true;
}
else
{
i = false;
}
return(i);
}
