public string UpdateBarcodeLabel(DTO.BacodeLable ob)
{
string res = "";
SqlCommand CMD = new SqlCommand();
CMD.CommandText = "Proc_BarCodeLabels";
CMD.CommandType = CommandType.StoredProcedure;
CMD.Parameters.AddWithValue("@BookingNo", ob.BNO);
CMD.Parameters.AddWithValue("@RowIndex", ob.RowIndex);
CMD.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(CMD);
return(res);
}
public DataSet SearchBarcodeLabel(DTO.BacodeLable ob)
{
DataSet ds = new DataSet();
SqlCommand CMD = new SqlCommand();
CMD.CommandText = "Proc_BarCodeLabels";
CMD.CommandType = CommandType.StoredProcedure;
//CMD.Parameters.AddWithValue("@BookingNo", ob.BNO);
//CMD.Parameters.AddWithValue("@RowIndex", ob.RowIndex);
CMD.Parameters.AddWithValue("@Flag", 6);
ds = PrjClass.GetData(CMD);
return(ds);
}
protected void Page_Load(object sender, EventArgs e)
{
//----------------------------
SetfetchValue();
DataSet dset = new DataSet();
dset = BAL.BALFactory.Instance.BAL_Sticker.fetchbarcodeconfig(Ob);
bool barcodebookingno = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodebookingno"].ToString());
string bookingfont = dset.Tables[0].Rows[0]["bookingfont"].ToString();
string bookingsize = dset.Tables[0].Rows[0]["bookingsize"].ToString() + "pt";
string bookingalign = dset.Tables[0].Rows[0]["bookingalign"].ToString();
string bookingbold = dset.Tables[0].Rows[0]["bookingbold"].ToString();
string bookingitilic = dset.Tables[0].Rows[0]["bookingitilic"].ToString();
string bookingunderline = dset.Tables[0].Rows[0]["bookingunderline"].ToString();
bool barcodeprocess = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodeprocess"].ToString());
bool barcodexteraprocess = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodexteraprocess"].ToString());
bool barcodeextraprocesssecond = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodeextraprocesssecond"].ToString());
bool barcodesubtotal = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodesubtotal"].ToString());
string processfont = dset.Tables[0].Rows[0]["processfont"].ToString();
string processsize = dset.Tables[0].Rows[0]["processsize"].ToString() + "pt";
string processalign = dset.Tables[0].Rows[0]["processalign"].ToString();
string processbold = dset.Tables[0].Rows[0]["processbold"].ToString();
string processitalic = dset.Tables[0].Rows[0]["processitalic"].ToString();
string processunderline = dset.Tables[0].Rows[0]["processunderline"].ToString();
bool barcoderemark = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcoderemark"].ToString());
bool barcodecolour = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodecolour"].ToString());
string remarkfont = dset.Tables[0].Rows[0]["remarkfont"].ToString();
string remarksize = dset.Tables[0].Rows[0]["remarksize"].ToString() + "pt";
string remarkremarkalign = dset.Tables[0].Rows[0]["remarkremarkalign"].ToString();
string remarkbold = dset.Tables[0].Rows[0]["remarkbold"].ToString();
string remarkitalic = dset.Tables[0].Rows[0]["remarkitalic"].ToString();
string remarkunderline = dset.Tables[0].Rows[0]["remarkunderline"].ToString();
bool barcodeprint = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodeprint"].ToString());
// string barcodesize = dset.Tables[0].Rows[0]["barcodesize"].ToString();
string barcodealign = dset.Tables[0].Rows[0]["barcodealign"].ToString();
bool barcodeitem = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodeitem"].ToString());
bool barcodeduedate = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodeduedate"].ToString());
bool barcodetime = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodetime"].ToString());
string itemfont = dset.Tables[0].Rows[0]["itemfont"].ToString();
string itemsize = dset.Tables[0].Rows[0]["itemsize"].ToString() + "pt";
string itembold = dset.Tables[0].Rows[0]["itembold"].ToString();
string itemitalic = dset.Tables[0].Rows[0]["itemitalic"].ToString();
string itemalign = dset.Tables[0].Rows[0]["itemalign"].ToString();
string itemunderline = dset.Tables[0].Rows[0]["itemunderline"].ToString();
bool barcodecustomer = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodecusname"].ToString());
string customerfont = dset.Tables[0].Rows[0]["cusfont"].ToString();
string customersize = dset.Tables[0].Rows[0]["cussize"].ToString() + "pt";
string customeralign = dset.Tables[0].Rows[0]["cusalign"].ToString();
string customerbold = dset.Tables[0].Rows[0]["cusbold"].ToString();
string customeritilic = dset.Tables[0].Rows[0]["cusitalic"].ToString();
string customerunderline = dset.Tables[0].Rows[0]["cusunderline"].ToString();
string bookingnoposition = dset.Tables[0].Rows[0]["bookingnoposition"].ToString();
string customerposition = dset.Tables[0].Rows[0]["cusposition"].ToString();
string processposition = dset.Tables[0].Rows[0]["processposition"].ToString();
string remarkposition = dset.Tables[0].Rows[0]["remarkposition"].ToString();
string barcodeposition = dset.Tables[0].Rows[0]["barcodeposition"].ToString();
string itemposition = dset.Tables[0].Rows[0]["itemposition"].ToString();
string addressposition = dset.Tables[0].Rows[0]["Addressposition"].ToString();
bool barcodeaddress = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodeaddress"].ToString());
string addressfont = dset.Tables[0].Rows[0]["addfont"].ToString();
string addresssize = dset.Tables[0].Rows[0]["addsize"].ToString() + "pt";
string addressalign = dset.Tables[0].Rows[0]["addalign"].ToString();
string addressbold = dset.Tables[0].Rows[0]["addbold"].ToString();
string addressitilic = dset.Tables[0].Rows[0]["additalic"].ToString();
string addressunderline = dset.Tables[0].Rows[0]["addunderline"].ToString();
bool barcodedivider = Convert.ToBoolean(dset.Tables[0].Rows[0]["barcodedivider"].ToString());
//-----------------------------
string res = string.Empty;
BarcodeLable = new DTO.BacodeLable();
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
cmd.CommandText = "Proc_BarCodeLabels";
cmd.CommandType = CommandType.StoredProcedure;
ds1 = BAL.BALFactory.Instance.BAL_BarcodeLable.SearchBarcodeLabel(BarcodeLable);
var redirectURL = Request.QueryString["RedirectBack"] as string;
if (redirectURL != null)
{
if (redirectURL.ToString().IndexOf("Factory") != -1)
{
cmd.Parameters.AddWithValue("@Flag", 15);
}
else
{
cmd.Parameters.AddWithValue("@Flag", 4);
}
}
else
{
cmd.Parameters.AddWithValue("@Flag", 4);
}
cmd.Parameters.AddWithValue("@branchid", Globals.BranchID);
ds = AppClass.GetData(cmd);
if (ds.Tables[0].Rows.Count > 0)
{
ReportViewer1.LocalReport.ReportPath = "RDLC/DynamicBarCodeReport.rdlc";
ReportDataSource rds = new ReportDataSource();
rds.Name = "DataSet1";
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
BarcodeLable.BNO = ds1.Tables[0].Rows[i]["BookingNo"].ToString();
BarcodeLable.RowIndex = ds1.Tables[0].Rows[i]["RowIndex"].ToString();
res = BAL.BALFactory.Instance.BAL_BarcodeLable.UpdateBarcodeLabel(BarcodeLable);
}
ReportParameter[] parameters = new ReportParameter[30];
if (barcodecustomer == true)
{
parameters[0] = new ReportParameter("cusfont", customerfont);
parameters[1] = new ReportParameter("cussize", customersize);
parameters[3] = new ReportParameter("cusbold", customerbold);
parameters[4] = new ReportParameter("cusitalic", customeritilic);
parameters[5] = new ReportParameter("cusunderline", customerunderline);
parameters[2] = new ReportParameter("cusalign", customeralign);
}
else
{
parameters[0] = new ReportParameter("cusfont", bookingfont);
parameters[1] = new ReportParameter("cussize", bookingsize);
parameters[3] = new ReportParameter("cusbold", bookingbold);
parameters[4] = new ReportParameter("cusitalic", bookingitilic);
parameters[5] = new ReportParameter("cusunderline", bookingunderline);
parameters[2] = new ReportParameter("cusalign", bookingalign);
}
parameters[6] = new ReportParameter("bookingfont", bookingfont);
parameters[7] = new ReportParameter("bookingsize", bookingsize);
parameters[8] = new ReportParameter("bookingbold", bookingbold);
parameters[9] = new ReportParameter("bookingitalic", bookingitilic);
parameters[10] = new ReportParameter("bookingunderling", bookingunderline);
parameters[11] = new ReportParameter("bookingalign", bookingalign);
if (barcodeprocess == true)
{
parameters[12] = new ReportParameter("processfont", processfont);
parameters[13] = new ReportParameter("processsize", processsize);
parameters[14] = new ReportParameter("processbold", processbold);
parameters[15] = new ReportParameter("processitalice", processitalic);
parameters[16] = new ReportParameter("processunderline", processunderline);
parameters[17] = new ReportParameter("proceaaaline", processalign);
}
else
{
parameters[12] = new ReportParameter("processfont", bookingfont);
parameters[13] = new ReportParameter("processsize", bookingsize);
parameters[14] = new ReportParameter("processbold", bookingbold);
parameters[15] = new ReportParameter("processitalice", bookingitilic);
parameters[16] = new ReportParameter("processunderline", bookingunderline);
parameters[17] = new ReportParameter("proceaaaline", bookingalign);
}
if (barcodeitem == true && barcodeduedate == true)
{
parameters[18] = new ReportParameter("itemfont", itemfont);
parameters[19] = new ReportParameter("itemsize", itemsize);
parameters[20] = new ReportParameter("itembold", itembold);
parameters[21] = new ReportParameter("itemitalic", itemitalic);
parameters[22] = new ReportParameter("itemunderline", itemunderline);
parameters[23] = new ReportParameter("itemalign", itemalign);
}
else
{
parameters[18] = new ReportParameter("itemfont", remarkfont);
parameters[19] = new ReportParameter("itemsize", remarksize);
parameters[20] = new ReportParameter("itembold", remarkbold);
parameters[21] = new ReportParameter("itemitalic", remarkitalic);
parameters[22] = new ReportParameter("itemunderline", remarkunderline);
parameters[23] = new ReportParameter("itemalign", remarkremarkalign);
}
parameters[24] = new ReportParameter("remarkfont", remarkfont);
parameters[25] = new ReportParameter("remarksize", remarksize);
parameters[26] = new ReportParameter("remarkbold", remarkbold);
parameters[27] = new ReportParameter("remarkitalic", remarkitalic);
parameters[28] = new ReportParameter("remarkunderline", remarkunderline);
parameters[29] = new ReportParameter("remarkalign", remarkremarkalign);
# region unusedCode
/*
* ReportViewer1.LocalReport.SetParameters(parameters);
* rds.Value = ds.Tables[0];
* ReportViewer1.LocalReport.DataSources.Clear();
* ReportViewer1.LocalReport.DataSources.Add(rds);
* ReportViewer1.DataBind();
* //ReportViewer1.Visible = true;
* ReportViewer1.LocalReport.Refresh();
*
* // string res1 = BAL.BALFactory.Instance.BAL_BarcodeLable.delbarcodelable();
*
* //string reportType = "PDF";
* //string mimeType = string.Empty;
* //string encoding = string.Empty;
* //string fileNameExtension = string.Empty;
* string deviceInfo =
* "<DeviceInfo>" +
* " <OutputFormat>EMF</OutputFormat>" +
* " <PageWidth>210mm</PageWidth>" +
* " <PageHeight>297mm</PageHeight>" +
* " <Columns>3</Columns>" +
* " <ColumnSpacing>2.5mm</ColumnSpacing>" +
* " <MarginTop>13.00mm</MarginTop>" +
* " <MarginLeft>6.50mm</MarginLeft>" +
* " <MarginRight>0in</MarginRight>" +
* " <MarginBottom>0in</MarginBottom>" +
*
* "</DeviceInfo>";
* Warning[] warnings;
* m_streams = new List<Stream>();
* //string[] streams;
* //byte[] renderedBytes;
* //renderedBytes = ReportViewer1.LocalReport.Render(
* //reportType,
* //deviceInfo,
* //out mimeType,
* //out encoding,
* //out fileNameExtension,
* //out streams,
* //out warnings);
* ReportViewer1.LocalReport.Render("Image", deviceInfo, CreateStream, out warnings);
* foreach (Stream stream in m_streams)
* stream.Position = 0;
* //Response.Clear();
* //Response.ContentType = mimeType;
* //Response.BinaryWrite(renderedBytes);
* if (Request.QueryString["DirectPrint"] != null && Request.QueryString["DirectPrint"].ToString() == "true")
* {
* //if (saveCurReport(renderedBytes))
* //{
* string res1 = BAL.BALFactory.Instance.BAL_BarcodeLable.delbarcodelable();
* makePrint();
* Dispose();
* var redirectUrl = Request.QueryString["RedirectBack"] as string;
* Response.Redirect(redirectUrl);
* //}
* }
* //Response.End();
*/
# endregion
ReportViewer1.LocalReport.SetParameters(parameters);
rds.Value = ds.Tables[0];
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.DataBind();
//ReportViewer1.Visible = true;
ReportViewer1.LocalReport.Refresh();
// string res1 = BAL.BALFactory.Instance.BAL_BarcodeLable.delbarcodelable();
string reportType = "PDF";
string mimeType = string.Empty;
string encoding = string.Empty;
string fileNameExtension = string.Empty;
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <PageWidth>210mm</PageWidth>" +
" <PageHeight>297mm</PageHeight>" +
" <Columns>3</Columns>" +
" <ColumnSpacing>2.5mm</ColumnSpacing>" +
" <MarginTop>13.00mm</MarginTop>" +
" <MarginLeft>6.50mm</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
renderedBytes = ReportViewer1.LocalReport.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
Response.Clear();
Response.ContentType = mimeType;
Response.BinaryWrite(renderedBytes);
string res1 = BAL.BALFactory.Instance.BAL_BarcodeLable.delbarcodelable();
Response.End();
}
public string SaveBarcodeLable(DTO.BacodeLable Ob)
{
return(DAL.DALFactory.Instance.DAL_BarcodeLable.SaveBarcodeLable(Ob));
}
public string savedemo(DTO.BacodeLable Ob)
{
return(DAL.DALFactory.Instance.DAL_BarcodeLable.savedemo(Ob));
}
public DataSet SearchBarcodeLabel(DTO.BacodeLable ob)
{
return(DAL.DALFactory.Instance.DAL_BarcodeLable.SearchBarcodeLabel(ob));
}
public string UpdateBarcodeLabel(DTO.BacodeLable ob)
{
return(DAL.DALFactory.Instance.DAL_BarcodeLable.UpdateBarcodeLabel(ob));
}