/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT GroupID, AccountID, Name, Description, Password, Startup, PWLastUpdateTime, PWType, CreateTime, dModifyTime, iFailTimes, dLockTime, cRoleID, AD_CheckFlag, cCallID, cPWD FROM SecurityUserAccount WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _groupID = reader.GetString(0); _accountID = reader.GetString(1); _name = reader.GetString(2); _description = reader.GetString(3); //_password = reader.GetString(4); _password = (byte[])reader[4]; _startup = reader.GetBoolean(5); _pWLastUpdateTime = reader.GetDateTime(6); _pWType = reader.GetInt16(7); _createTime = reader.GetDateTime(8); _dModifyTime = reader.GetDateTime(9); _iFailTimes = reader.GetInt16(10); _dLockTime = reader.GetDateTime(11); _cRoleID = reader.GetInt16(12); _aD_CheckFlag = reader.GetBoolean(13); _cCallID = reader.GetString(14); _cPWD = reader.GetString(15); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT DMSRoleID, DMSRoleIDManaged FROM DMSRoleManage WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _dMSRoleID = reader.GetInt16(0); _dMSRoleIDManaged = reader.GetInt16(1); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MCID, GroupID, Model, MCNo, MaintainID, IPAddress, PU, LU, DevicePoint, SourceConnection, ATMBandWidth, SDGatewayID, BandWidth, MCAccountID, MCFunc, SystemOS, OpenTime, bPoint, DetailAddress, Maintain_Money, Maintain_Sys, Maintain_Fix, BuyCaseNo, BuyDate, OpenDate, InstallDate, Memo, LoginGorupID FROM MCData WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mCID = reader.GetString(0); _groupID = reader.GetString(1); _model = reader.GetString(2); _mCNo = reader.GetString(3); _maintainID = reader.GetString(4); _iPAddress = reader.GetString(5); _pU = reader.GetString(6); _lU = reader.GetString(7); _devicePoint = reader.GetString(8); _sourceConnection = reader.GetString(9); _aTMBandWidth = reader.GetInt32(10); _sDGatewayID = reader.GetString(11); _bandWidth = reader.GetInt32(12); _mCAccountID = reader.GetString(13); _mCFunc = reader.GetInt16(14); _systemOS = reader.GetInt16(15); _openTime = reader.GetString(16); _bPoint = reader.GetString(17); _detailAddress = reader.GetString(18); _maintain_Money = reader.GetString(19); _maintain_Sys = reader.GetString(20); _maintain_Fix = reader.GetString(21); _buyCaseNo = reader.GetString(22); _buyDate = reader.GetDateTime(23); _openDate = reader.GetDateTime(24); _installDate = reader.GetDateTime(25); _memo = reader.GetString(26); _loginGorupID = reader.GetString(27); } reader.Close(); } }
public SupplierListInfo(SqlDataReader reader) { //[Id], Guid,Email,[Name],CompanyName, Address, PhoneNumber, Status,FoundedYear,AllowMatch,Balance,GeneralScore,Priority id = reader.GetInt32(0); guid = reader.GetString(1); email = reader.GetString(2); name = reader.IsDBNull(3) ? "" : reader.GetString(3); companyName = reader.IsDBNull(4) ? "" : reader.GetString(4); address = reader.IsDBNull(5) ? "" : reader.GetString(5); phoneNumber = reader.IsDBNull(6) ? "" : reader.GetString(6); status = (CompanyStatus)(reader.GetInt16(7)); foundedYear = reader.GetInt16(8); regDate = reader.GetDateTime(9); allowMatch = reader.GetString(10) == "1"; balance = Convert.ToSingle(reader.GetValue(11)); generalScore = Convert.ToSingle(reader.GetValue(12)); priority = reader.GetInt32(13); }
private List<Product> GetProducts(SqlDataReader reader) { var products = new List<Product>(); while (reader.Read()) { products.Add(new Product { ProductName = reader.GetString(1), UnitsInStock = reader.GetInt16(6) }); } return (products); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT DateTime, AccountID, Type, Status, TxDateTime, TransDateTime FROM LinetStatus WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _dateTime = reader.GetDateTime(0); _accountID = reader.GetString(1); _type = reader.GetInt16(2); _status = reader.GetInt16(3); _txDateTime = reader.GetString(4); _transDateTime = reader.GetString(5); } reader.Close(); } }
public static CategoryInfo CopyCategoryToBO(SqlDataReader rdr) { //CAT_ID, CAT_NAME, CAT_STATUS, CAT_MODERATION, CAT_SUBSCRIPTION, CAT_ORDER CategoryInfo category = new CategoryInfo { Id = rdr.GetInt32(0), Name = rdr.SafeGetString(1), Status = rdr.GetInt16(2), ModerationLevel = rdr.SafeGetInt32(3), SubscriptionLevel = rdr.SafeGetInt32(4), Order = rdr.GetInt32(5) }; return category; }
public static ForumInfo CopyForumToBO(SqlDataReader rdr) { //"F.FORUM_ID,F.CAT_ID,F.F_STATUS,F.F_SUBJECT,F.F_URL,F.F_TOPICS" + //",F.F_COUNT,F.F_LAST_POST,F.F_PRIVATEFORUMS,F.F_TYPE,F.F_LAST_POST_AUTHOR,F.F_A_TOPICS,F.F_A_COUNT,F.F_MODERATION" + //",F.F_SUBSCRIPTION,F.F_ORDER, F.F_COUNT_M_POSTS,F.F_LAST_POST_TOPIC_ID,F.F_LAST_POST_REPLY_ID,F.F_POLLS,F.F_DESCRIPTION" + //",F.F_L_ARCHIVE,F.F_ARCHIVE_SCHED,T.T_SUBJECT,M.M_NAME "; ForumInfo forum = new ForumInfo { Id = rdr.GetInt32(0), CatId = rdr.GetInt32(1), Status = rdr.GetInt16(2), Subject = rdr.SafeGetString(3), Url = rdr.SafeGetString(4), TopicCount = rdr.GetInt32(5), PostCount = rdr.GetInt32(6), LastPostDate = rdr.GetSnitzDate(7), AuthType = rdr.SafeGetInt32(8), Type = rdr.GetInt16(9), LastPostAuthorId = rdr.SafeGetInt32(10), ArchivedTopicCount = rdr.SafeGetInt32(11), ArchivedPostCount = rdr.SafeGetInt32(12), ModerationLevel = rdr.SafeGetInt32(13), SubscriptionLevel = rdr.SafeGetInt32(14), Order = rdr.GetInt32(15), UpdatePostCount = rdr.GetInt16(16) == 1, LastPostTopicId = rdr.SafeGetInt32(17), LastPostReplyId = rdr.SafeGetInt32(18), AllowPolls = rdr.GetInt32(19) == 1, Description = rdr.SafeGetString(20), LastArchived = rdr.GetSnitzDate(21), ArchiveFrequency = rdr.SafeGetInt32(22), LastPostSubject = rdr.SafeGetString(23), LastPostAuthorName = rdr.SafeGetString(24) }; return forum; }
SqlJobMetrics build_sql_job_metric_from_reader(SqlDataReader reader) { var metric = new SqlJobMetrics(); metric.job_name = reader.GetString(0); metric.message = reader.GetString(1); var job_outcome_key = reader.GetByte(2); metric.job_status = get_job_outcome_from_key(job_outcome_key); metric.last_run = reader.GetDateTime(3); metric.job_step = reader.GetInt16(4); return metric; }
/// <summary> /// Creates a new instance of the ViewProductoObjetivo class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewProductoObjetivoInfo MakeViewProductoObjetivo(SqlDataReader dataReader) { ViewProductoObjetivoInfo viewProductoObjetivo = new ViewProductoObjetivoInfo(); if (dataReader.IsDBNull(Cod_Producto) == false) viewProductoObjetivo.Cod_Producto = dataReader.GetInt32(Cod_Producto); if (dataReader.IsDBNull(Cod_Trilogia) == false) viewProductoObjetivo.Cod_Trilogia = dataReader.GetInt32(Cod_Trilogia); if (dataReader.IsDBNull(Producto) == false) viewProductoObjetivo.Producto = dataReader.GetString(Producto); if (dataReader.IsDBNull(Cantidad) == false) viewProductoObjetivo.Cantidad = dataReader.GetInt16(Cantidad); return viewProductoObjetivo; }
public static ForumInfo CopyForumToBO(SqlDataReader rdr) { ForumInfo forum = new ForumInfo { Id = rdr.GetInt32(0), CatId = rdr.GetInt32(1), Status = rdr.GetInt16(2), Subject = rdr.SafeGetString(3), Url = rdr.SafeGetString(4), TopicCount = rdr.GetInt32(5), PostCount = rdr.GetInt32(6), LastPostDate = rdr.SafeGetString(7).ToDateTime(), AuthType = rdr.SafeGetInt32(8), Type = rdr.GetInt16(9), LastPostAuthorId = rdr.SafeGetInt32(10), ArchivedTopicCount = rdr.SafeGetInt32(11), ArchivedPostCount = rdr.SafeGetInt32(12), ModerationLevel = rdr.SafeGetInt32(13), SubscriptionLevel = rdr.SafeGetInt32(14), Order = rdr.GetInt32(15), UpdatePostCount = rdr.GetInt16(16) == 1, LastPostTopicId = rdr.SafeGetInt32(17), LastPostReplyId = rdr.SafeGetInt32(18), AllowPolls = rdr.GetInt32(19) == 1, Description = rdr.SafeGetString(20), LastPostSubject = rdr.SafeGetString(21), LastPostAuthorName = rdr.SafeGetString(22) }; //if (forum.LastPostAuthorId != null) //{ // var author = new PostAuthor().GetAuthor(forum.LastPostAuthorId.Value); // forum.LastPostAuthor = author; //} return forum; }
//Does not load the fileData column public override FileVO ReadRecord(System.Data.SqlClient.SqlDataReader reader) { FileVO result = new FileVO(); result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName)); result.Name = reader[fileName].ToString(); DocumentDAO ddao = new DocumentDAO(); result.Document = ddao.GetItem(reader.GetInt32(reader.GetOrdinal(fileDocumentId))); ddao.CloseConnection(); short valInt = reader.GetInt16(reader.GetOrdinal(fileType)); result.Type = (FileVO.FileType)valInt; result.AdditionDateTime = reader.GetDateTime(reader.GetOrdinal(fileAdditionDate)); return(result); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT DMSRoleID, SysModID, SysFuncID, SysActionID FROM DMSRoleAction WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _dMSRoleID = reader.GetInt16(0); _sysModID = reader.GetString(1); _sysFuncID = reader.GetString(2); _sysActionID = reader.GetString(3); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT AccountID, bPassword, iOrder, Kind, Ldate FROM SecurityUserPwd WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _accountID = reader.GetString(0); _bPassword = (byte[])reader[1]; _iOrder = reader.GetInt16(2); _kind = reader.GetInt32(3); _ldate = reader.GetDateTime(4); } reader.Close(); } }
// Select a Credit Card ID record to edit protected void DropDownListSelectCreditCardID_SelectedIndexChanged(object sender, EventArgs e) { // Store selected credit card id value into variable string tempID = DropDownListSelectCreditCardID.SelectedValue; creditCardSelected = true; // Create temporary variables to store selected record information string tempCardType = ""; string tempCardNumber = ""; Byte tempExpMonth = 0; Int16 tempExpYear = 0; // Select record from database at selected credit card ID value sc.Open(); String query2 = "SELECT * FROM [Sales].[CreditCard] WHERE [CreditCardID] = @tempid;"; System.Data.SqlClient.SqlCommand sqlCom2 = new System.Data.SqlClient.SqlCommand(query2, sc); sqlCom2.Parameters.AddWithValue("@tempid", tempID); sqlCom2.ExecuteNonQuery(); // Use Reader and assign temporary variables with data from selected record System.Data.SqlClient.SqlDataReader reader = sqlCom2.ExecuteReader(); while (reader.Read()) { tempCardType = reader.GetString(1); tempCardNumber = reader.GetString(2); tempExpMonth = reader.GetByte(3); tempExpYear = reader.GetInt16(4); } reader.Close(); //Display selected data in the textboxes in the web form DropDownListCardType.SelectedValue = DropDownListCardType.Items.FindByText(tempCardType).Value; TextBoxCardNumber.Text = tempCardNumber; DropDownListExpMonth.SelectedValue = DropDownListExpMonth.Items.FindByValue(tempExpMonth.ToString()).Value; DropDownListExpYear.SelectedValue = DropDownListExpYear.Items.FindByValue(tempExpYear.ToString()).Value; TextBoxResult.Text = creditCardSelected.ToString(); }
public static bool getFieldValue(SqlDataReader dr, int ind, bool def) { bool val = def; if (!dr.IsDBNull(ind)) { switch (System.Type.GetTypeCode(dr.GetFieldType(ind))) { case System.TypeCode.Boolean: val = dr.GetBoolean(ind); break; case System.TypeCode.Byte: val = System.Convert.ToBoolean(dr.GetByte(ind)); break; case System.TypeCode.Int16: val = System.Convert.ToBoolean(dr.GetInt16(ind)); break; case System.TypeCode.Int32: val = System.Convert.ToBoolean(dr.GetInt32(ind)); break; } } return val; }
private static void ReportBuilder(SqlDataReader dr, SqlDataReader drLandDesc, int cropYear, string logoUrl, System.IO.FileStream fs) { const string METHOD_NAME = "WSCReports.rpfFieldAgronomy.ReportBuilder: "; string tmp = null; Document document = null; PdfWriter writer = null; ArrayList values = null; PdfPTable table = null; float[] tmpLayout = null; iTextSharp.text.Paragraph para = null; iTextSharp.text.Phrase phrase = null; RptAgronomy agronomy = null; AgronomyReportEvent pgEvent = null; iTextSharp.text.pdf.PdfPCell cell = null; Font titleFont = FontFactory.GetFont("HELVETICA", 12F, Font.BOLD); Font subTitleFont = FontFactory.GetFont("HELVETICA", 9F, Font.NORMAL); Font headerFont = FontFactory.GetFont("HELVETICA", 8F, Font.NORMAL); Font normalFont = FontFactory.GetFont("HELVETICA", 8F, Font.NORMAL); Font labelFont = FontFactory.GetFont("HELVETICA", 8F, Font.BOLD); try { while (dr.Read()) { try { if (document == null) { agronomy = WSCField.GetAgronomyData(); // IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!! // *** US LETTER: 612 X 792 *** //document = new Document(PageSize.LETTER); document = new Document(PageSize.LETTER, PortraitPageSize.PgLeftMargin, PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin - 18, PortraitPageSize.PgBottomMargin - 36);//54 // we create a writer that listens to the document // and directs a PDF-stream to a file writer = PdfWriter.GetInstance(document, fs); // Attach my override event handler(s) pgEvent = new AgronomyReportEvent(); pgEvent.FillEvent(cropYear.ToString(), dr.GetString(dr.GetOrdinal("fld_shid")), dr.GetString(dr.GetOrdinal("fld_business_name")), dr.GetString(dr.GetOrdinal("fld_address1")), dr.GetString(dr.GetOrdinal("fld_address2")), dr.GetString(dr.GetOrdinal("fld_city")), dr.GetString(dr.GetOrdinal("fld_state")), dr.GetString(dr.GetOrdinal("fld_zip")), dr.GetString(dr.GetOrdinal("fld_agriculturist")), dr.GetString(dr.GetOrdinal("fld_contract_no")), dr.GetString(dr.GetOrdinal("fld_landowner_name"))); writer.PageEvent = pgEvent; // Open the document document.Open(); } else { pgEvent.FillEvent(cropYear.ToString(), dr.GetString(dr.GetOrdinal("fld_shid")), dr.GetString(dr.GetOrdinal("fld_business_name")), dr.GetString(dr.GetOrdinal("fld_address1")), dr.GetString(dr.GetOrdinal("fld_address2")), dr.GetString(dr.GetOrdinal("fld_city")), dr.GetString(dr.GetOrdinal("fld_state")), dr.GetString(dr.GetOrdinal("fld_zip")), dr.GetString(dr.GetOrdinal("fld_agriculturist")), dr.GetString(dr.GetOrdinal("fld_contract_no")), dr.GetString(dr.GetOrdinal("fld_landowner_name"))); } // ====================================================== // Generate a new page. // ====================================================== if ( table != null) { document.NewPage(); } // ====================================================== // Legal Land Description // ====================================================== if (drLandDesc.Read()) { // *** ROW 1 *** tmpLayout = new float[] { 13F, 13.5F, 11F, 13.5F, 11F, 13.5F, 11F, 13.5F }; table = PdfReports.CreateTable(tmpLayout, 0); PdfReports.AddText2Table(table, "Field Name: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_field_name")), normalFont); PdfReports.AddText2Table(table, "Acres: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetInt32(drLandDesc.GetOrdinal("cntg_acres")).ToString(), normalFont); PdfReports.AddText2Table(table, "State: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_lld_state")), normalFont); PdfReports.AddText2Table(table, "County: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_lld_county")), normalFont); // *** ROW 2 *** PdfReports.AddText2Table(table, "1/4 Quadrant: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_lld_quarter_quadrant")), normalFont); PdfReports.AddText2Table(table, "Quadrant: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_lld_quadrant")), normalFont); PdfReports.AddText2Table(table, "Section: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_lld_section")), normalFont); PdfReports.AddText2Table(table, "Township: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_lld_township")), normalFont); // *** ROW 3 *** PdfReports.AddText2Table(table, "Range: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_lld_range")), normalFont); PdfReports.AddText2Table(table, "Latitude: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetDecimal(drLandDesc.GetOrdinal("cntg_latitude")).ToString(), normalFont); PdfReports.AddText2Table(table, "Longitude: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetDecimal(drLandDesc.GetOrdinal("cntg_longitude")).ToString(), normalFont); PdfReports.AddText2Table(table, "FSA Official: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_fsa_official")), normalFont); // *** ROW 4 *** PdfReports.AddText2Table(table, "FSA Number: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_fsa_number")), normalFont, 3); PdfReports.AddText2Table(table, "FSA State: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_fsa_state")), normalFont); PdfReports.AddText2Table(table, "FSA County: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_fsa_county")), normalFont); // *** ROW 5 *** PdfReports.AddText2Table(table, "Farm No: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_farm_number")), normalFont); PdfReports.AddText2Table(table, "Tract No: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_tract_number")), normalFont); PdfReports.AddText2Table(table, "Field No: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_field_number")), normalFont); PdfReports.AddText2Table(table, "1/4 Field: ", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_quarter_field")), normalFont, 7); // *** ROW 6 *** PdfReports.AddText2Table(table, "Description", labelFont); PdfReports.AddText2Table(table, drLandDesc.GetString(drLandDesc.GetOrdinal("cntg_description")), normalFont, 7); PdfReports.AddTableNoSplit(document, pgEvent, table); } // ====================================================== // Planting Block // ====================================================== phrase = new Phrase("\nVariety: ", labelFont); para = new Paragraph(); para.Add(phrase); tmp = dr.GetString(dr.GetOrdinal("fld_seed_variety")); if (tmp.Length == 0) { tmpLayout = new float[] { 540F }; table = PdfReports.CreateTable(tmpLayout, 0); // No seed found in Field record, so list the possible seed options // based on state information string factoryNumber = dr.GetInt16(dr.GetOrdinal("fld_factory_no")).ToString(); if (factoryNumber.Length == 0) { PdfReports.AddText2Table(table, para); // No state in Field record, list all possible seed options para = GetSeedsAsText(agronomy, "6", labelFont, normalFont, true); cell = new iTextSharp.text.pdf.PdfPCell(para); cell.BorderWidth = 1; table.AddCell(cell); phrase = new Phrase("\n", labelFont); PdfReports.AddText2Table(table, phrase); para = GetSeedsAsText(agronomy, "2", labelFont, normalFont, true); cell = new iTextSharp.text.pdf.PdfPCell(para); cell.BorderWidth = 1; table.AddCell(cell); } else { PdfReports.AddText2Table(table, para); para = GetSeedsAsText(agronomy, factoryNumber, labelFont, normalFont, true); cell = new iTextSharp.text.pdf.PdfPCell(para); cell.BorderWidth = 1; table.AddCell(cell); } } else { tmpLayout = new float[] { 540F }; table = PdfReports.CreateTable(tmpLayout, 0); phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); } PdfReports.AddText2Table(table, new Paragraph(" \n ", FontFactory.GetFont("HELVETICA", 4F)), tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Seed Block // ====================================================== tmpLayout = new float[] { 140F, 30F, 370F }; table = PdfReports.CreateTable(tmpLayout, 0); // Seed Primed para = new Paragraph(); phrase = new Phrase("Seed: ", labelFont); para.Add(phrase); tmp = dr.GetString(dr.GetOrdinal("fld_seed_primed")); if (tmp.Length > 0) { phrase = new Phrase(tmp, normalFont); para.Add(phrase); } else { values = new ArrayList(); foreach (TItem item in agronomy.SeedList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); PdfReports.AddText2Table(table, " ", normalFont); // Treatment para = new Paragraph(); phrase = new Phrase("Treatment: ", labelFont); para.Add(phrase); tmp = dr.GetString(dr.GetOrdinal("fld_seed_treatment_chemical")); if (tmp.Length > 0) { phrase = new Phrase(tmp, normalFont); para.Add(phrase); } else { values = new ArrayList(); foreach (TItem item in agronomy.SeedTreatmentList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, 4F)), tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Planting Stuff // ====================================================== tmpLayout = new float[] { 170F, 370F }; table = PdfReports.CreateTable(tmpLayout, 0); // Row Spacing. para = new Paragraph(); phrase = new Phrase("Row Spacing: ", labelFont); para.Add(phrase); tmp = (dr.GetInt16(dr.GetOrdinal("fld_row_spacing"))).ToString(); if (tmp.Length > 0 && tmp == "0") { tmp = ""; } if (tmp.Length > 0) { phrase = new Phrase(tmp, normalFont); para.Add(phrase); } else { values = new ArrayList(); foreach (TItem item in agronomy.RowSpacingList.Items) { if (item.Name.Length > 0 && item.Name != "0") { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); // Planting Spacing tmp = (dr.GetDecimal(dr.GetOrdinal("fld_plant_spacing"))).ToString("#.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } para = new Paragraph(); phrase = new Phrase("Planting Spacing: ", labelFont); para.Add(phrase); if (tmp.Length > 0) { phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); } else { values = new ArrayList(); foreach (TItem item in agronomy.PlantSpacingList.Items) { if (item.Name.Length > 0 && item.Name != "0") { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); PdfReports.AddText2Table(table, para); } //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Planting Date Block // ====================================================== tmpLayout = new float[] { 170F, 370F }; table = PdfReports.CreateTable(tmpLayout, 0); // Planting Date tmp = dr.GetString(dr.GetOrdinal("fld_planting_date")); para = new Paragraph(); phrase = new Phrase("Planting Date: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "___________"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // 80% Emerg Date tmp = dr.GetString(dr.GetOrdinal("fld_emerg_80_date")); para = new Paragraph(); phrase = new Phrase("80% Emerg Date: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "___________"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Replanting Block // ====================================================== tmpLayout = new float[] { 170F, 180F, 190F }; table = PdfReports.CreateTable(tmpLayout, 0); // Replanting Date tmp = dr.GetString(dr.GetOrdinal("fld_replant_date")); para = new Paragraph(); phrase = new Phrase("Replanting Date: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "____________"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // Replant Variety tmp = dr.GetString(dr.GetOrdinal("fld_replant_seed_variety")); para = new Paragraph(); phrase = new Phrase("Replant Variety: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "____________"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // Acres Replanted tmp = (dr.GetInt32(dr.GetOrdinal("fld_acres_replanted"))).ToString(); if (tmp == "0") { tmp = ""; } para = new Paragraph(); phrase = new Phrase("Acres Replanted: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "____________"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // Replant Reason tmp = dr.GetString(dr.GetOrdinal("fld_replant_reason")); para = new Paragraph(); phrase = new Phrase("Replant Reason: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "____________"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // Lost Reason tmp = dr.GetString(dr.GetOrdinal("fld_lost_reason")); para = new Paragraph(); phrase = new Phrase("Reason Lost: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "____________"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // Lost Acres tmp = (dr.GetInt32(dr.GetOrdinal("fld_acres_lost"))).ToString(); if (tmp == "0") { tmp = ""; } para = new Paragraph(); phrase = new Phrase("Acres Lost: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "____________"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Soil Sample Block // ====================================================== tmpLayout = new float[] { 165F, 120F, 135F, 120F }; table = PdfReports.CreateTable(tmpLayout, 0); // 1. Soil Texture tmp = dr.GetString(dr.GetOrdinal("fld_soil_texture")); para = new Paragraph(); phrase = new Phrase("Soil Texture: ", labelFont); para.Add(phrase); if (tmp.Length > 0) { phrase = new Phrase(tmp, normalFont); para.Add(phrase); } else { values = new ArrayList(); foreach (TItem item in agronomy.SoilTextureList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); // 2. Soil Sample tmp = dr.GetString(dr.GetOrdinal("fld_test_season")); para = new Paragraph(); phrase = new Phrase("Soil Sample: ", labelFont); para.Add(phrase); if (tmp.Length > 0) { phrase = new Phrase(tmp, normalFont); para.Add(phrase); } else { values = new ArrayList(); foreach (TItem item in agronomy.SoilTestList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); // 3. Nitrogen Sample Depth tmp = (dr.GetInt16(dr.GetOrdinal("fld_test_depth"))).ToString(); if (tmp == "0") { tmp = ""; } para = new Paragraph(); phrase = new Phrase("N Sample Depth: ", labelFont); para.Add(phrase); if (tmp.Length > 0) { phrase = new Phrase(tmp, normalFont); para.Add(phrase); } else { values = new ArrayList(); foreach (TItem item in agronomy.SampleDepthList.Items) { if (item.Name.Length > 0 && item.Name != "0") { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); // 4. grid / zone para = new Paragraph(); para.Add(new Phrase(@"Grid\Zone: ", labelFont)); tmp = dr.GetString(dr.GetOrdinal("fld_grid_zone")); if (tmp.Length == 0) { tmp = @"Yes \ No"; } para.Add(new Phrase(tmp, normalFont)); PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Soil Sample Test Results Block // ====================================================== tmpLayout = new float[] { 90F, 72F, 90F, 72F, 72F, 72F, 72F }; table = PdfReports.CreateTable(tmpLayout, 0); // Results: Label para = new Paragraph(); phrase = new Phrase("Test Results: ", labelFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // Nitrogen tmp = (dr.GetDecimal(dr.GetOrdinal("fld_test_N"))).ToString("#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } para = new Paragraph(); phrase = new Phrase("N: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "______"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); para.Add(new Phrase(" lbs", normalFont)); PdfReports.AddText2Table(table, para); // Phosphorus para = new Paragraph(); phrase = new Phrase("P: ", labelFont); para.Add(phrase); tmp = dr.GetString(dr.GetOrdinal("fld_test_P")); if (tmp.Length == 0) { values = new ArrayList(); foreach (TItem item in agronomy.SamplePList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } else { para.Add(new Phrase(tmp, normalFont)); } PdfReports.AddText2Table(table, para); // Potasium tmp = (dr.GetDecimal(dr.GetOrdinal("fld_test_K"))).ToString("#.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } para = new Paragraph(); phrase = new Phrase("K: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "______"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); para.Add(new Phrase(" ppm", normalFont)); PdfReports.AddText2Table(table, para); // Salts tmp = (dr.GetDecimal(dr.GetOrdinal("fld_test_salts"))).ToString("#.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } para = new Paragraph(); phrase = new Phrase("Salts: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "______"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // pH tmp = (dr.GetDecimal(dr.GetOrdinal("fld_test_pH"))).ToString("#.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } para = new Paragraph(); phrase = new Phrase("pH: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "______"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // Organic Material tmp = (dr.GetDecimal(dr.GetOrdinal("fld_test_org_mat"))).ToString("#.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } para = new Paragraph(); phrase = new Phrase("O.M.: ", labelFont); para.Add(phrase); if (tmp.Length == 0) { tmp = "______"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); para.Add(new Phrase(" %", normalFont)); PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Last Yr Manure Block // ====================================================== tmpLayout = new float[] { 170F, 370F }; table = PdfReports.CreateTable(tmpLayout, 0); // Last year tmp = (dr.GetInt32(dr.GetOrdinal("fld_last_yr_manure"))).ToString(); if (tmp.Length > 0 && tmp == "0") { tmp = ""; } para = new Paragraph(); phrase = new Phrase("Last Year Manure Applied: ", labelFont); //para.Add(phrase); PdfReports.AddText2Table(table, phrase); if (tmp.Length > 0) { phrase = new Phrase(tmp, normalFont); //para.Add(phrase); PdfReports.AddText2Table(table, phrase); } else { values = new ArrayList(); for (int i = 0; i < 5; i++) { values.Add((cropYear - i).ToString()); } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Fertilizer Block // ====================================================== tmpLayout = new float[] { 170F, 75F, 75F, 75F, 145F }; table = PdfReports.CreateTable(tmpLayout, 0); PdfReports.AddText2Table(table, "", labelFont); PdfReports.AddText2Table(table, "Actual units/Acre Average Over Whole Field", labelFont, 4); // Fall tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_fal_N"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "Fall " + (cropYear - 1).ToString() + " Applied Fertilizer", labelFont); PdfReports.AddText2Table(table, "N: " + tmp + " lbs", normalFont); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_fal_P"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "P: " + tmp + " lbs", normalFont); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_fal_K"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "K: " + tmp + " lbs", normalFont); PdfReports.AddText2Table(table, "", normalFont); // Spring tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_spr_N"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "Spring " + cropYear.ToString() + " Applied Fertilizer", labelFont); PdfReports.AddText2Table(table, "N: " + tmp + " lbs", normalFont); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_spr_P"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "P: " + tmp + " lbs", normalFont); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_spr_K"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "K: " + tmp + " lbs", normalFont); PdfReports.AddText2Table(table, "", normalFont); // In Season tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_ins_N"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "In Season " + cropYear.ToString() + " Applied Fertilizer", labelFont); PdfReports.AddText2Table(table, "N: " + tmp + " lbs", normalFont); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_ins_P"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "P: " + tmp + " lbs", normalFont); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_fert_ins_K"))).ToString("#,###.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } PdfReports.AddText2Table(table, "K: " + tmp + " lbs", normalFont); PdfReports.AddText2Table(table, "", normalFont); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Start Fert Block (mostly) // ====================================================== tmpLayout = new float[] { 170F, 370F }; table = PdfReports.CreateTable(tmpLayout, 0); // Starter fert para = new Paragraph(); phrase = new Phrase("Starter Fertilizer: ", labelFont); para.Add(phrase); tmp = dr.GetString(dr.GetOrdinal("fld_fert_starter")); if (tmp.Length == 0) { tmp = @"Yes \ No"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); PdfReports.AddText2Table(table, "", normalFont); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Insecticide Block // ====================================================== tmpLayout = new float[] { 170F, 370F }; table = PdfReports.CreateTable(tmpLayout, 0); // pre-emerg. insect. para = new Paragraph(); phrase = new Phrase("Pre-Emergence Insecticide: ", labelFont); para.Add(phrase); tmp = dr.GetString(dr.GetOrdinal("fld_pre_insecticide")); if (tmp.Length == 0) { tmp = @"Yes \ No"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); // post.emerg. insect. para = new Paragraph(); phrase = new Phrase("Post-Emergence Insecticide: ", labelFont); para.Add(phrase); tmp = dr.GetString(dr.GetOrdinal("fld_post_insectcide")); if (tmp.Length == 0) { tmp = @"Yes \ No"; } phrase = new Phrase(tmp, normalFont); para.Add(phrase); PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Root Maggot Block // ====================================================== tmpLayout = new float[] { 170F, 123F, 123F, 124F }; table = PdfReports.CreateTable(tmpLayout, 0); para = new Paragraph(); para.Add(new Phrase("Insecticide-Root Maggot: ", labelFont)); tmp = dr.GetString(dr.GetOrdinal("fld_root_maggot_insecticide")); if (tmp == "") { tmp = @"Yes \ No"; } para.Add(new Phrase(tmp, normalFont)); PdfReports.AddText2Table(table, para); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_rootm_counter_lbs"))).ToString("#.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } tmp = "Counter 15G: " + tmp + " lbs/A"; PdfReports.AddText2Table(table, tmp, normalFont); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_rootm_temik_lbs"))).ToString("#.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } tmp = "Temik: " + tmp + " lbs/A"; PdfReports.AddText2Table(table, tmp, normalFont); tmp = (dr.GetDecimal(dr.GetOrdinal("fld_rootm_thimet_lbs"))).ToString("#.#"); if (tmp.Length > 0 && Decimal.Parse(tmp) == 0) { tmp = ""; } if (tmp.Length == 0) { tmp = "______"; } tmp = "Thimet: " + tmp + " lbs/A"; PdfReports.AddText2Table(table, tmp, normalFont); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Weed Control Block // ====================================================== tmpLayout = new float[] { 170F, 370F }; table = PdfReports.CreateTable(tmpLayout, 0); para = new Paragraph(); para.Add(new Phrase("Pre-Emergence Weed Control: ", labelFont)); string origAnswer = (dr.GetString(dr.GetOrdinal("fld_pre_weed_ctrl"))).ToString(); string displayAnswer = origAnswer; if (displayAnswer.Length == 0) { displayAnswer = @"Yes \ No"; } para.Add(new Phrase(displayAnswer, normalFont)); PdfReports.AddText2Table(table, para); // Number of Herbicide RX para = new Paragraph(); phrase = new Phrase("Number of Herbicide Treatments: ", labelFont); para.Add(phrase); tmp = dr.GetInt32(dr.GetOrdinal("fld_herbicide_rx_count")).ToString(); if (tmp.Length > 0 && tmp != "0") { phrase = new Phrase(tmp, normalFont); para.Add(phrase); } else { values = new ArrayList(); foreach (TItem item in agronomy.HerbicideRxCountList.Items) { if (item.Name.Length > 0 && item.Name != "0") { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Layby Herbicide Block // ===================================================== tmpLayout = new float[] { 170F, 370F }; table = PdfReports.CreateTable(tmpLayout, 0); PdfReports.AddText2Table(table, "Layby Herbicide: ", labelFont); para = new Paragraph(); tmp = dr.GetString(dr.GetOrdinal("fld_layby_herbicide_chemical")); if (tmp.Length > 0) { para.Add(new Phrase(tmp, normalFont)); } else { values = new ArrayList(); foreach (TItem item in agronomy.LaybyHerbicideList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Cercospora Program Block // ====================================================== tmpLayout = new float[] { 170F, 250F, 120F }; table = PdfReports.CreateTable(tmpLayout, 0); PdfReports.AddText2Table(table, "Cercospora Program: ", labelFont); PdfReports.AddText2Table(table, "", normalFont); PdfReports.AddText2Table(table, "", normalFont); // Get values array for any missing chemical entries values = new ArrayList(); foreach (TItem item in agronomy.CercosporaChemList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } // Application #1 cell = new iTextSharp.text.pdf.PdfPCell(new Phrase("Application 1 Chemical: ", labelFont)); cell.BorderWidth = 0; cell.HorizontalAlignment = Element.ALIGN_CENTER; table.AddCell(cell); tmp = dr.GetString(dr.GetOrdinal("fld_cercsp_app1_chemical")); para = new Paragraph(); if (tmp.Length == 0) { PdfReports.AddValues2Paragraph(para, values, normalFont); } else { para.Add(new Phrase(tmp, normalFont)); } PdfReports.AddText2Table(table, para); tmp = dr.GetString(dr.GetOrdinal("fld_cercospora_app1_date")); if (tmp.Length == 0) { tmp = "____________"; } para = new Paragraph(); para.Add(new Phrase("Date: ", labelFont)); para.Add(new Phrase(tmp, normalFont)); PdfReports.AddText2Table(table, para); // Application #2 cell = new iTextSharp.text.pdf.PdfPCell(new Phrase("Application 2 Chemical: ", labelFont)); cell.BorderWidth = 0; cell.HorizontalAlignment = Element.ALIGN_CENTER; table.AddCell(cell); tmp = dr.GetString(dr.GetOrdinal("fld_cercsp_app2_chemical")); para = new Paragraph(); if (tmp.Length == 0) { PdfReports.AddValues2Paragraph(para, values, normalFont); } else { para.Add(new Phrase(tmp, normalFont)); } PdfReports.AddText2Table(table, para); tmp = dr.GetString(dr.GetOrdinal("fld_cercospora_app2_date")); if (tmp.Length == 0) { tmp = "____________"; } para = new Paragraph(); para.Add(new Phrase("Date: ", labelFont)); para.Add(new Phrase(tmp, normalFont)); PdfReports.AddText2Table(table, para); // Application #3 cell = new iTextSharp.text.pdf.PdfPCell(new Phrase("Application 3 Chemical: ", labelFont)); cell.BorderWidth = 0; cell.HorizontalAlignment = Element.ALIGN_CENTER; table.AddCell(cell); tmp = dr.GetString(dr.GetOrdinal("fld_cercsp_app3_chemical")); para = new Paragraph(); if (tmp.Length == 0) { PdfReports.AddValues2Paragraph(para, values, normalFont); } else { para.Add(new Phrase(tmp, normalFont)); } PdfReports.AddText2Table(table, para); tmp = dr.GetString(dr.GetOrdinal("fld_cercospora_app3_date")); if (tmp.Length == 0) { tmp = "____________"; } para = new Paragraph(); para.Add(new Phrase("Date: ", labelFont)); para.Add(new Phrase(tmp, normalFont)); PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Powdery Mildew Block // ====================================================== tmpLayout = new float[] { 170F, 180F, 190F }; table = PdfReports.CreateTable(tmpLayout, 0); para = new Paragraph(); para.Add(new Phrase("Treated for Powdery Mildew: ", labelFont)); tmp = dr.GetString(dr.GetOrdinal("fld_treated_powdery_mildew")); if (tmp.Length == 0) { tmp = @"Yes \ No"; } para.Add(new Phrase(tmp, normalFont)); PdfReports.AddText2Table(table, para); // Hail para = new Paragraph(); para.Add(new Phrase("Hail Stress: ", labelFont)); tmp = dr.GetString(dr.GetOrdinal("fld_hail_stress")); if (tmp.Length == 0) { values = new ArrayList(); foreach (TItem item in agronomy.HailStressList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } else { para.Add(new Phrase(tmp, normalFont)); } PdfReports.AddText2Table(table, para); // Weed Control para = new Paragraph(); para.Add(new Phrase("Weed Control: ", labelFont)); tmp = dr.GetString(dr.GetOrdinal("fld_weed_control")); if (tmp.Length == 0) { values = new ArrayList(); foreach (TItem item in agronomy.WeedControlList.Items) { if (item.Name.Length > 0) { values.Add(item.Name); } } PdfReports.AddValues2Paragraph(para, values, normalFont); } else { para.Add(new Phrase(tmp, normalFont)); } PdfReports.AddText2Table(table, para); //PdfReports.AddText2Table(table, new Paragraph(" \n ", new Font(Font.HELVETICA, NewLineHeight)), tmpLayout.Length); //PdfReports.AddText2Table(table, " ", normalFont, tmpLayout.Length); //PdfReports.AddTableNoSplit(document, pgEvent, table); // ====================================================== // Nematode \ Rhizoctonia Block // ====================================================== //tmpLayout = new float[] { 170F, 370F }; //table = PdfReports.CreateTable(tmpLayout, 0); // Nematode para = new Paragraph(); para.Add(new Phrase("Treated for Nematode: ", labelFont)); tmp = dr.GetString(dr.GetOrdinal("fld_treated_nematode")); if (tmp.Length == 0) { tmp = @"Yes \ No"; } para.Add(new Phrase(tmp, normalFont)); PdfReports.AddText2Table(table, para); // Rhizoctonia para = new Paragraph(); para.Add(new Phrase("Treated for Rhizoctonia: ", labelFont)); tmp = dr.GetString(dr.GetOrdinal("fld_treated_rhizoctonia")); if (tmp.Length == 0) { tmp = @"Yes \ No"; } para.Add(new Phrase(tmp, normalFont)); PdfReports.AddText2Table(table, para); PdfReports.AddText2Table(table, " ", normalFont); PdfReports.AddTableNoSplit(document, pgEvent, table); } catch (System.Exception ex) { WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(METHOD_NAME, ex); throw (wscEx); } } // ====================================================== // Close document // ====================================================== if (document != null) { pgEvent.IsDocumentClosing = true; document.Close(); document = null; } if (writer == null) { // Warn that we have no data. WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("No records matched your report criteria."); throw (warn); } } catch (Exception ex) { string errMsg = "document is null: " + (document == null).ToString() + "; " + "writer is null: " + (writer == null).ToString(); WSCIEMP.Common.CException wscex = new WSCIEMP.Common.CException(METHOD_NAME + errMsg, ex); throw (wscex); } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } } if (drLandDesc != null) { if (!drLandDesc.IsClosed) { drLandDesc.Close(); } } if (document != null) { pgEvent.IsDocumentClosing = true; document.Close(); } if (writer != null) { writer.Close(); } } }
public static byte[] GuildStorageData(character c) { Systems.MsSQL getstorage = new Systems.MsSQL("SELECT * FROM char_items WHERE guild_storage_id='" + c.Network.Guild.Guildid + "' AND storagetype='3'"); int itemcount = getstorage.Count(); PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_GUILD_STORAGE3); Writer.Byte(c.Network.Guild.StorageSlots); Writer.Byte(itemcount); if (itemcount != 0) { using (System.Data.SqlClient.SqlDataReader reader = getstorage.Read()) { while (reader.Read()) { Item.AddItemPacket(Writer, reader.GetByte(5), reader.GetInt32(2), reader.GetByte(4), reader.GetInt16(6), reader.GetInt32(7), reader.GetInt32(0), reader.GetInt32(9), reader.GetInt32(30)); } } } getstorage.Close(); return(Writer.GetBytes()); }
private static List<iSearch_Title_Result> DataReader_To_Simple_Result_List2(SqlDataReader Reader, List<string> Metadata_Field_Names) { // Create return list List<iSearch_Title_Result> returnValue = new List<iSearch_Title_Result>(); // Create some lists used during the construction Dictionary<int, Database_Title_Result> titleLookupByRowNumber = new Dictionary<int, Database_Title_Result>(); Dictionary<int, Database_Item_Result> itemLookupByItemID = new Dictionary<int, Database_Item_Result>(); Dictionary<int, int> rowNumberLookupByItemID = new Dictionary<int, int>(); // May have not values returned if (Reader.FieldCount < 5) return null; // Get all the main title values first int minimumRownumber = -1; while (Reader.Read()) { // Create new database title object for this Database_Title_Result result = new Database_Title_Result { RowNumber = Reader.GetInt32(0), BibID = Reader.GetString(1), GroupTitle = Reader.GetString(2), OPAC_Number = Reader.GetInt32(3), OCLC_Number = Reader.GetInt64(4), GroupThumbnail = Reader.GetString(5), MaterialType = Reader.GetString(6), Primary_Identifier_Type = Reader.GetString(7), Primary_Identifier = Reader.GetString(8) }; titleLookupByRowNumber.Add(result.RowNumber, result); if (minimumRownumber == -1) { minimumRownumber = result.RowNumber; } } // Move to the item system-required information table Reader.NextResult(); // If there were no titles, then there are no results if (titleLookupByRowNumber.Count == 0) return returnValue; // Step through all the item rows, build the item, and add to the title Database_Title_Result titleResult = titleLookupByRowNumber[minimumRownumber]; returnValue.Add(titleResult); int lastRownumber = titleResult.RowNumber; while (Reader.Read()) { // Ensure this is the right title for this item int thisRownumber = Reader.GetInt32(0); if (thisRownumber != lastRownumber) { titleResult = titleLookupByRowNumber[thisRownumber]; lastRownumber = thisRownumber; // Add this title to the list returnValue.Add(titleResult); } // Create new database item object for this Database_Item_Result result = new Database_Item_Result { ItemID = Reader.GetInt32(1), VID = Reader.GetString(2), Title = Reader.GetString(3), IP_Restriction_Mask = Reader.GetInt16(4), MainThumbnail = Reader.GetString(5), Level1_Index = (short)Reader.GetInt32(6), Level1_Text = Reader.GetString(7), Level2_Index = (short)Reader.GetInt32(8), Level2_Text = Reader.GetString(9), Level3_Index = (short)Reader.GetInt32(10), Level3_Text = Reader.GetString(11), PubDate = Reader.GetString(12), PageCount = Reader.GetInt32(13), Link = Reader.GetString(14), Spatial_KML = Reader.GetString(15), COinS_OpenURL = Reader.GetString(16) }; // Save to the hash lookup for adding display metadata itemLookupByItemID[result.ItemID] = result; rowNumberLookupByItemID[result.ItemID] = thisRownumber; // Add this to the title object titleResult.Add_Item_Result(result); } // Move to the item aggregation-configured display information table Reader.NextResult(); // Set some values for checking for uniformity of values const int ITEMS_TO_CHECK_IN_EACH_TITLE = 20; bool first_item_analyzed = true; List<bool> checking_fields = new List<bool>(); int display_fields_count = 0; int itemcount = 0; int lastRowNumber = -1; while (Reader.Read()) { // Get the item id and then work back to the local title id int itemId = Reader.GetInt32(0); int rowNumber = rowNumberLookupByItemID[itemId]; // If this is the very first item analyzed, need to do some work first if (first_item_analyzed) { // Save the number of display fields display_fields_count = Reader.FieldCount - 1; // Add a boolean for each display field for (int i = 0; i < display_fields_count; i++) { // Add the default boolean value here checking_fields.Add(true); // Save the metadata label Metadata_Field_Names.Add(Reader.GetName(i + 1)); } // Done with the first row analysis, so ensure it does not repeat first_item_analyzed = false; } // Is this is the start of a new title row? if (lastRowNumber != rowNumber) { // Get this title object titleResult = titleLookupByRowNumber[rowNumber]; // Set items analyzed for this title to zero itemcount = 0; // Back to checking each metadata field since this is a new title for (int i = 0; i < display_fields_count; i++) checking_fields[i] = true; // Save this row numbe as the last row number analyzed lastRowNumber = rowNumber; } if (itemcount == 0) { // Set all the initial display values (at the title level) from // this item's display information titleResult.Metadata_Display_Values = new string[display_fields_count]; for (int i = 0; i < display_fields_count; i++) { titleResult.Metadata_Display_Values[i] = Reader.GetString(i + 1); } } else if (itemcount < ITEMS_TO_CHECK_IN_EACH_TITLE) { // Compare the values attached with each display piece of metadata // from the title with this additional, individual item. If the // values are the same, it should display at the title level, but // if they are different, we will not display the values at that level for (int i = 0; i < display_fields_count; i++) { // If we already found a mismatch for this metadata field, then // no need to continue checking if (checking_fields[i]) { if (String.Compare(titleResult.Metadata_Display_Values[i], Reader.GetString(i + 1), StringComparison.InvariantCultureIgnoreCase) != 0) { titleResult.Metadata_Display_Values[i] = "*"; checking_fields[i] = false; } } } } } return returnValue; }
private static void ReportBuilder(SqlDataReader drPay, int cropYear, int paymentNumber, string paymentDescription, string fromDate, string toDate, string statementDate, bool isCumulative, string logoUrl, System.IO.FileStream fs) { const string METHOD_NAME = "rptTransmittal.ReportBuilder: "; const int resetFlag = 0; Document document = null; PdfWriter writer = null; PdfPTable table = null; TransmittalReportEvent pgEvent = null; iTextSharp.text.Image imgLogo = null; int contractNumber = 0; int lastContractNumber = 0; int payeeNumber = 0; int lastPayeeNumber = 0; decimal ytdEHBonus = 0; decimal ytdEHAmount = 0; decimal ytdRHAmount = 0; decimal ytdDeductions = 0; decimal ytdEHAmountMoved = 0; decimal ytdRHAmountMoved = 0; decimal ytdNet = 0; decimal curSLM = 0; decimal pctPaid = 0; decimal actualSugar = 0; string rptTitle = "Western Sugar Cooperative Payment Transmittal"; Font headerFont = FontFactory.GetFont("HELVETICA", 8F, Font.NORMAL); Font normalFont = FontFactory.GetFont("HELVETICA", 8F, Font.NORMAL); Font labelFont = FontFactory.GetFont("HELVETICA", 8F, Font.BOLD); try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) { while (drPay.Read()) { try { contractNumber = Convert.ToInt32(drPay.GetString(drPay.GetOrdinal("Contract_Number"))); payeeNumber = drPay.GetInt16(drPay.GetOrdinal("Payee_Number")); if (document == null) { lastContractNumber = contractNumber; lastPayeeNumber = payeeNumber; // IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!! // *** US LETTER: 612 X 792 *** //document = new Document(iTextSharp.text.PageSize.LETTER, 36, 36, 54, 72); document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin, PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin, PortraitPageSize.PgBottomMargin); // we create a writer that listens to the document // and directs a PDF-stream to a file writer = PdfWriter.GetInstance(document, fs); imgLogo = PdfReports.GetImage(logoUrl, 127, 50, iTextSharp.text.Element.ALIGN_CENTER); // Attach my override event handler(s) pgEvent = new TransmittalReportEvent(); pgEvent.FillEvent(drPay, cropYear, statementDate, resetFlag, rptTitle, paymentDescription, imgLogo); writer.PageEvent = pgEvent; // Open the document document.Open(); } else { if (contractNumber != lastContractNumber || payeeNumber != lastPayeeNumber) { ytdEHBonus = 0; ytdEHAmount = 0; ytdRHAmount = 0; ytdDeductions = 0; ytdNet = 0; ytdEHAmountMoved = 0; ytdRHAmountMoved = 0; lastContractNumber = contractNumber; if (payeeNumber != lastPayeeNumber) { lastPayeeNumber = payeeNumber; } pgEvent.FillEvent(drPay, cropYear, statementDate, resetFlag, rptTitle, paymentDescription, imgLogo); document.NewPage(); } } // ======================================================= // Add Payment Detail // ======================================================= table = PdfReports.CreateTable(_primaryTableLayout, 1); PdfReports.AddText2Table(table, drPay.GetString(drPay.GetOrdinal("Payment_Description")) + " Payment", labelFont, 8); // Header PdfReports.AddText2Table(table, " ", labelFont); PdfReports.AddText2Table(table, "SLM", labelFont, "center"); PdfReports.AddText2Table(table, "% Sugar", labelFont); PdfReports.AddText2Table(table, "% Paid", labelFont); PdfReports.AddText2Table(table, "Price/Ton", labelFont); PdfReports.AddText2Table(table, "Tons", labelFont); PdfReports.AddText2Table(table, "YTD Amount", labelFont); PdfReports.AddText2Table(table, "Current Amount", labelFont); // EH Premium PdfReports.AddText2Table(table, "Early Harvest Premium", labelFont, "left"); PdfReports.AddText2Table(table, " ", labelFont); PdfReports.AddText2Table(table, " ", labelFont); PdfReports.AddText2Table(table, " ", labelFont); PdfReports.AddText2Table(table, " ", labelFont); PdfReports.AddText2Table(table, " ", labelFont); if (isCumulative) { ytdEHBonus += drPay.GetDecimal(drPay.GetOrdinal("EH_Bonus")); } else { ytdEHBonus = drPay.GetDecimal(drPay.GetOrdinal("ncYtdEhBonus")); } PdfReports.AddText2Table(table, ytdEHBonus.ToString("$#,##0.00"), normalFont); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("EH_Bonus")).ToString("$#,##0.00"), normalFont); // Early Harvest actualSugar = drPay.GetDecimal(drPay.GetOrdinal("EH_Sugar")); curSLM = drPay.GetDecimal(drPay.GetOrdinal("EH_SLM")); pctPaid = drPay.GetDecimal(drPay.GetOrdinal("Pct_EH_Paid")); PdfReports.AddText2Table(table, "Early Harvest ", labelFont, "left"); if (drPay.GetDecimal(drPay.GetOrdinal("EH_SLM")) != 0) { PdfReports.AddText2Table(table, curSLM.ToString("N4"), normalFont, "center"); } else { PdfReports.AddText2Table(table, "------", normalFont, "center"); } if (drPay.GetDecimal(drPay.GetOrdinal("EH_Sugar")) != 0) { PdfReports.AddText2Table(table, actualSugar.ToString("N2"), normalFont); } else { PdfReports.AddText2Table(table, "------", normalFont); } if (drPay.GetDecimal(drPay.GetOrdinal("Pct_EH_Paid")) != 0) { PdfReports.AddText2Table(table, pctPaid.ToString("N3"), normalFont); } else { PdfReports.AddText2Table(table, "------", normalFont); } if (drPay.GetDecimal(drPay.GetOrdinal("EH_Price")) != 0) { PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("EH_Price")).ToString("$#,##0.000"), normalFont); } else { PdfReports.AddText2Table(table, "------", normalFont); } if (drPay.GetDecimal(drPay.GetOrdinal("EH_Tons")) != 0 || drPay.GetDecimal(drPay.GetOrdinal("EH_tons_moved")) != 0) { PdfReports.AddText2Table(table, (drPay.GetDecimal(drPay.GetOrdinal("EH_Tons")) - drPay.GetDecimal(drPay.GetOrdinal("EH_tons_moved"))).ToString("N4"), normalFont); } else { PdfReports.AddText2Table(table, "------", normalFont); } if (isCumulative) { ytdEHAmount += drPay.GetDecimal(drPay.GetOrdinal("EH_Gross_Pay")) - drPay.GetDecimal(drPay.GetOrdinal("EH_amt_moved")); } else { ytdEHAmount = drPay.GetDecimal(drPay.GetOrdinal("ncYtdEhGrossPay")) - drPay.GetDecimal(drPay.GetOrdinal("ncYtdEhAmtMoved")); } PdfReports.AddText2Table(table, ytdEHAmount.ToString("$#,##0.00"), normalFont); PdfReports.AddText2Table(table, (drPay.GetDecimal(drPay.GetOrdinal("EH_Gross_Pay")) - drPay.GetDecimal(drPay.GetOrdinal("EH_amt_moved"))).ToString("$#,##0.00"), normalFont); // Regular Harvest actualSugar = drPay.GetDecimal(drPay.GetOrdinal("RH_Sugar")); curSLM = drPay.GetDecimal(drPay.GetOrdinal("RH_SLM")); pctPaid = drPay.GetDecimal(drPay.GetOrdinal("Pct_RH_Paid")); PdfReports.AddText2Table(table, "Regular Harvest ", labelFont, "left"); PdfReports.AddText2Table(table, curSLM.ToString("N4"), normalFont, "center"); PdfReports.AddText2Table(table, actualSugar.ToString("N2"), normalFont); PdfReports.AddText2Table(table, pctPaid.ToString("N3"), normalFont); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("RH_Price")).ToString("$#,##0.000"), normalFont); PdfReports.AddText2Table(table, (drPay.GetDecimal(drPay.GetOrdinal("RH_Tons")) - drPay.GetDecimal(drPay.GetOrdinal("RH_Tons_moved"))).ToString("N4"), normalFont); if (isCumulative) { ytdRHAmount += drPay.GetDecimal(drPay.GetOrdinal("RH_Gross_Pay")) - drPay.GetDecimal(drPay.GetOrdinal("RH_amt_moved")); } else { ytdRHAmount = drPay.GetDecimal(drPay.GetOrdinal("ncYtdRhGrossPay")) - drPay.GetDecimal(drPay.GetOrdinal("ncYtdRhAmtMoved")); } // YTD Amount PdfReports.AddText2Table(table, ytdRHAmount.ToString("$#,##0.00"), normalFont); // Current Amount PdfReports.AddText2Table(table, (drPay.GetDecimal(drPay.GetOrdinal("RH_Gross_Pay")) - drPay.GetDecimal(drPay.GetOrdinal("RH_amt_moved"))).ToString("$#,##0.00"), normalFont); // Reduced Early Harvest PdfReports.AddText2Table(table, "Reduced Early Harvest Excess Beets ", labelFont, "left", 4); PdfReports.AddText2Table(table, " ", normalFont); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("EH_tons_moved")).ToString("#,#.0000;(#,#.0000)"), normalFont); if (isCumulative) { ytdEHAmountMoved += drPay.GetDecimal(drPay.GetOrdinal("EH_amt_moved")); } else { ytdEHAmountMoved = drPay.GetDecimal(drPay.GetOrdinal("ncYtdEhAmtMoved")); } PdfReports.AddText2Table(table, ytdEHAmountMoved.ToString("$#,#.00;$(#,#.00)"), normalFont); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("EH_amt_moved")).ToString("$#,#.00;$(#,#.00)"), normalFont); // Reduced Regular Harvest PdfReports.AddText2Table(table, "Reduced Regular Harvest Excess Beets", labelFont, "left", 4); PdfReports.AddText2Table(table, " ", normalFont); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("RH_tons_moved")).ToString("#,#.0000;(#,#.0000)"), normalFont); if (isCumulative) { ytdRHAmountMoved += drPay.GetDecimal(drPay.GetOrdinal("RH_amt_moved")); } else { ytdRHAmountMoved = drPay.GetDecimal(drPay.GetOrdinal("ncYtdRhAmtMoved")); } PdfReports.AddText2Table(table, ytdRHAmountMoved.ToString("$#,#.00;$(#,#.00)"), normalFont); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("RH_amt_moved")).ToString("$#,#.00;$(#,#.00)"), normalFont); PdfReports.AddText2Table(table, " ", normalFont, 8); // Total lines // YTD Amount PdfReports.AddText2Table(table, " ", normalFont, 4); PdfReports.AddText2Table(table, "Total Gross Amount: ", labelFont, "right", 2); PdfReports.AddText2Table(table, ((ytdEHBonus + ytdEHAmount + ytdRHAmount) + ytdEHAmountMoved + ytdRHAmountMoved //+ drPay.GetDecimal(drPay.GetOrdinal("ncYtdEhAmtMoved")) //+ drPay.GetDecimal(drPay.GetOrdinal("ncYtdRhAmtMoved")) ).ToString("#,##0.00"), normalFont); // Current Amount PdfReports.AddText2Table(table, (drPay.GetDecimal(drPay.GetOrdinal("EH_Bonus")) + drPay.GetDecimal(drPay.GetOrdinal("EH_Gross_Pay")) + drPay.GetDecimal(drPay.GetOrdinal("RH_Gross_Pay")) //+ //drPay.GetDecimal(drPay.GetOrdinal("EH_amt_moved")) + //drPay.GetDecimal(drPay.GetOrdinal("RH_amt_moved")) ).ToString("#,##0.00"), normalFont); PdfReports.AddText2Table(table, " ", normalFont, 5); PdfReports.AddText2Table(table, "Deduction Total: ", labelFont, "right"); if (isCumulative) { ytdDeductions += drPay.GetDecimal(drPay.GetOrdinal("Deduct_Total")); } else { ytdDeductions = drPay.GetDecimal(drPay.GetOrdinal("ncYtdDeductTotal")); } PdfReports.AddText2Table(table, ytdDeductions.ToString("#,##0.00"), normalFont); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("Deduct_Total")).ToString("#,##0.00"), normalFont); PdfReports.AddText2Table(table, " ", normalFont, 5); PdfReports.AddText2Table(table, "Net Payment: ", labelFont, "right"); decimal currentNet = drPay.GetDecimal(drPay.GetOrdinal("EH_Bonus")) + drPay.GetDecimal(drPay.GetOrdinal("EH_Gross_Pay")) + drPay.GetDecimal(drPay.GetOrdinal("RH_Gross_Pay")) //drPay.GetDecimal(drPay.GetOrdinal("EH_amt_moved")) //drPay.GetDecimal(drPay.GetOrdinal("RH_amt_moved")) - drPay.GetDecimal(drPay.GetOrdinal("Deduct_Total")); if (isCumulative) { ytdNet += currentNet; } else { ytdNet = drPay.GetDecimal(drPay.GetOrdinal("ncYtdEhBonus")) + drPay.GetDecimal(drPay.GetOrdinal("ncYtdEhGrossPay")) + drPay.GetDecimal(drPay.GetOrdinal("ncYtdRhGrossPay")) //drPay.GetDecimal(drPay.GetOrdinal("ncYtdEhAmtMoved")) //drPay.GetDecimal(drPay.GetOrdinal("ncYtdRhAmtMoved")) - drPay.GetDecimal(drPay.GetOrdinal("ncYtdDeductTotal")); } PdfReports.AddText2Table(table, ytdNet.ToString("#,##0.00"), normalFont); PdfReports.AddText2Table(table, currentNet.ToString("#,##0.00"), normalFont); PdfReports.AddText2Table(table, " ", normalFont, 8); PdfReports.AddText2Table(table, " ", normalFont, 6); PdfReports.AddText2Table(table, "Grower Net: ", labelFont, "right"); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("Payment_Amount")).ToString("#,##0.00"), normalFont); PdfReports.AddText2Table(table, " ", normalFont, 6); PdfReports.AddText2Table(table, "Landowner Net: ", labelFont, "right"); PdfReports.AddText2Table(table, drPay.GetDecimal(drPay.GetOrdinal("Split_Payment")).ToString("#,##0.00"), normalFont); PdfReports.AddText2Table(table, " ", normalFont, 8); PdfReports.AddTableNoSplit(document, pgEvent, table); if (paymentNumber == drPay.GetInt16(drPay.GetOrdinal("Payment_Number"))) { //================================================================ // Add Deduction information //================================================================ table = PdfReports.CreateTable(_primaryTableLayout, 1); using (SqlDataReader drDed = WSCPayment.GetTransmittalDeduction(conn, cropYear, contractNumber, drPay.GetInt16(drPay.GetOrdinal("Payment_Number")), isCumulative)) { PdfReports.AddText2Table(table, "Deduction", labelFont, 5); PdfReports.AddText2Table(table, "Payment", labelFont); PdfReports.AddText2Table(table, "Amount", labelFont); PdfReports.AddText2Table(table, " ", labelFont); while (drDed.Read()) { PdfReports.AddText2Table(table, drDed.GetString(drDed.GetOrdinal("Deduction_Desc")), normalFont, 5); PdfReports.AddText2Table(table, drDed.GetString(drDed.GetOrdinal("Payment_Description")), normalFont); PdfReports.AddText2Table(table, drDed.GetDecimal(drDed.GetOrdinal("Amount")).ToString("$#,##0.00"), normalFont); PdfReports.AddText2Table(table, " ", labelFont); } PdfReports.AddText2Table(table, " ", normalFont, 8); PdfReports.AddTableNoSplit(document, pgEvent, table); } //================================================================ // Add Delivery information //================================================================ float[] deliveryLayout = new float[] { 110.8F, 110.8F, 55.4F, 110.8F, 55.4F, 55.4F, 55.4F }; table = PdfReports.CreateTable(deliveryLayout, 1); List<TransmittalDeliveryItem> deliveryList = WSCPayment.GetTransmittalDelivery(cropYear, contractNumber, paymentNumber, fromDate, toDate); PdfReports.AddText2Table(table, "Delivery Date", labelFont); PdfReports.AddText2Table(table, "First Net Pounds", labelFont); PdfReports.AddText2Table(table, "Tare %", labelFont); PdfReports.AddText2Table(table, "Final Net Lbs", labelFont); PdfReports.AddText2Table(table, "Sugar %", labelFont); PdfReports.AddText2Table(table, "SLM", labelFont); PdfReports.AddText2Table(table, "Loads", labelFont); foreach (TransmittalDeliveryItem deliveryDay in deliveryList) { PdfReports.AddText2Table(table, deliveryDay.Delivery_Date.ToShortDateString(), normalFont); PdfReports.AddText2Table(table, deliveryDay.First_Net_Pounds.ToString("###,###"), normalFont); PdfReports.AddText2Table(table, deliveryDay.Tare.ToString("N2"), normalFont); PdfReports.AddText2Table(table, deliveryDay.Final_Net_Pounds.ToString("###,###"), normalFont); PdfReports.AddText2Table(table, deliveryDay.Sugar_Content.ToString("N2"), normalFont); PdfReports.AddText2Table(table, deliveryDay.SLM_Pct.ToString("N4"), normalFont); PdfReports.AddText2Table(table, deliveryDay.Loads.ToString(), normalFont); } PdfReports.AddText2Table(table, " ", normalFont, 6); PdfReports.AddTableNoSplit(document, pgEvent, table); } } catch (System.Exception ex) { WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(METHOD_NAME, ex); throw (wscEx); } } } // ====================================================== // Close document // ====================================================== if (document != null) { document.Close(); document = null; } if (writer == null) { // Warn that we have no data. WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("No records matched your report criteria."); throw (warn); } } catch (Exception ex) { string errMsg = "document is null: " + (document == null).ToString() + "; " + "writer is null: " + (writer == null).ToString(); WSCIEMP.Common.CException wscex = new WSCIEMP.Common.CException(METHOD_NAME + errMsg, ex); throw (wscex); } finally { if (document != null) { document.Close(); } if (drPay != null) { if (!drPay.IsClosed) { drPay.Close(); } } if (writer != null) { writer.Close(); } } }
public static ReplyInfo CopyReplyToBO(SqlDataReader rdr) { ReplyInfo reply = new ReplyInfo { Id = rdr.GetInt32(0), CatId = rdr.GetInt32(1), ForumId = rdr.GetInt32(2), TopicId = rdr.GetInt32(3), AuthorId = rdr.GetInt32(4), Date = rdr.GetString(5).ToDateTime().Value, PosterIp = rdr.SafeGetString(6), Status = rdr.GetInt16(7), LastEditDate = rdr.SafeGetString(8).ToDateTime(), LastEditedById = rdr.SafeGetInt32(9), UseSignatures = rdr.GetInt16(10) == 1, Message = rdr.SafeGetString(11) }; if (rdr.FieldCount > 12) { reply.AuthorName = rdr.SafeGetString(12); reply.EditorName = rdr.SafeGetString(13); reply.AuthorViewSig = rdr.GetInt16(14) == 1; reply.AuthorSignature = rdr.SafeGetString(15); } return reply; }
public static SearchResult CopySearchResultToBO(SqlDataReader rdr, ref int rowcount) { SearchResult result = new SearchResult() { CategoryStatus = rdr.GetInt16(1), CategorySubscriptionLevel = rdr.GetInt32(2), CategoryTitle = rdr.SafeGetString(3), ForumSubject = rdr.SafeGetString(4), ForumSubscriptionLevel = rdr.GetInt32(5), ForumStatus = rdr.GetInt16(6), ForumAccessType = rdr.GetInt32(7), ForumPassword = rdr.SafeGetString(8), CatId = rdr.GetInt32(9), ForumId = rdr.GetInt32(10), Id = rdr.GetInt32(11), AuthorId = rdr.GetInt32(12), Subject = rdr.SafeGetString(13), Status = rdr.GetInt16(14), LastPostDate = rdr.GetSnitzDate(15), LastPostAuthorId = rdr.SafeGetInt32(16), LastReplyId = rdr.SafeGetInt32(17), ReplyCount = rdr.GetInt32(18), UnModeratedReplies = rdr.GetInt32(19), Views = rdr.GetInt32(20), AuthorName = rdr.SafeGetString(22), LastPostAuthorName = rdr.SafeGetString(23) }; rowcount = rdr.GetInt32(24); return result; }
// Jika tidak menggunakan constructor // hapus pada baris yg di comment // ==================================== // | Alt + Insert untuk meng-generate | // | construktor dari class yg dibuat | // ==================================== public string PengecekField(SqlDataReader hasilPembaca, byte kolom) { string hasil = ""; if (hasilPembaca.IsDBNull(kolom)) { if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Byte") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Boolean") hasil = "false"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int32") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int16") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.String") hasil = ""; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Decimal") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int64") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.DateTime") hasil = "0"; else { MessageBox.Show(Resources.CAlat_PengecekField_Tipe_data_tidak_di_kenali, Resources.CAlat_PengecekField_Infomasi, MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Byte") hasil = hasilPembaca.GetByte(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Boolean") hasil = hasilPembaca.GetBoolean(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int32") hasil = hasilPembaca.GetInt32(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int16") hasil = hasilPembaca.GetInt16(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.String") hasil = hasilPembaca.GetString(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Decimal") hasil = hasilPembaca.GetDecimal(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int64") hasil = hasilPembaca.GetInt64(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.DateTime") hasil = string.Format("{0:MM/dd/yyyy}", hasilPembaca.GetDateTime(kolom)); else { MessageBox.Show(Resources.CAlat_PengecekField_Tipe_data_tidak_di_kenali, Resources.CAlat_PengecekField_Infomasi, MessageBoxButtons.OK, MessageBoxIcon.Information); } } return hasil; }
/// <summary> /// Creates a new instance of the Productos_Objetivo_Detalle class and populates it with data from the specified SqlDataReader. /// </summary> private static Productos_Objetivo_DetalleInfo MakeProductos_Objetivo_Detalle(SqlDataReader dataReader) { Productos_Objetivo_DetalleInfo productos_Objetivo_Detalle = new Productos_Objetivo_DetalleInfo(); if (dataReader.IsDBNull(Cod_objetivo) == false) productos_Objetivo_Detalle.cod_objetivo = dataReader.GetInt32(Cod_objetivo); if (dataReader.IsDBNull(Cod_producto) == false) productos_Objetivo_Detalle.cod_producto = dataReader.GetInt32(Cod_producto); if (dataReader.IsDBNull(Muestras) == false) productos_Objetivo_Detalle.muestras = dataReader.GetInt16(Muestras); if (dataReader.IsDBNull(Orden) == false) productos_Objetivo_Detalle.orden = dataReader.GetInt16(Orden); if (dataReader.IsDBNull(SyncID) == false) productos_Objetivo_Detalle.SyncID = dataReader.GetGuid(SyncID); if (dataReader.IsDBNull(SyncTimeStamp) == false) productos_Objetivo_Detalle.SyncTimeStamp = DateTime.MinValue; return productos_Objetivo_Detalle; }
public static short getFieldValue(SqlDataReader dr, int ind, short def) { short val = def; if (!dr.IsDBNull(ind)) { System.TypeCode tp = System.Type.GetTypeCode(dr.GetFieldType(ind)); System.TypeCode typeCode = tp; switch (typeCode) { case System.TypeCode.Boolean: val = (dr.GetBoolean(ind) ? System.Convert.ToInt16(1) : System.Convert.ToInt16(0)); break; case System.TypeCode.Char: case System.TypeCode.SByte: case System.TypeCode.UInt16: break; case System.TypeCode.Byte: val = System.Convert.ToInt16(dr.GetByte(ind)); break; case System.TypeCode.Int16: val = dr.GetInt16(ind); break; case System.TypeCode.Int32: val = System.Convert.ToInt16(dr.GetInt32(ind)); break; default: if (typeCode == System.TypeCode.Decimal) { val = System.Convert.ToInt16(dr.GetDecimal(ind)); } break; } } return val; }
public static double getFieldValue(SqlDataReader dr, int ind, double def) { double val = def; if (!dr.IsDBNull(ind)) { switch (System.Type.GetTypeCode(dr.GetFieldType(ind))) { case System.TypeCode.Boolean: val = (dr.GetBoolean(ind) ? 1.0 : 0.0); break; case System.TypeCode.Int16: val = System.Convert.ToDouble(dr.GetInt16(ind)); break; case System.TypeCode.Int32: val = System.Convert.ToDouble(dr.GetInt32(ind)); break; case System.TypeCode.Int64: val = System.Convert.ToDouble(dr.GetInt64(ind)); break; case System.TypeCode.Single: val = System.Convert.ToDouble(dr.GetFloat(ind)); break; case System.TypeCode.Double: val = dr.GetDouble(ind); break; case System.TypeCode.Decimal: val = System.Convert.ToDouble(dr.GetDecimal(ind)); break; } } return val; }
public static string getFieldValue(SqlDataReader dr, int ind, string def) { string val = def; if (!dr.IsDBNull(ind)) { switch (System.Type.GetTypeCode(dr.GetFieldType(ind))) { case System.TypeCode.Boolean: val = (dr.GetBoolean(ind) ? "1" : "0"); break; case System.TypeCode.Int16: val = dr.GetInt16(ind).ToString(); break; case System.TypeCode.Int32: val = dr.GetInt32(ind).ToString(); break; case System.TypeCode.Int64: val = dr.GetInt64(ind).ToString(); break; case System.TypeCode.Single: val = dr.GetFloat(ind).ToString(); break; case System.TypeCode.Double: val = dr.GetDouble(ind).ToString(); break; case System.TypeCode.Decimal: val = dr.GetDecimal(ind).ToString(); break; case System.TypeCode.DateTime: val = DBManagerSQL.DBDateToFormatedDate(dr.GetDateTime(ind)); break; case System.TypeCode.String: val = dr.GetString(ind); break; } } return val; }
public static byte[] OpenWarehouse2(byte storageslots, player c) { PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_OPEN_WAREPROB); Writer.Byte(storageslots); Systems.MsSQL ms = new Systems.MsSQL("SELECT * FROM char_items WHERE storageacc='" + c.ID + "' AND storagetype='1'"); Writer.Byte(ms.Count()); using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { while (reader.Read()) { Item.AddItemPacket(Writer, reader.GetByte(5), reader.GetInt32(2), reader.GetByte(4), reader.GetInt16(6), reader.GetInt32(7), reader.GetInt32(0), reader.GetInt32(9), reader.GetInt32(30)); } } ms.Close(); return(Writer.GetBytes()); }
private IEnumerable<Tuple<int, SPParameter>> getParameters(SqlDataReader reader) { var index = reader.GetColumnLookup(); foreach (var r in reader) { var procId = reader.GetInt32(index["ProcedureId"]); var typeName = reader.GetString(index["t.name"]); var maxLength = reader.GetInt16(index["t.maxLen"]); var precision = reader.GetByte(index["t.precision"]); var scale = reader.GetByte(index["t.scale"]); var typeInfo = new DbTypeInfo(typeName, null, maxLength, precision, scale); var name = reader.GetString(index["Name"]); var position = reader.GetInt32(index["position"]); var isOutput = reader.GetBoolean(index["output"]); var isReadOnly = reader.GetBoolean(index["readonly"]); var defaultValue = reader.GetValue(index["defaultValue"]); var param = new SPParameter(name, typeInfo, position, isOutput, isReadOnly, defaultValue); yield return Tuple.Create(procId, param); } }
public static int GetSmallInt(string pColName,SqlDataReader pReader) { return pReader.GetInt16(pReader.GetOrdinal(pColName)); }
protected static void PopulateEntity(SqlDataReader reader, ServerEntity entity, Dictionary<string, PropertyInfo> propMap) { for (int i = 0; i < reader.FieldCount; i++) { String columnName = reader.GetName(i); // Special case for when we select a range of values with an EntityBroker, just ignore if (columnName.Equals("RowNum")) continue; if (columnName.Equals("GUID")) { Guid uid = reader.GetGuid(i); entity.SetKey(new ServerEntityKey(entity.Name, uid)); continue; } if (columnName.Equals(entity.Name) && columnName.Contains("Enum")) columnName = "Enum"; PropertyInfo prop; if (!propMap.TryGetValue(columnName, out prop)) throw new EntityNotFoundException("Unable to match column to property: " + columnName, null); if (columnName.Contains("GUID")) columnName = columnName.Replace("GUID", "Key"); if (reader.IsDBNull(i)) { prop.SetValue(entity, null, null); continue; } Type propType = prop.PropertyType; if (propType == typeof(String)) prop.SetValue(entity, reader.GetString(i), null); else if (propType == typeof(ServerEntityKey)) { Guid uid = reader.GetGuid(i); prop.SetValue(entity, new ServerEntityKey(columnName.Replace("Key", String.Empty), uid), null); } else if (propType == typeof(DateTime)) prop.SetValue(entity, reader.GetDateTime(i), null); else if (propType == typeof(DateTime?)) { if (reader.IsDBNull(i)) { prop.SetValue(entity, null, null); } else { prop.SetValue(entity, reader.GetDateTime(i), null); } } else if (propType == typeof(bool)) prop.SetValue(entity, reader.GetBoolean(i), null); else if (propType == typeof(Int32)) prop.SetValue(entity, reader.GetInt32(i), null); else if (propType == typeof(Int16)) prop.SetValue(entity, reader.GetInt16(i), null); else if (propType == typeof(double)) prop.SetValue(entity, reader.GetDouble(i), null); else if (propType == typeof(Decimal)) prop.SetValue(entity, reader.GetDecimal(i), null); else if (propType == typeof(float)) prop.SetValue(entity, reader.GetFloat(i), null); else if (propType == typeof(XmlDocument)) { SqlXml xml = reader.GetSqlXml(i); if (xml!=null && !xml.IsNull) { XmlReader xmlReader = xml.CreateReader(); if (xmlReader != null) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(xmlReader); prop.SetValue(entity, xmlDoc, null); } else prop.SetValue(entity, null, null); } else { prop.SetValue(entity, null, null); } } else if (typeof(ServerEnum).IsAssignableFrom(propType)) { short enumVal = reader.GetInt16(i); ConstructorInfo construct = prop.PropertyType.GetConstructor(new Type[0]); ServerEnum val = (ServerEnum)construct.Invoke(null); val.SetEnum(enumVal); prop.SetValue(entity, val, null); } else throw new EntityNotFoundException("Unsupported property type: " + propType, null); } }
/////////////////////////////////////////////////////////////////////////// // Grab pet information packet /////////////////////////////////////////////////////////////////////////// public static byte[] Pet_Information_grab(pet_obj o, byte slot) { PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_PET_INFORMATION); try { ////////////////////////////////////////////////////////////////////////////////////// // Grabpet structure ////////////////////////////////////////////////////////////////////////////////////// Writer.DWord(o.UniqueID); //Unique ID Writer.DWord(o.Model); //Pet Model Writer.DWord(0x00006D); //Settings Writer.DWord(0x00006D); //Settings Writer.DWord(0x000047); //Settings 0x47 grab pet active 0 disabled if (o.Petname != "No name") //############### { Writer.Text(o.Petname); // Name region } else // { Writer.Word(0); //############### } Writer.Byte(o.Slots); //Slots count inventory pet ////////////////////////////////////////////////////////////////////////////////////// // Grabpet item inventory ////////////////////////////////////////////////////////////////////////////////////// Systems.MsSQL ms = new Systems.MsSQL("SELECT * FROM char_items WHERE owner='" + o.OwnerID + "' AND pet_storage_id='" + o.UniqueID + "'"); Writer.Byte(ms.Count()); using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { while (reader.Read()) { Item.AddItemPacket(Writer, reader.GetByte(5), reader.GetInt32(2), reader.GetByte(4), reader.GetInt16(6), reader.GetInt32(7), reader.GetInt32(0), reader.GetInt32(9), reader.GetInt32(30)); } } ms.Close(); ////////////////////////////////////////////////////////////////////////////////////// // Other ////////////////////////////////////////////////////////////////////////////////////// Writer.DWord(o.OwnerID); //Character ID Writer.Byte(slot); //Slot location of the pet ////////////////////////////////////////////////////////////////////////////////////// } catch (Exception ex) { Console.WriteLine("Pet load error: " + ex); } return(Writer.GetBytes()); }
//////////////////////////////////////////////////////////////////////////////////////////////////////////// // Character listening packet //////////////////////////////////////////////////////////////////////////////////////////////////////////// public static byte[] CharacterListing(string name) { Systems.MsSQL ms = new Systems.MsSQL("SELECT TOP 4 * FROM character WHERE account='" + name + "'"); PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_CHARACTERSCREEN); // Select opcode Writer.Byte(2); // Static byte 2 Writer.Byte(1); // Static byte 1 Writer.Byte(ms.Count()); // Byte Character Count using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { while (reader.Read()) { Writer.DWord(reader.GetInt32(3)); // DWord Skin Model Writer.Text(reader.GetString(2)); // String Name Writer.Byte(reader.GetByte(4)); // Byte Skin Volume Writer.Byte(reader.GetByte(5)); // Byte Level Writer.LWord(reader.GetInt64(12)); // Long Experience Writer.Word(reader.GetInt16(6)); // Word STR Writer.Word(reader.GetInt16(7)); // Word INT Writer.Word(reader.GetInt16(8)); // Attribute points Writer.DWord(reader.GetInt32(9)); // HP Writer.DWord(reader.GetInt32(10)); // MP TimeSpan ts = Convert.ToDateTime(reader.GetDateTime(43)) - DateTime.Now; double time = ts.TotalMinutes; if (Math.Round(time) > 0) { Writer.Byte(1); Writer.DWord(Math.Round(time)); } else { Writer.Byte(0); } if (Math.Round(time) < 0 && DateTime.Now != reader.GetDateTime(43)) { Systems.MsSQL.UpdateData("UPDATE character SET deleted='1' Where id='" + reader.GetInt32(0) + "'"); } Writer.Word(0); Writer.Byte(0); Function.Items.PrivateItemPacket(Writer, reader.GetInt32(0), 8, 0,false); Function.Items.PrivateItemPacket(Writer, reader.GetInt32(0), 5, 1,false); } //Jobtype information int jobinfo = Systems.MsSQL.GetDataInt("SELECT * FROM users WHERE id='"+ name +"'", "jobtype"); Writer.Byte(Convert.ToByte(jobinfo)); } ms.Close(); return Writer.GetBytes(); }
public static TopicInfo CopyTopicToBO(SqlDataReader rdr) { TopicInfo topic; try { topic = new TopicInfo { Id = rdr.GetInt32(0), CatId = rdr.GetInt32(1), ForumId = rdr.GetInt32(2), Status = rdr.GetInt16(3), Subject = rdr.SafeGetString(4), AuthorId = rdr.GetInt32(5), ReplyCount = rdr.GetInt32(6), Views = rdr.GetInt32(7), LastPostDate = rdr.SafeGetString(8).ToDateTime(), Date = rdr.SafeGetString(9).ToDateTime().Value, PosterIp = rdr.SafeGetString(10), LastPostAuthorId = rdr.SafeGetInt32(11), IsSticky = rdr.GetInt16(12) == 1, LastEditDate = rdr.SafeGetString(13).ToDateTime(), LastEditedById = rdr.SafeGetInt32(14), UseSignatures = rdr.GetInt16(15) == 1, LastReplyId = rdr.SafeGetInt32(16), UnModeratedReplies = rdr.GetInt32(17), Message = rdr.SafeGetString(18) }; if (rdr.FieldCount > 19) { topic.LastPostAuthorName = rdr.SafeGetString(19); topic.AuthorName = rdr.SafeGetString(20); topic.EditorName = rdr.SafeGetString(21); if (rdr.FieldCount > 22) { topic.AuthorViewSig = rdr.GetInt16(22) == 1; topic.AuthorSignature = rdr.SafeGetString(23); } } } catch (System.Exception) { return null; } return topic; }
internal static void FillCompatibleITypedSettersFromReader(SmiEventSink_Default sink, ITypedSettersV3 setters, SmiMetaData[] metaData, SqlDataReader reader) { for (int i = 0; i < metaData.Length; i++) { if (reader.IsDBNull(i)) { SetDBNull_Unchecked(sink, setters, i); continue; } switch (metaData[i].SqlDbType) { case SqlDbType.BigInt: { SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i)); continue; } case SqlDbType.Binary: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } case SqlDbType.Bit: { SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i)); continue; } case SqlDbType.Char: { SetSqlChars_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlChars(i), 0); continue; } case SqlDbType.DateTime: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.Decimal: { SetSqlDecimal_Unchecked(sink, setters, i, reader.GetSqlDecimal(i)); continue; } case SqlDbType.Float: { SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i)); continue; } case SqlDbType.Image: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } case SqlDbType.Int: { SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i)); continue; } case SqlDbType.Money: { SetSqlMoney_Unchecked(sink, setters, i, metaData[i], reader.GetSqlMoney(i)); continue; } case SqlDbType.NChar: case SqlDbType.NText: case SqlDbType.NVarChar: { SetSqlChars_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlChars(i), 0); continue; } case SqlDbType.Real: { SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i)); continue; } case SqlDbType.UniqueIdentifier: { SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i)); continue; } case SqlDbType.SmallDateTime: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.SmallInt: { SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i)); continue; } case SqlDbType.SmallMoney: { SetSqlMoney_Checked(sink, setters, i, metaData[i], reader.GetSqlMoney(i)); continue; } case SqlDbType.Text: { SetSqlChars_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlChars(i), 0); continue; } case SqlDbType.Timestamp: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } case SqlDbType.TinyInt: { SetByte_Unchecked(sink, setters, i, reader.GetByte(i)); continue; } case SqlDbType.VarBinary: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } case SqlDbType.VarChar: { SetSqlChars_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlChars(i), 0); continue; } case SqlDbType.Variant: { object sqlValue = reader.GetSqlValue(i); ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCode(sqlValue); SetCompatibleValue(sink, setters, i, metaData[i], sqlValue, typeCode, 0); continue; } case SqlDbType.Xml: { SetSqlXml_Unchecked(sink, setters, i, reader.GetSqlXml(i)); continue; } case SqlDbType.Udt: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } } throw ADP.NotSupported(); } }
public static MemberInfo CopyMemberToBO(SqlDataReader rdr) { MemberInfo member = null; try { member = new MemberInfo { Id = rdr.GetInt32(0), Status = rdr.GetInt16(1), Username = rdr.GetString(2), NTUsername = rdr.SafeGetString(3), Email = rdr.SafeGetString(4), Country = rdr.SafeGetString(5), HomePage = rdr.SafeGetString(6), Signature = rdr.SafeGetString(7), MemberLevel = rdr.GetInt16(8), AIM = rdr.SafeGetString(9), Yahoo = rdr.SafeGetString(10), ICQ = rdr.SafeGetString(11), MSN = rdr.SafeGetString(12), PostCount = rdr.SafeGetInt32(13) ?? 0, MemberSince = rdr.SafeGetString(14).ToDateTime().Value, LastVisitDate = rdr.SafeGetString(15).ToDateTime(), LastPostDate = rdr.SafeGetString(16).ToDateTime(), Title = rdr.SafeGetString(17), //MemberTitle(rdr.SafeGetString(17)), AllowSubscriptions = (rdr["M_SUBSCRIPTION"] as int?) == 1, HideEmail = (rdr["M_HIDE_EMAIL"] as int?) == 1, ReceiveEmails = (rdr["M_RECEIVE_EMAIL"] as int?) == 1, MembersIP = rdr.SafeGetString(21), ViewSignatures = (rdr["M_VIEW_SIG"] as int?) == 1, UseSignature = (rdr["M_SIG_DEFAULT"] as int?) == 1, Voted = (rdr["M_VOTED"] as int?) == 1, AllowEmail = (rdr["M_ALLOWEMAIL"] as int?) == 1, Avatar = rdr.SafeGetString(26), Theme = rdr.SafeGetString(27), TimeOffset = rdr.GetInt32(28), DateOfBirth = rdr.SafeGetString(29) }; } catch(Exception ex) { SqlDataReader rdrtest = rdr; string test = ex.Message; } string title = member.Title; member.Rank = new RankInfo(member.Username,ref title,member.PostCount); member.Title = title; return member; }
private void init(SqlDataReader reader) { /* [Id], Guid, Email,CompanyName,Name, Gender, Address, PhoneNumber, ZIP, Website, Nature,FoundedYear,RegDate,CompanyBrief, ServiceAreas,Categories, Industries, CategoryLeadsNum, GeneralScore, Priority,RecommCount,LeadsEvalTimes,S_AVG,R_AVG,Q_AVG,V_AVG */ id = reader.GetInt32(0); guid = reader.GetString(1); email = reader.GetString(2); companyName = reader.GetString(3); name = reader.GetString(4); gender = reader.GetString(5) == "M" ? "����" : "Ůʿ"; address = reader.GetString(6); phoneNumber = reader.GetString(7); zip = reader.GetString(8); website = reader.GetString(9); nature = reader.GetString(10); foundedYear = reader.GetInt16(11); regDate = reader.GetDateTime(12); companyBrief = reader.GetString(13); serviceAreas = reader.GetString(14).Replace(" ", ""); ; categories = reader.GetString(15).Replace(" ", ""); ; industries = reader.GetString(16).Replace(" ", ""); ; categoryLeadsNum = reader.GetString(17); generalScore = Convert.ToSingle(reader.GetValue(18)); priority = reader.GetInt32(19); recommendCount = reader.IsDBNull(20) ? 0 : reader.GetInt32(20); leadsEvalTimes = reader.IsDBNull(21) ? 0 : reader.GetInt32(21); specialtyAvg = Convert.ToSingle(reader.GetValue(22)); responsibilityAvg = Convert.ToSingle(reader.GetValue(23)); qualityAvg = Convert.ToSingle(reader.GetValue(24)); valuablyAvg = Convert.ToSingle(reader.GetValue(25)); GetMatchStatus(); }
public static System.DateTime getFieldValue(SqlDataReader dr, int ind, System.DateTime def) { System.DateTime val = def; if (!dr.IsDBNull(ind)) { System.TypeCode tp = System.Type.GetTypeCode(dr.GetFieldType(ind)); System.TypeCode typeCode = tp; switch (typeCode) { case System.TypeCode.Byte: val = System.Convert.ToDateTime(dr.GetByte(ind)); break; case System.TypeCode.Int16: val = System.Convert.ToDateTime(dr.GetInt16(ind)); break; case System.TypeCode.UInt16: break; case System.TypeCode.Int32: val = System.Convert.ToDateTime(dr.GetInt32(ind)); break; default: if (typeCode == System.TypeCode.DateTime) { val = dr.GetDateTime(ind); } break; } } return val; }
private List<Column> GetColumns(SqlDataReader reader) { var list = new List<Column>(); while (reader.Read()) { var column = new Column(); column.Name = reader.GetString(0); column.Type = reader.GetString(1); column.Length = reader.GetInt16(2); column.IsNullable = reader.GetInt32(3) == 0; if (reader.FieldCount >= 5) { column.Scale = reader.GetByte(4); column.Precision = reader.GetByte(5); column.IsPrimaryKey = reader.GetInt32(6) == 1; column.Default = reader.GetString(7); if (column.Default.StartsWith("((")) column.Default = column.Default.Substring(1, column.Default.Length - 2); } list.Add(column); } return list; }
// Copy multiple fields from reader to ITypedSettersV3 // Assumes caller enforces that reader and setter metadata are compatible internal static void FillCompatibleITypedSettersFromReader( SmiEventSink_Default sink, ITypedSettersV3 setters, SmiMetaData[] metaData, SqlDataReader reader ) { for ( int i = 0; i < metaData.Length; i++ ) { if ( reader.IsDBNull(i) ) { ValueUtilsSmi.SetDBNull_Unchecked( sink, setters, i ); } else { switch ( metaData[i].SqlDbType ) { case SqlDbType.BigInt: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int64 ) ); ValueUtilsSmi.SetInt64_Unchecked( sink, setters, i, reader.GetInt64(i) ); break; case SqlDbType.Binary: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); ValueUtilsSmi.SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; case SqlDbType.Bit: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Boolean ) ); SetBoolean_Unchecked( sink, setters, i, reader.GetBoolean(i) ); break; case SqlDbType.Char: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) ); SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 ); break; case SqlDbType.DateTime: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.DateTime ) ); SetDateTime_Checked( sink, setters, i, metaData[i], reader.GetDateTime(i) ); break; case SqlDbType.Decimal: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlDecimal ) ); SetSqlDecimal_Unchecked( sink, setters, i, reader.GetSqlDecimal(i) ); break; case SqlDbType.Float: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Double ) ); SetDouble_Unchecked( sink, setters, i, reader.GetDouble(i) ); break; case SqlDbType.Image: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; case SqlDbType.Int: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int32 ) ); SetInt32_Unchecked( sink, setters, i, reader.GetInt32(i) ); break; case SqlDbType.Money: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlMoney ) ); SetSqlMoney_Unchecked( sink, setters, i, metaData[i], reader.GetSqlMoney(i) ); break; case SqlDbType.NChar: case SqlDbType.NText: case SqlDbType.NVarChar: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) ); SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 ); break; case SqlDbType.Real: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Single ) ); SetSingle_Unchecked( sink, setters, i, reader.GetFloat(i) ); break; case SqlDbType.UniqueIdentifier: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Guid ) ); SetGuid_Unchecked( sink, setters, i, reader.GetGuid(i) ); break; case SqlDbType.SmallDateTime: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.DateTime ) ); SetDateTime_Checked( sink, setters, i, metaData[i], reader.GetDateTime(i) ); break; case SqlDbType.SmallInt: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int16 ) ); SetInt16_Unchecked( sink, setters, i, reader.GetInt16(i) ); break; case SqlDbType.SmallMoney: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlMoney ) ); SetSqlMoney_Checked( sink, setters, i, metaData[i], reader.GetSqlMoney(i) ); break; case SqlDbType.Text: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) ); SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 ); break; case SqlDbType.Timestamp: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; case SqlDbType.TinyInt: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Byte ) ); SetByte_Unchecked( sink, setters, i, reader.GetByte(i) ); break; case SqlDbType.VarBinary: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; case SqlDbType.VarChar: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.String ) ); SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 ); break; case SqlDbType.Xml: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlXml ) ); SetSqlXml_Unchecked( sink, setters, i, reader.GetSqlXml(i) ); break; case SqlDbType.Variant: object o = reader.GetSqlValue(i); ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCode( o ); SetCompatibleValue( sink, setters, i, metaData[i], o, typeCode, 0 ); break; case SqlDbType.Udt: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; default: // In order for us to get here we would have to have an // invalid instance of SqlDbType, or one would have to add // new member to SqlDbType without adding a case in this // switch, hence the assert - it must be Debug.Assert( false, "unsupported DbType:" + metaData[i].SqlDbType.ToString() ); throw ADP.NotSupported(); } } } }
/// <summary> /// Creates a new instance of the APM class and populates it with data from the specified SqlDataReader. /// </summary> private static APMInfo MakeAPM(SqlDataReader dataReader) { APMInfo aPM = new APMInfo(); if (dataReader.IsDBNull(Cod_APM) == false) aPM.Cod_APM = dataReader.GetInt32(Cod_APM); if (dataReader.IsDBNull(Cod_Delegacion) == false) aPM.Cod_Delegacion = dataReader.GetInt32(Cod_Delegacion); if (dataReader.IsDBNull(Codigo_Completo) == false) aPM.Codigo_Completo = dataReader.GetString(Codigo_Completo); if (dataReader.IsDBNull(Numero_APM) == false) aPM.Numero_APM = dataReader.GetString(Numero_APM); if (dataReader.IsDBNull(Apellido) == false) aPM.Apellido = dataReader.GetString(Apellido); if (dataReader.IsDBNull(Nombre) == false) aPM.Nombre = dataReader.GetString(Nombre); if (dataReader.IsDBNull(Fecha_Nacimiento) == false) aPM.Fecha_Nacimiento = dataReader.GetDateTime(Fecha_Nacimiento); if (dataReader.IsDBNull(Cod_Nacionalidad) == false) aPM.Cod_Nacionalidad = dataReader.GetInt32(Cod_Nacionalidad); if (dataReader.IsDBNull(Cod_Direccion) == false) aPM.Cod_Direccion = dataReader.GetInt32(Cod_Direccion); if (dataReader.IsDBNull(Cod_Modelo) == false) aPM.Cod_Modelo = dataReader.GetInt32(Cod_Modelo); if (dataReader.IsDBNull(Fecha_Ingreso) == false) aPM.Fecha_Ingreso = dataReader.GetDateTime(Fecha_Ingreso); if (dataReader.IsDBNull(Fecha_Egreso) == false) aPM.Fecha_Egreso = dataReader.GetDateTime(Fecha_Egreso); if (dataReader.IsDBNull(Ultima_Conexion) == false) aPM.Ultima_Conexion = dataReader.GetDateTime(Ultima_Conexion); if (dataReader.IsDBNull(Ultimo_Proceso) == false) aPM.Ultimo_Proceso = dataReader.GetDateTime(Ultimo_Proceso); if (dataReader.IsDBNull(Skip) == false) aPM.Skip = dataReader.GetInt16(Skip); if (dataReader.IsDBNull(Foto) == false) aPM.Foto = new Byte[Convert.ToInt32(dataReader.GetBytes(0, 0, null, 0, Int32.MaxValue))]; dataReader.GetBytes(0, 0, aPM.Foto, 0, aPM.Foto.Length); if (dataReader.IsDBNull(Blocking_Days) == false) aPM.Blocking_Days = dataReader.GetInt16(Blocking_Days); if (dataReader.IsDBNull(Proc_Id) == false) aPM.Proc_Id = dataReader.GetInt32(Proc_Id); if (dataReader.IsDBNull(UserName) == false) aPM.UserName = dataReader.GetString(UserName); if (dataReader.IsDBNull(Password) == false) aPM.Password = dataReader.GetString(Password); if (dataReader.IsDBNull(Email) == false) aPM.Email = dataReader.GetString(Email); if (dataReader.IsDBNull(Download) == false) aPM.Download = dataReader.GetDateTime(Download); if (dataReader.IsDBNull(External_Code) == false) aPM.External_Code = dataReader.GetString(External_Code); if (dataReader.IsDBNull(Action) == false) aPM.Action = dataReader.GetString(Action); if (dataReader.IsDBNull(Change_Del) == false) aPM.Change_Del = dataReader.GetBoolean(Change_Del); if (dataReader.IsDBNull(SyncID) == false) aPM.SyncID = dataReader.GetGuid(SyncID); if (dataReader.IsDBNull(SyncTimeStamp) == false) aPM.SyncTimeStamp = DateTime.MinValue; return aPM; }
Patient getNextPatient(SqlDataReader reader) { Patient p = new Patient(); p.LocalSiteId = (reader.GetInt16(reader.GetOrdinal("sitecode"))).ToString(); Decimal d = Convert.ToDecimal(reader.GetDecimal(reader.GetOrdinal("localPid"))); if ((d - Math.Floor(d)) > 0) { p.LocalPid = (d).ToString(); } else { p.LocalPid = (Convert.ToInt64(d)).ToString(); } p.Name = new PersonName(reader.GetString(reader.GetOrdinal("name"))); p.SSN = new SocSecNum(reader.GetString(reader.GetOrdinal("ssn"))); if (!reader.IsDBNull(reader.GetOrdinal("gender"))) { p.Gender = reader.GetBoolean(reader.GetOrdinal("gender")) ? "M" : "F"; // 1 or true == male, 0 or false == female } else { p.Gender = ""; } if (!reader.IsDBNull(reader.GetOrdinal("vistaDOB"))) { p.DOB = reader.GetString(reader.GetOrdinal("vistaDOB")); } p.MpiPid = (reader.GetInt32(reader.GetOrdinal("icn"))).ToString(); p.MpiChecksum = (reader.GetInt32(reader.GetOrdinal("icnx"))).ToString(); p.Demographics = new Dictionary<string, DemographicSet>(); DemographicSet demogs = new DemographicSet(); demogs.PhoneNumbers = new List<PhoneNum>(); demogs.EmailAddresses = new List<EmailAddress>(); demogs.StreetAddresses = new List<Address>(); if (!reader.IsDBNull(reader.GetOrdinal("homePhone"))) { demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("homePhone")))); } if (!reader.IsDBNull(reader.GetOrdinal("workPhone"))) { demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("workPhone")))); } if (!reader.IsDBNull(reader.GetOrdinal("cellPhone"))) { demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("cellPhone")))); } if (!reader.IsDBNull(reader.GetOrdinal("emailAddress"))) { demogs.EmailAddresses.Add(new EmailAddress(reader.GetString(reader.GetOrdinal("emailAddress")))); } Address address = new Address(); if (!reader.IsDBNull(reader.GetOrdinal("addressLine1"))) { address.Street1 = reader.GetString(reader.GetOrdinal("addressLine1")); } if (!reader.IsDBNull(reader.GetOrdinal("addressLine2"))) { address.Street2 = reader.GetString(reader.GetOrdinal("addressLine2")); } if (!reader.IsDBNull(reader.GetOrdinal("addressLine3"))) { address.Street3 = reader.GetString(reader.GetOrdinal("addressLine3")); } if (!reader.IsDBNull(reader.GetOrdinal("city"))) { address.City = reader.GetString(reader.GetOrdinal("city")); } if (!reader.IsDBNull(reader.GetOrdinal("county"))) { address.County = reader.GetString(reader.GetOrdinal("county")); } if (!reader.IsDBNull(reader.GetOrdinal("state"))) { address.State = reader.GetString(reader.GetOrdinal("state")); } if (!reader.IsDBNull(reader.GetOrdinal("zipcode"))) { address.Zipcode = reader.GetString(reader.GetOrdinal("zipcode")); } demogs.StreetAddresses.Add(address); p.Demographics.Add(p.LocalSiteId, demogs); return p; }
public static byte[] Load(character c) { PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_PLAYERDATA); /////////////////////////////////////////////////////// Character basic info #region Basic info Writer.DWord(c.Ids.GetLoginID); Writer.DWord(c.Information.Model); Writer.Byte(c.Information.Volume); Writer.Byte(c.Information.Level); Writer.Byte(c.Information.Level); Writer.LWord(c.Information.XP); Writer.DWord(c.Information.SpBar); Writer.LWord(c.Information.Gold); Writer.DWord(c.Information.SkillPoint); Writer.Word(c.Information.Attributes); Writer.Byte(c.Information.BerserkBar); Writer.DWord(0); Writer.DWord(c.Stat.SecondHp); Writer.DWord(c.Stat.SecondMP); Writer.Bool(c.Information.Level < 20 ? true : false); #endregion /////////////////////////////////////////////////////// Character Player Kill Info #region Pk information //Mssql perfection reading with multiple data adapters... while this one is open i can still read anything else from the database //With no speed reduction... Systems.MsSQL checkpk = new Systems.MsSQL("SELECT * FROM character WHERE name ='" + c.Information.Name + "'"); using (System.Data.SqlClient.SqlDataReader getinfo = checkpk.Read()) { while (getinfo.Read()) { byte dailypk = getinfo.GetByte(48); byte pklevel = getinfo.GetByte(49); byte murderlevel = getinfo.GetByte(50); Writer.Byte(dailypk); Writer.Word(pklevel); Writer.DWord(murderlevel); if (murderlevel != 0) c.Information.Murderer = true; } } #endregion /////////////////////////////////////////////////////// Character Title #region Title Writer.Byte(c.Information.Title); #endregion /////////////////////////////////////////////////////// Character Pvpstate #region Pvp Writer.Byte(c.Information.Pvpstate); if (c.Information.Pvpstate > 0) c.Information.PvP = true; #endregion /////////////////////////////////////////////////////// Character Items #region Item Writer.Byte(c.Information.Slots); Systems.MsSQL ms = new Systems.MsSQL("SELECT * FROM char_items WHERE owner='" + c.Information.CharacterID + "' AND slot >= '0' AND slot <= '" + c.Information.Slots + "' AND inavatar='0' AND storagetype='0'"); Writer.Byte(ms.Count()); using (System.Data.SqlClient.SqlDataReader msreader = ms.Read()) { while (msreader.Read()) { short amount = msreader.GetInt16(6); if (amount < 1) amount = 1; Systems.MsSQL.InsertData("UPDATE char_items SET quantity='" + amount + "' WHERE owner='" + c.Information.CharacterID + "' AND itemid='" + msreader.GetInt32(2) + "' AND id='" + msreader.GetInt32(0) + "' AND storagetype='0'"); if (msreader.GetByte(5) == 6) c.Information.Item.wID = Convert.ToInt32(msreader.GetInt32(2)); if (msreader.GetByte(5) == 7) { c.Information.Item.sID = msreader.GetInt32(2); c.Information.Item.sAmount = msreader.GetInt16(6); } Item.AddItemPacket(Writer, msreader.GetByte(5), msreader.GetInt32(2), msreader.GetByte(4), amount, msreader.GetInt32(7),msreader.GetInt32(0), msreader.GetInt32(9), msreader.GetInt32(30)); } } ms.Close(); //Avatar Writer.Byte(5); ms = new Systems.MsSQL("SELECT * FROM char_items WHERE owner='" + c.Information.CharacterID + "' AND slot >= '0' AND slot <= '" + c.Information.Slots + "' AND inavatar='1' AND storagetype='0'"); Writer.Byte(ms.Count()); using (System.Data.SqlClient.SqlDataReader msreader = ms.Read()) { while (msreader.Read()) { Item.AddItemPacket(Writer, msreader.GetByte(5), msreader.GetInt32(2), msreader.GetByte(4), msreader.GetInt16(6), msreader.GetInt32(7), msreader.GetInt32(0), msreader.GetInt32(9),msreader.GetInt32(30)); } } ms.Close(); Writer.Byte(0); // job mastery Writer.Byte(0x0B); Writer.Byte(0); Writer.Byte(0); #endregion /////////////////////////////////////////////////////// Mastery #region Mastery if (c.Information.Model <= 12000) { for (byte i = 1; i <= 8; i++) { Writer.Byte(1); Writer.DWord(c.Stat.Skill.Mastery[i]); Writer.Byte(c.Stat.Skill.Mastery_Level[i]); } } else { if (c.Information.Model >= 14000) { for (byte i = 1; i < 8; i++) { Writer.Byte(1); Writer.DWord(c.Stat.Skill.Mastery[i]); Writer.Byte(c.Stat.Skill.Mastery_Level[i]); } } } #endregion /////////////////////////////////////////////////////// Skills #region Skill Writer.Byte(2); Writer.Byte(0); for (int i = 1; i <= c.Stat.Skill.AmountSkill; i++) { Writer.Byte(1); Writer.DWord(c.Stat.Skill.Skill[i]); Writer.Byte(1); } Writer.Byte(2); #endregion /////////////////////////////////////////////////////// Quests #region Quest Writer.Word(1); // how many Quest ids completed/aborted Writer.DWord(1);// Quest id Writer.Byte(0);//number of Quests that are live #endregion Writer.Byte(0);//? for now /////////////////////////////////////////////////////// Talisman #region Talisman Writer.DWord(1);//new Writer.DWord(1);//new Writer.DWord(0);//? for now Writer.DWord(0x0C);//new #endregion /////////////////////////////////////////////////////// Position + id + speed #region Character id / Position / Speed Writer.DWord(c.Information.UniqueID); Writer.Byte(c.Position.xSec); Writer.Byte(c.Position.ySec); if (!File.FileLoad.CheckCave(c.Position.xSec, c.Position.ySec)) { Writer.Float(Formule.packetx(c.Position.x, c.Position.xSec)); Writer.Float(c.Position.z); Writer.Float(Formule.packety(c.Position.y, c.Position.ySec)); } else { Writer.Float(Formule.cavepacketx(c.Position.x));// Added for cave Coords Writer.Float(c.Position.z); Writer.Float(Formule.cavepackety(c.Position.y));// Added for cave Coords } Writer.Word(0); // Angle Writer.Byte(0); Writer.Byte(1); Writer.Byte(0); Writer.Word(0); // Angle Writer.Word(0); Writer.Byte(0); Writer.Bool(false); //berserk Writer.Byte(0);//new ? Writer.Float(c.Speed.WalkSpeed); Writer.Float(c.Speed.RunSpeed); Writer.Float(c.Speed.BerserkSpeed); #endregion /////////////////////////////////////////////////////// Premium Tickets #region Premium ticket Writer.Byte(0); //ITEM_MALL_GOLD_TIME_SERVICE_TICKET_4W #endregion /////////////////////////////////////////////////////// GM Check + Name #region GM Check + Name Writer.Text(c.Information.Name); #endregion /////////////////////////////////////////////////////// Character jobs #region Character Job / hunter thief trader ( old job things ) //Writer info with job name when on job /*if (c.Job.state == 1 && c.Job.Jobname != "0") { Writer.Text(c.Job.Jobname); Writer.Byte(3); Writer.Byte(1); Writer.DWord(0); Writer.DWord(0); Writer.DWord(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); } //Write basic info noname if (c.Job.Jobname == "0") { Writer.Word(0); Writer.Byte(3); Writer.Byte(1); Writer.DWord(0); Writer.DWord(0); Writer.DWord(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); } //Write no info else { Writer.Word(0); Writer.Byte(0); Writer.Byte(1); Writer.DWord(0); Writer.DWord(0); Writer.DWord(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); }*/ #endregion #region New job system if (c.Job.state == 1) { Writer.Text(c.Job.Jobname); Writer.Byte(1); Writer.Byte(c.Job.level);//Level job Writer.Byte(c.Information.Level);//Level char Writer.Byte(1); // job level? myb Writer.LWord(0);// job exp probably y Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); } else { Writer.Word(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(2); // job type Writer.Byte(1); // job level? myb Writer.LWord(0);// job exp probably y Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); } #endregion /////////////////////////////////////////////////////// Pvp / Pk State #region Pvp / Pk State if (c.Information.Pvpstate == 1 || c.Information.Murderer) { Writer.Byte(0x22); } else if (c.Information.Pvpstate == 0 || !c.Information.Murderer) { Writer.Byte(0xFF); } #endregion /////////////////////////////////////////////////////// Guide Data #region Guide Data this data stacks on itself so if guide id is 0400000000000000 and next guide is 0300000000000000 the data to send is 0700000000000000 for (int i = 0; i < 8; ++i)//Main Guide Packet Info { Writer.Byte(c.Guideinfo.G1[i]);//Reads From Int Array } #endregion /////////////////////////////////////////////////////// Account / Gm Check #region Account ID + Gm Check Writer.DWord(c.Account.ID); Writer.Byte(0);//c.Information.GM #endregion /////////////////////////////////////////////////////// Quickbar + Autopotion #region Bar information Writer.Byte(7); PacketReader reader = new PacketReader(System.IO.File.ReadAllBytes(Environment.CurrentDirectory + @"\player\info\quickbar\" + c.Information.Name + ".dat")); PlayerQuickBar(reader, Writer); reader = new PacketReader(System.IO.File.ReadAllBytes(Environment.CurrentDirectory + @"\player\info\autopot\" + c.Information.Name + ".dat")); PlayerAutoPot(reader, Writer); #endregion /////////////////////////////////////////////////////// Academy #region Academy Writer.Byte(0); // number of player in academy /* // if we have players there Writer.Byte(1); Writer.Text("asd"); */ Writer.Byte(0);//added byte today for 1.310 Writer.Byte(0); Writer.Word(1); Writer.Word(1); Writer.Byte(0); Writer.Byte(1); #endregion return Writer.GetBytes(); }