public void AddUpdateUserAddress(AddressInfo addressObj,AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@AddressID", addressObj.AddressID));
parameter.Add(new KeyValuePair<string, object>("@CustomerID", aspxCommonObj.CustomerID));
parameter.Add(new KeyValuePair<string, object>("@FirstName", addressObj.FirstName));
parameter.Add(new KeyValuePair<string, object>("@LastName", addressObj.LastName));
parameter.Add(new KeyValuePair<string, object>("@Email", addressObj.Email));
parameter.Add(new KeyValuePair<string, object>("@Company", addressObj.Company));
parameter.Add(new KeyValuePair<string, object>("@Address1", addressObj.Address1));
parameter.Add(new KeyValuePair<string,object>("@Address2",addressObj.Address2));
parameter.Add(new KeyValuePair<string, object>("@City", addressObj.City));
parameter.Add(new KeyValuePair<string, object>("@State", addressObj.State));
parameter.Add(new KeyValuePair<string, object>("@Zip", addressObj.Zip));
parameter.Add(new KeyValuePair<string, object>("@Phone", addressObj.Phone));
parameter.Add(new KeyValuePair<string, object>("@Mobile", addressObj.Mobile));
parameter.Add(new KeyValuePair<string, object>("@Fax", addressObj.Fax));
parameter.Add(new KeyValuePair<string, object>("@WebSite", addressObj.Website));
parameter.Add(new KeyValuePair<string, object>("@Country", addressObj.Country));
parameter.Add(new KeyValuePair<string, object>("@IsDefaultShipping", addressObj.DefaultShipping));
parameter.Add(new KeyValuePair<string, object>("@IsDefaultBilling", addressObj.DefaultBilling));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateUserAddress", parameter);
}
public void AddUpdateUserAddress(AddressInfo addressObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxUserDashController.AddUpdateUserAddress(addressObj, aspxCommonObj);
}
catch (Exception ex)
{
throw ex;
}
}
public void CreateShipmentLabel(AddressInfo destinationAddress, WareHouseAddress wareHouseAddress, AspxCommonInfo aspxCommonObj, BasicPackageInfo basicPackageInfo)
{
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("content-disposition",
"attachment;filename=" + "ShipmentLabel_" +
DateTime.Now.ToString("M_dd_yyyy_H_M_s") + ".pdf");
Document doc = new Document(iTextSharp.text.PageSize.A4, 0, 0, 20, 20);
PdfWriter writer = PdfWriter.GetInstance(doc, HttpContext.Current.Response.OutputStream);
writer.PageEvent = new MyPageEventHandler(basicPackageInfo.CautionMessage);
doc.Open();
var textFont = FontFactory.GetFont(FontFactory.TIMES_ROMAN, 9, Font.NORMAL, new BaseColor(0, 0, 255));
PdfPTable shipmentTalbe = new PdfPTable(2);
shipmentTalbe.SetWidths(new int[2] {5, 15});
//string cautionMessage = basicPackageInfo.CautionMessage;
//PdfPCell verticalC = new PdfPCell(); //new PdfPCell(new Paragraph(cautionMessage, textFont));
//verticalC.Rotation = 90;
//// verticalC.VerticalAlignment = Element.ALIGN_CENTER;
//verticalC.PaddingTop = 30f;
//verticalC.PaddingBottom = 50f;
//verticalC.Border = Rectangle.NO_BORDER;
//// shipmentTalbe.AddCell("");
//shipmentTalbe.AddCell(verticalC);
PdfPTable headerTbl = new PdfPTable(2);
headerTbl.SetWidths(new int[2] {10, 15});
float[] widths = new float[] { 200f,300f };
// headerTbl.TotalWidth = doc.PageSize.Width;
headerTbl.WidthPercentage = 100;
Paragraph pa = new Paragraph("From",
FontFactory.GetFont(FontFactory.TIMES_ROMAN, 16, Font.BOLD,
new BaseColor(0, 0, 255)));
PdfPCell cell = new PdfPCell(pa);
cell.PaddingLeft = 15f;
// pa.Alignment = Element.ALIGN_BOTTOM;
cell.Border = Rectangle.NO_BORDER + Rectangle.RIGHT_BORDER;
cell.AddElement(pa);
PdfPTable fromTable = new PdfPTable(1);
fromTable.WidthPercentage = 100;
string fromAdd = string.Empty;
if (!string.IsNullOrEmpty(wareHouseAddress.Name))
fromAdd += wareHouseAddress.Name.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(wareHouseAddress.Address))
fromAdd += wareHouseAddress.Address.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(wareHouseAddress.StreetAddress1))
fromAdd += wareHouseAddress.StreetAddress1.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(wareHouseAddress.StreetAddress2))
fromAdd += wareHouseAddress.StreetAddress2.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(wareHouseAddress.City))
fromAdd += wareHouseAddress.City.Trim();
if (!string.IsNullOrEmpty(wareHouseAddress.State))
fromAdd += ", " + wareHouseAddress.State.Trim();
if (!string.IsNullOrEmpty(wareHouseAddress.PostalCode))
fromAdd += ", " + wareHouseAddress.PostalCode.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(wareHouseAddress.Country))
fromAdd += wareHouseAddress.Country.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(wareHouseAddress.Phone))
fromAdd += wareHouseAddress.Phone.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(wareHouseAddress.Fax))
fromAdd += wareHouseAddress.Fax.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(wareHouseAddress.Email))
fromAdd += wareHouseAddress.Email.Trim() + Environment.NewLine;
PdfPCell fromAddcell = new PdfPCell(new Paragraph(fromAdd, textFont));
fromAddcell.Border = Rectangle.NO_BORDER;
fromAddcell.PaddingLeft = 30f;
fromTable.AddCell(fromAddcell);
cell.AddElement(fromTable);
headerTbl.AddCell(cell);
Paragraph to = new Paragraph("To",
FontFactory.GetFont(FontFactory.TIMES_ROMAN, 16, Font.BOLD,
new BaseColor(0, 0, 255)));
PdfPCell cellTo = new PdfPCell(to);
cellTo.PaddingLeft = 15f;
cellTo.Border = Rectangle.NO_BORDER;
cellTo.AddElement(to);
PdfPTable toTable = new PdfPTable(1);
toTable.WidthPercentage = 100;
string toAddress = string.Empty;
if (!string.IsNullOrEmpty(destinationAddress.FirstName))
toAddress += destinationAddress.FirstName.Trim() + " ";
if (!string.IsNullOrEmpty(destinationAddress.LastName))
toAddress += destinationAddress.LastName.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.Company))
toAddress += destinationAddress.Company.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.Address1))
toAddress += destinationAddress.Address1.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.Address2))
toAddress += destinationAddress.Address2.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.City))
toAddress += destinationAddress.City.Trim();
if (!string.IsNullOrEmpty(destinationAddress.State))
toAddress += ", " + destinationAddress.State.Trim();
if (!string.IsNullOrEmpty(destinationAddress.Zip))
toAddress += ", " + destinationAddress.Zip.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.Country))
toAddress += destinationAddress.Country.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.Email))
toAddress += destinationAddress.Email.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.Phone))
toAddress += destinationAddress.Phone.Trim();
if (!string.IsNullOrEmpty(destinationAddress.Mobile))
toAddress += ", " + destinationAddress.Mobile.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.Fax))
toAddress += destinationAddress.Fax.Trim() + Environment.NewLine;
if (!string.IsNullOrEmpty(destinationAddress.Website))
toAddress += destinationAddress.Website.Trim();
PdfPCell toAddresscell = new PdfPCell(new Paragraph(toAddress, textFont));
toAddresscell.Border = Rectangle.NO_BORDER;
toAddresscell.PaddingLeft = 30f;
toTable.AddCell(toAddresscell);
cellTo.AddElement(toTable);
headerTbl.AddCell(cellTo);
var cellBackColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#F4F8FC"));
// for one line spacing
PdfPCell blankCell1 = new PdfPCell();
blankCell1.Colspan = 2;
blankCell1.Border = Rectangle.NO_BORDER;
// blankCell1.BackgroundColor = cellBackColor;
headerTbl.AddCell(blankCell1);
// For Tracking Number
//PdfPCell trackingCell = new PdfPCell();
//trackingCell.Colspan = 2;
//trackingCell.Border = Rectangle.NO_BORDER;
//Paragraph tracingPa = new Paragraph("Tracking No: " + basicPackageInfo.TrackingNo + "",
// FontFactory.GetFont(FontFactory.TIMES_ROMAN, 16, Font.BOLD,
// new BaseColor(0, 0, 255)));
//trackingCell.AddElement(tracingPa);
//headerTbl.AddCell(trackingCell);
// For one line spacing after tracking no.
PdfPCell blankCell2 = new PdfPCell();
blankCell2.Colspan = 2;
blankCell2.Border = Rectangle.NO_BORDER;
// blankCell2.BackgroundColor = cellBackColor;
headerTbl.AddCell(blankCell2);
// for total weight
PdfPCell blankMiddleCell = new PdfPCell();
blankMiddleCell.Border = Rectangle.NO_BORDER;
headerTbl.AddCell(blankMiddleCell);
string dimension = basicPackageInfo.Length + "*" + basicPackageInfo.Width + "*" + basicPackageInfo.Height +
" " + basicPackageInfo.DimensionUnit;
Paragraph wtPa = new Paragraph("Total Weight: " + basicPackageInfo.TotalWeight + "" + Environment.NewLine
+ "Weight Unit: " + basicPackageInfo.WeightUnit + "" + Environment.NewLine
+ "Dimension(L*W*H): " + dimension, textFont);
PdfPCell wtCell = new PdfPCell();
wtCell.AddElement(wtPa);
wtCell.Border = Rectangle.NO_BORDER;
wtCell.PaddingLeft = 30f;
headerTbl.AddCell(wtCell);
// for one line space after total weight
PdfPCell blankCell3 = new PdfPCell();
blankCell3.Colspan = 2;
blankCell3.Border = Rectangle.NO_BORDER;
// blankCell3.BackgroundColor = cellBackColor;
headerTbl.AddCell(blankCell3);
// for last row with logo
Paragraph senderPa = new Paragraph("Sender Name: " + basicPackageInfo.SenderName + "" + Environment.NewLine
+ "Servce Type: " + basicPackageInfo.ServiceType, textFont);
PdfPCell senderCell = new PdfPCell(senderPa);
senderCell.Border = Rectangle.NO_BORDER + Rectangle.RIGHT_BORDER;
headerTbl.AddCell(senderCell);
StoreSettingConfig ssc = new StoreSettingConfig();
string storeLogoUrl = ssc.GetStoreSettingsByKey(StoreSetting.StoreLogoURL, aspxCommonObj.StoreID,
aspxCommonObj.PortalID, aspxCommonObj.CultureName);
string logoPath = HttpContext.Current.Request.MapPath("~/" + storeLogoUrl);
PdfPTable logoTable = new PdfPTable(1);
if (File.Exists(logoPath))
{
iTextSharp.text.Image logo =
iTextSharp.text.Image.GetInstance(logoPath.Replace("uploads", "uploads/Small").Replace("\\", @"//"));
logo.ScalePercent(50f);
PdfPCell logoImage = new PdfPCell(logo);
logoImage.Border = Rectangle.NO_BORDER;
logoImage.PaddingLeft = 30f;
logoImage.AddElement(logo);
//PdfPTable logoTable = new PdfPTable(1);
logoTable.WidthPercentage = 100;
logoTable.AddCell(logoImage);
}
var storeName = ssc.GetStoreSettingsByKey(StoreSetting.StoreName, aspxCommonObj.StoreID,
aspxCommonObj.PortalID, aspxCommonObj.CultureName);
PdfPCell storeNameCell = new PdfPCell(new Paragraph(storeName, textFont));
storeNameCell.Border = Rectangle.NO_BORDER;
storeNameCell.PaddingLeft = 30f;
logoTable.AddCell(storeNameCell);
PdfPCell logoCell = new PdfPCell();
logoCell.AddElement(logoTable);
logoCell.HorizontalAlignment = Element.ALIGN_CENTER;
logoCell.Border = Rectangle.NO_BORDER;
headerTbl.AddCell(logoCell);
headerTbl.DefaultCell.Border = Rectangle.NO_BORDER;
PdfPCell detailCell = new PdfPCell();
detailCell.Colspan = 2;
detailCell.AddElement(headerTbl);
shipmentTalbe.AddCell(detailCell);
doc.Add(shipmentTalbe);
doc.Close();
}
public static void AddUpdateUserAddress(AddressInfo addressObj, AspxCommonInfo aspxCommonObj)
{
AspxUserDashProvider.AddUpdateUserAddress(addressObj, aspxCommonObj);
}
