public partial class Reports_SamplePrepration : System.Web.UI.Page
{
SqlConnection con;
int PageNum = 1;
//GridView gv = new GridView();
String strConn = ConfigurationManager.ConnectionStrings["ConOrms"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// ShowData(1);
}
}
protected void ShowData(int PageNum)
{
int WOID = Convert.ToInt32(ViewState["WoidForBindData"]);
DataSet dsSmplPrep = new DataSet(); //WR_TRF.GetTRFReport(BranchID, FromDate, ToDate, Convert.ToInt16(SessionManager.Instance.RoleId),txtTRFno.Text.Trim());
DataTable dtSmplPrep = new DataTable();
try
{
using (SqlConnection con = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand("VVS_SAMPLE_PREPARARION", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@WOID", SqlDbType.Int).Value = WOID;
cmd.CommandTimeout = 999999;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dtSmplPrep);
}
}
}
catch (Exception ex)
{
}
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
if (dtSmplPrep != null)
{
if (dtSmplPrep.Rows.Count > 0)
{
dt = dtSmplPrep;
// DataRow dr = null;
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
BoundField boundField = new BoundField();
boundField.DataField = dt.Columns[i].ColumnName.ToString();
boundField.HeaderText = dt.Columns[i].ColumnName.ToString();
grdsampleprep.Columns.Add(boundField);
// dt1.Columns.Add(new DataColumn(dt.Columns[i].ColumnName, typeof(string)));
}
}
}
}
}
//PlaceHolder1.Controls.Add(gv);
BindGridView(grdsampleprep, dt);
}
static DataTable ListToDataTable<T>(IEnumerable<T> list)
{
var dt = new DataTable();
foreach (var info in typeof(T).GetProperties())
{
dt.Columns.Add(new DataColumn(info.Name, info.PropertyType));
}
foreach (var t in list)
{
var row = dt.NewRow();
foreach (var info in typeof(T).GetProperties())
{
row[info.Name] = info.GetValue(t, null);
}
dt.Rows.Add(row);
}
return dt;
}
private void BindGridView(GridView gv, DataTable dt)
{
gv.DataSource = dt;
gv.DataBind();
}
protected void gvPager_Paging_Click(object sender, CommandEventArgs e)
{
}
#region AutoComplete Work order No
[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static List<string> SearchWO(string prefixText, int count)
{
List<string> customers = new List<string>();
string Item = string.Empty;
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConOrms"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetWoIdBySearchText";
cmd.Parameters.Add("@SearchText", SqlDbType.NVarChar).Value = prefixText;
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
Item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(sdr["JobOrderNo"].ToString(), sdr["WOID"].ToString());
customers.Add(Item);
}
}
con.Close();
}
}
}
catch (Exception ex)
{
}
return customers;
}
#endregion
protected void txtWorkOrderNo_TextChanged(object sender, EventArgs e)
{
int Woid = 0;
//string WONO= txtTextingWO.Text;
//GetEditWorkOrder(GetWorkOrderID(WONO));
if (txtWorkOrderNo.Text != string.Empty)
{
try
{
string[] FindValue = txtWorkOrderNo.Text.Trim().Split(';');
if (FindValue.Length > 1)
{
Woid = Convert.ToInt32(FindValue[1].ToString());
ViewState["WoidForBindData"] = Woid;
}
txtWorkOrderNo.Text = FindValue[0].ToString();
}
catch (Exception ex) { }
}
}
protected void btnInspectionCodeTagging_Click(object sender, EventArgs e)
{
ShowData(1);
}
protected void grdsampleprep_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int index = e.Row.RowIndex;
int indexcell = e.Row.Cells.Count - 1;
GridView sendingGridView = (GridView)sender;
for (int j = 4; j <= indexcell; j++)
{
PlaceHolder pl = new PlaceHolder();
pl.ID = e.Row.Cells[j].Text;
if (e.Row.Cells[j].Text != " ")
{
//e.Row.Cells[j].Attributes["onclick"] = Page.ClientScript.GetPostBackClientHyperlink(this.gv, "Select$" + e.Row.RowIndex);
//e.Row.Cells[j].Attributes["style"] = "cursor:pointer";
string code = e.Row.Cells[j].Text;
QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeData qrCodeData = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.Q);
QRCode qrCode = new QRCode(qrCodeData);
System.Web.UI.WebControls.ImageButton imgBarCode = new System.Web.UI.WebControls.ImageButton();
imgBarCode.ID = "imgBarCode" + j;
imgBarCode.Click += OnLinkClick;
ImageButton lb3 = e.Row.FindControl(imgBarCode.ID) as ImageButton;
if (lb3 != null)
ScriptManager.GetCurrent(this).RegisterPostBackControl(lb3);
imgBarCode.Height = 60;
imgBarCode.Width = 60;
using (Bitmap bitMap = qrCode.GetGraphic(20))
{
using (MemoryStream ms = new MemoryStream())
{
bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
byte[] byteImage = ms.ToArray();
imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
//imgBarCode.OnClientClick="return PrintPanel();";
//imgBarCode.PostBackUrl = "QRCodePrint.aspx?index=" + index + "&code=" + code.ToString();
//imgBarCode.Attributes.Add("onclick", "javascript:PrintPanel("+ byteImage + "); return false;");
}
pl.Controls.Add(imgBarCode);
}
//e.Row.Attributes.Add("onclick", Page.ClientScript.GetPostBackClientHyperlink((GridView)sender, "Select$" + e.Row.RowIndex));
}
e.Row.Cells[j].Controls.Add(pl);
}
}
}
protected void PopupClose1_Click(object sender, ImageClickEventArgs e)
{
// ShowData(1);
modalBackground.Attributes.Add("style", "display:none");
divPrint.Attributes.Add("style", "display:none");
}
protected void grdsampleprep_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int index = e.Row.RowIndex;
int indexcell = e.Row.Cells.Count - 1;
GridView sendingGridView = (GridView)sender;
for (int j = 4; j <= indexcell; j++)
{
PlaceHolder pl = new PlaceHolder();
pl.ID = e.Row.Cells[j].Text;
if (e.Row.Cells[j].Text != " ")
{
string code = e.Row.Cells[j].Text;
QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeData qrCodeData = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.Q);
QRCode qrCode = new QRCode(qrCodeData);
System.Web.UI.WebControls.ImageButton imgBarCode = new System.Web.UI.WebControls.ImageButton();
imgBarCode.ID = "imgBarCode" + j;
imgBarCode.CommandArgument = code;
imgBarCode.Click += OnLinkClick;
ImageButton lb3 = e.Row.FindControl(imgBarCode.ID) as ImageButton;
if (lb3 != null)
ScriptManager.GetCurrent(this).RegisterPostBackControl(lb3);
imgBarCode.Height = 60;
imgBarCode.Width = 60;
using (Bitmap bitMap = qrCode.GetGraphic(20))
{
using (MemoryStream ms = new MemoryStream())
{
bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
byte[] byteImage = ms.ToArray();
imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
//imgBarCode.Attributes.Add("onclick", "javascript:PrintPanel(" + byteImage + "); return false;");
}
pl.Controls.Add(imgBarCode);
}
}
else
{
string code= e.Row.Cells[j].Text;
}
e.Row.Cells[j].Controls.Add(pl);
}
}
}
protected void OnLinkClick(object sender, EventArgs e)
{
ImageButton lb = (ImageButton)sender;
GridViewRow row = (GridViewRow)lb.NamingContainer;
string code = lb.CommandArgument;
if (row != null)
{
modalBackground.Attributes.Add("style", "display:block");
divPrint.Attributes.Add("style", "display:block");
QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeData qrCodeData = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.Q);
QRCode qrCode = new QRCode(qrCodeData);
System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();
imgBarCode.Height = 200;
imgBarCode.Width = 200;
using (Bitmap bitMap = qrCode.GetGraphic(20))
{
using (MemoryStream ms = new MemoryStream())
{
bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
byte[] byteImage = ms.ToArray();
imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
}
plBarCode.Controls.Add(imgBarCode);
}
}
----------------My UI