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)); }