public int InsertCFImgEntry(PlImgEntry pl)
{
cmd = new SqlCommand("SPImgEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@RegNo", pl.RegNo);
cmd.Parameters.AddWithValue("@RollNo", pl.RollNoFrom);
cmd.Parameters.AddWithValue("@RollNoTo", pl.RollNoTo);
cmd.Parameters.AddWithValue("@FilePath", pl.FilePath);
cmd.Parameters.AddWithValue("@CompletedPages", pl.CompletedPages);
cmd.Parameters.AddWithValue("@TotalPages", pl.TotalPages);
cmd.Parameters.AddWithValue("@ErrorMark", pl.ErrorMark);
cmd.Parameters.AddWithValue("@IpAddress", pl.IpAddress);
cmd.Parameters.AddWithValue("@UserID", pl.UserId);
cmd.Parameters.AddWithValue("@CreationDate", pl.CreationDate);
cmd.Parameters.AddWithValue("@AllotmentNo", pl.AllotmentNo);
cmd.Parameters.AddWithValue("@EntryByRegNo", pl.EntryByRegNo);
cmd.Parameters.AddWithValue("@IsUpdated", pl.IsUpdated);
cmd.Parameters.AddWithValue("@UpdatedBy", pl.UpdatedBy);
cmd.Parameters.AddWithValue("@UpdationDate", pl.UpdationDate);
con.Open();
int i = cmd.ExecuteNonQuery();
//Int64 i = Convert.ToInt64(cmd.ExecuteScalar());
con.Close();
return(i);
}
public DataTable GetCompletedPageNo(PlImgEntry pl)
{
DataTable dt = new DataTable();
dt = dl.GetICompetedPages(pl);
return(dt);
}
//////////////
public DataTable SearchStudentDetail(PlImgEntry pl)
{
cmd = new SqlCommand("SPApplicationDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@ExamSession", pl.ExamSession);
cmd.Parameters.AddWithValue("@ExamYear", pl.Examyear);
cmd.Parameters.AddWithValue("@Rollno", pl.RollNo);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
if (Convert.ToInt32(dt.Rows[0]["RollNo"]) == 0)
{
dt = null;
}
}
else
{
dt = null;
}
return(dt);
}
DataTable GetCompletedPageNo()
{
plImg = new PlImgEntry()
{
Ind = 2,
RegNo = Convert.ToInt64(txtRegNo.Text),
};
dt = new DataTable();
dt = dlImg.GetICompetedPages(plImg);
return(dt);
}
public DataSet LastPageNoWithLotNo(PlImgEntry pl)
{
cmd = new SqlCommand("SPRegister", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@RegisterNo", pl.RegNo);
cmd.Parameters.AddWithValue("@UserId", pl.UserId);
ds = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
return(ds);
}
public int GetICompetedPages(PlImgEntry pl)
{
cmd = new SqlCommand("SPImgEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@RegNo", pl.RegNo);
con.Open();
int i = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return(i);
}
public DataTable GetICompetedPages(PlImgEntry pl)
{
cmd = new SqlCommand("SPImgEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@RegNo", pl.RegNo);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
ad.Fill(dt);
return(dt);
//con.Open();
//int i = Convert.ToInt32(cmd.ExecuteScalar());
//con.Close();
// return i;
}
public Int64 LastRollNo(PlImgEntry pl)
{
cmd = new SqlCommand("SPImgEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@RegNo", pl.RegNo);
con.Open();
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0 && dt != null)
{
pl.roll
= Convert.ToInt64(dt.Rows[0][0]);
}
else
{
pl.roll = 0;
}
con.Close();
return(pl.roll);
}
//////////////Changes In DL File
public int InsertFoilImgEntryPageWise(PlImgEntry pl)
{
cmd = new SqlCommand("SPImgEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@RegNo", pl.RegNo);
cmd.Parameters.AddWithValue("@PhyPageno", pl.PhyPageno);
cmd.Parameters.AddWithValue("@RollNo", pl.RollNoFrom);
cmd.Parameters.AddWithValue("@RollNoTo", pl.RollNoTo);
cmd.Parameters.AddWithValue("@FilePath", pl.FilePath);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0 && dt != null)
{
i = Convert.ToInt16(dt.Rows[0][0]);
}
//i = Convert.ToInt16(dt.Rows[0]["value"]);
con.Close();
return(i);
}
protected void btnSearchImg_Click(object sender, EventArgs e)
{
if (txtRegNo.Text == string.Empty)
{
lblError.Text = "Please Enter Register No.";
txtRegNo.Focus();
return;
}
plImg = new PlImgEntry()
{
Ind = 12,
RegNo = Convert.ToInt64(txtRegNo.Text),
UserId = Convert.ToInt32(Session["UserId"]),
};
plReg = new PlRegister()
{
Ind = 11,
RegNo = Convert.ToInt64(txtRegNo.Text)
};
if (Session["UserId"].ToString() != "1")
{
ds = new DataSet();
ds = dlImg.LastPageNoWithLotNo(plImg);
if (ds.Tables[0].Rows.Count <= 0)
{
lblError.Text = "Entered Register No. Not Assign In Your Lot";
return;
}
//lblLotNo.Text = ds.Tables[0].Rows[0][0].ToString();
if (ds.Tables[1].Rows.Count > 0)
{
}
}
}
public int InserImgEntry(PlImgEntry pl)
{
cmd = new SqlCommand("SPImgEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@RegNo", pl.RegNo);
cmd.Parameters.AddWithValue("@RollNo", pl.RollNo);
cmd.Parameters.AddWithValue("@SName", pl.SName);
cmd.Parameters.AddWithValue("@FilePath", pl.FilePath);
cmd.Parameters.AddWithValue("@CompletedPages", pl.CompletedPages);
cmd.Parameters.AddWithValue("@TotalPages", pl.TotalPages);
cmd.Parameters.AddWithValue("@ErrorMark", pl.ErrorMark);
cmd.Parameters.AddWithValue("@IpAddress", pl.IpAddress);
cmd.Parameters.AddWithValue("@UserID", pl.UserId);
cmd.Parameters.AddWithValue("@CreationDate", pl.CreationDate);
cmd.Parameters.AddWithValue("@AllotmentNo", pl.AllotmentNo);
cmd.Parameters.AddWithValue("@EntryByRegNo", pl.EntryByRegNo);
cmd.Parameters.AddWithValue("@IsUpdated", pl.IsUpdated);
cmd.Parameters.AddWithValue("@UpdatedBy", pl.UpdatedBy);
// cmd.Parameters.AddWithValue("@UpdationDate", pl.UpdationDate);
cmd.Parameters.AddWithValue("@PhyPageno", pl.PhyPageno);
cmd.Parameters.AddWithValue("@IsDataVerified", pl.verifydata);
con.Open();
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataTable dt = new DataTable();
//da.Fill(dt);
//if (dt.Rows.Count > 0 && dt != null)
//{
//i=Convert.ToInt16(dt.Rows[0]["value"]);
//}
int i = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return(i);
}
public int DeletePageNoData(PlImgEntry pl)
{
int i = dl.DeletePageNoData(pl);
return(i);
}
public DataSet LastPageNoWithLotNo(PlImgEntry pl)
{
return(dl.LastPageNoWithLotNo(pl));
}
public int GetCompletedPageNo(PlImgEntry pl)
{
int i = dl.GetICompetedPages(pl);
return(i);
}
public int InsertCFImgEntry(PlImgEntry pl)
{
int i = dl.InsertCFImgEntry(pl);
return(i);
}
public DataTable SearchStudentDetail(PlImgEntry pl)
{
DataTable dt = new DataTable();
return(dt = dl.SearchStudentDetail(pl));
}
