Posts

Pirelli Tyres in Qatar: Connecting Global Expertise with Local Service

A tyre purchase brings together several decisions: the right specification for the vehicle, reliable product availability, professional fitting and ongoing maintenance. Behind those decisions sits another important process—connecting international tyre manufacturers with customers in the local market. Through my work in procurement and IT in Qatar, I see how product knowledge, supplier coordination and business systems contribute to this process. Pirelli and Altayeb Group in Qatar Pirelli provides tyre products for different vehicles and driving requirements. In Qatar, Tyres and Equipment Centre (TEC), part of Altayeb Group, is an authorised dealer of Pirelli tyres , as stated on Altayeb Group’s official website . This relationship connects an international tyre brand with local distribution and automotive services. Altayeb’s service centres offer tyre fitting, wheel alignment, balancing and puncture repairs. For customers, selecting a tyre is only one part of the experience. Access t...

Read more →

0

Connecting Procurement and ERP: Lessons from My Work in Qatar

Procurement involves much more than issuing a purchase order. It connects suppliers, stock planning, shipping, warehouse operations, finance and sales. When these teams work with clear processes and reliable information, purchasing decisions become easier to manage. In my role as Procurement & IT Manager at Tyres and Equipment Centre, part of Altayeb Group in Qatar, I work across both procurement operations and business systems. This combination helps me understand the operational problem before deciding how an ERP system should support it. Start with the business process Before configuring a system, I believe it is important to understand how people actually work. For a purchasing process, that means asking practical questions: What triggers a purchase requirement? How are stock availability and expected shipments checked? Who compares quotations and approves purchases? What information do warehouse and finance teams need? How are delayed shipments, partial deliveries and supplier issues …

Read more →
0

Tyres Purchase / Procurement Process in Qatar

These information are based on my experience working with Pirelli Tyres and Equipment Centre Qatar. Here we are importing different kind of brand like for tyres Pirelli , Federal , Deestone , Diamondback, Boto, Gripmax, Odyking, Tracmax, Doubleking, Nison, Hilo, Saferich, Onyx, Green Dragon, Wellplus, Doupro, Gold Dove, Gold Sheild etc for Tubes like Dongah Tubes, for Batteries like Koreana Batteries, For Lubricant like Mannol Oils, Total Oils, for the Automotive equipment like Corghi, Velyin, Borlan, Airmac. I'm trying to explain the full procurement process of tyres from overseas (USA, UK, Germany, Russia, Romania, Mexico, Brazil, Italy, Turkey, Thailand, Taiwan, and , China ) to Qatar.  1. Purchase Order 2. Open Letter of Credit (LC) with Qatar Bank 3. Book Shipments if Purchase order is FOB . When booking a shipment always ask your agent to give minimum 14 days of free line demmurage charges so you can avoid any extra charges in case of your goods stuck at port for some time du…

Read more →
0

Search entire SQL Server database and all tables for a specified string

-- ============================================= -- Author:        <Jainul Khan> -- Create date: <11-12-2014> -- Description: < Search entire SQL Server database and all tables for a specified string > -- ============================================= -- [dbo].[sp_SearchFromAllTables] 'Entered' CREATE PROCEDURE sp_SearchFromAllTables ( @SearchStr nvarchar ( 100 ) ) AS BEGIN DECLARE @Results TABLE ( ColumnName nvarchar ( 370 ), ColumnValue nvarchar ( 3630 )) SET NOCOUNT ON DECLARE @TableName nvarchar ( 256 ), @ColumnName nvarchar ( 128 ), @SearchStr2 nvarchar ( 110 ) SET   @TableName = '' SET @SearchStr2 = QUOTENAME ( '%' + @SearchStr + '%' , '''' ) WHILE @TableName IS NOT NULL BEGIN SET @ColumnName = '' SET @TableName = ( SELECT MIN ( QUOTENAME ( TABLE_SCHEMA ) + '.' + QUOTENAME ( TABLE_NAME )) FROM INFORMATION_SCHEMA . TABLES WHERE        TABLE_TYPE = 'BASE TABLE' AND QUOTENAME ( TABLE_SCHEMA ) + '.' + QUOTENAME ( TABLE_NAME ) > @TableName AND OBJECTPROPERTY ( OBJECT_ID (

Read more →
0

Extended Date Formats in SQL Server

Here are some more date formats that does not come standard in SQL Server as part of the  CONVERT  function. Extended Date Formats Date Format SQL Statement Sample Output YY-MM-DD SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 8) AS [YY-MM-DD] SELECT REPLACE(CONVERT(VARCHAR(8), GETDATE(), 11), '/', '-') AS [YY-MM-DD] 99-01-24 YYYY-MM-DD SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD] SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111), '/', '-') AS [YYYY-MM-DD] 1999-01-24 MM/YY SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 3), 5) AS [MM/YY] SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 5) AS [MM/YY] 08/99 MM/YYYY SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7) AS [MM/YYYY] 12/2005 YY/MM SELECT CONVERT(VARCHAR(5), GETDATE(), 11) AS [YY/MM] 99/08 YYYY/MM SELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM]

Read more →
0

ASPxGridView - Enable Disable commandbuttons with conditions in AspxGridView

protected void grid1_CommandButtonInitialize( object sender, ASPxGridViewCommandButtonEventArgs e)         { if (e.VisibleIndex == -1) return ; if (e.ButtonType == ColumnCommandButtonType .Edit)             {                 e.Enabled = EditButtonVisibleCriteria(( ASPxGridView )sender, e.VisibleIndex);             }         } private bool EditButtonVisibleCriteria( ASPxGridView grid, int visibleIndex)         { object row = grid.GetRow(visibleIndex); return (( DataRowView )row)[ "Status" ].ToString().Contains( "Entered" );         }

Read more →
0

Sys.WebForms.PageRequestManagerParserErrorException: DevExpress

What's a PageRequestManagerParserErrorException? The UpdatePanel control uses asynchronous postbacks to control which parts of the page get rendered. It does this using a whole bunch of JavaScript on the client and a whole bunch of C# on the server. Asynchronous postbacks are exactly the same as regular postbacks except for one important thing: the rendering. Asynchronous postbacks go through the same life cycles events as regular pages (this is a question I get asked often). Only at the render phase do things get different. We capture the rendering of only the UpdatePanels that we care about and send it down to the client using a special format. In addition, we send out some other pieces of information, such as the page title, hidden form values, the form action URL, and lists of scripts. As I mentioned, this is rendered out using a special format that the JavaScript on the client can understand. If you mess with the format by rendering things outside of the render phase of the p…

Read more →
0