public int UpdateRegister(PlRegister pl) { cmd = new SqlCommand("SPRegister", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", pl.Ind); cmd.Parameters.AddWithValue("@Ctrl", pl.Ctrl); cmd.Parameters.AddWithValue("@ExamYear", pl.ExamYear); cmd.Parameters.AddWithValue("@SessionType", pl.Session); cmd.Parameters.AddWithValue("@ExamType", pl.ExamType); cmd.Parameters.AddWithValue("@TRType", pl.FoilCuonterfoil); cmd.Parameters.AddWithValue("@NoOfBooks", pl.NoOfBook); cmd.Parameters.AddWithValue("@CurrentBookNo", pl.CureentBookNo); cmd.Parameters.AddWithValue("@PageNoFrom", pl.PageNoFrom); cmd.Parameters.AddWithValue("@PageNoTo", pl.PageNoTo); cmd.Parameters.AddWithValue("@TotalPages", pl.TotalPage); cmd.Parameters.AddWithValue("@RegisterNo", pl.RegNo); con.Open(); int i = cmd.ExecuteNonQuery(); 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 DataTable UpdateDuplicateRoll(PlRegister PlReg) { return(dl.UpdateDuplicateRoll(PlReg)); }
public DataTable UpdatePages(PlRegister PlReg) { return(dl.UpdatePages(PlReg)); }
public int RegisterEntry(PlRegister pl) { int i = dl.RegisterEntry(pl); return(i); }
public DataTable MoveTrRegisterFiles(PlRegister pl) { return(dl.MoveTrRegisterFiles(pl)); }
public int UpdateRegisterFilePath(PlRegister pl) { int i = dl.UpdateRegisterFilePath(pl); return(i); }
public int InsertAvailablePages(PlRegister pl) { int i = dl.InsertAvailablePageNo(pl); return(i); }
public int CancelRegister(PlRegister pl) { return(dl.CancelRegister(pl)); }
public DataTable SearchRegister(PlRegister pl) { return(dl.SearchRegister(pl)); }
public DataSet ShowBothImages(PlRegister pl) { return(dl.ShowBothImages(pl)); }
public int UpdateRegister(PlRegister pl) { int i = dl.UpdateRegister(pl); return(i); }
public Int64 InsertRegister(PlRegister pl) { Int64 i = dl.InsertRegister(pl); return(i); }
void BindRegister() { if (string.IsNullOrEmpty(txtRegNo.Text)) { lblMsg.Text = "Please Enter Register No."; return; } RightPageNo = new List <int>(); lblMsg.Text = ""; txtRegNo.ReadOnly = false; divHideRegi.Visible = false; pl = new PlRegister() { RegNo = Convert.ToInt64(txtRegNo.Text), }; if (RblRegType.SelectedIndex == 0) { pl.Ind = 24; } else { pl.Ind = 27; } ViewState["DataTable"] = dt = dl.GetPageNo(pl); if (dt.Rows.Count > 0) { //DataTable dtError = dt; if (RblRegType.SelectedIndex == 1) //For Register With In Range { int c = dt.Rows.Count; int pos = 0; for (int i = 0; i < c; i++) { DataRow item = dt.Rows[pos]; string s = item["FoilFilePath"].ToString(); if (string.IsNullOrEmpty(s)) { dt.Rows.RemoveAt(pos); //pos++; continue; } s = s.Substring(s.LastIndexOf("/"), s.LastIndexOf(".") - s.LastIndexOf("/")); s = s.Substring(s.IndexOf("_") + 1, s.LastIndexOf("_") - s.IndexOf("_") - 1); if (Convert.ToInt16(s) == Convert.ToInt16(item["FoilPageNo"])) //For Matching FilePath To Page No { dt.Rows.RemoveAt(pos); } else { pos++; RightPageNo.Add(Convert.ToInt16(s)); } } #region By ForEach //foreach (DataRow item in dt.Rows) //{ // string s = item["FoilFilePath"].ToString(); // s = s.Substring(s.LastIndexOf("/"), s.LastIndexOf(".") - s.LastIndexOf("/")); // s = s.Substring(s.IndexOf("_") + 1, s.LastIndexOf("_") - s.IndexOf("_") - 1); // if (Convert.ToInt16(s) == Convert.ToInt16(item["FoilPageNo"])) // { // dt.Rows[dt.Rows.IndexOf(item)].Delete(); // } //} #endregion } if (dt.Rows.Count <= 0) { AllClear(); lblMsg.Text = "No Data Found!"; return; } gvPages.DataSource = dt; gvPages.DataBind(); txtRegNo.ReadOnly = true; divHideRegi.Visible = true; } else { AllClear(); lblMsg.Text = "No Data Found!"; } }