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!";
}
}
