public CMemberShipAddForm(String inOpType, CCustomerInfo inCustomer)
{
InitializeComponent();
m_sOpType = inOpType;
m_oCustomer = inCustomer;
this.ScreenTitle = " Membership Card";
// this.membership = membership;
}
private void btnAddressLookup_Click(object sender, EventArgs e)
{
try
{
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult oResult = tempCustomerManager.GetCustomerAddressInfo(txtHouseNumber.Text, txtPostalCode.Text);
SortedList slAddressInfo = (SortedList)oResult.Data;
if (slAddressInfo.Count > 1)
{
AddressInFoForm objAddresses = new AddressInFoForm(slAddressInfo);
objAddresses.ShowDialog();
string addressKey = AddressInFoForm.m_addressKey.ToUpper().Replace(" ", "");
clsCustomerInfo objCustomer = (clsCustomerInfo)slAddressInfo[addressKey];
txtHouseNumber.Text = objCustomer.HouseNumber;
txtBuildingName.Text = objCustomer.buildingName;
txtTown.Text = objCustomer.Town;
txtFloorAptNumber.Text = objCustomer.ApartmentNumber;
txtStreetName.Text = objCustomer.StreenName.ToString();
}
else if (slAddressInfo.Count == 1)
{
foreach (clsCustomerInfo objCustomer in slAddressInfo.Values)
{
txtHouseNumber.Text = objCustomer.HouseNumber;
txtBuildingName.Text = objCustomer.buildingName;
txtTown.Text = objCustomer.Town;
txtStreetName.Text = objCustomer.StreenName;
}
}
else
{
MessageBox.Show("No address has been found.", RMSGlobal.MessageBoxTitle,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception exp)
{
throw exp;
}
}
public CResult CustomerInfoGetByCustomerID(Int64 inCustomerID)
{
try
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
m_oResult.Data = Database.Instance.Customer.CustomerInfoGetByCustomerID(inCustomerID);
m_oResult.IsSuccess = true;
m_oResult.Message = "Data Read Successfully";
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at CustomerInfoGetByCustomerID() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
//m_oResult.SetParams(ex.Message);
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in CustomerInfoGetByCustomerID()", LogLevel.Error, "CCustomerManager");
}
return m_oResult;
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public CCustomerInfo ConfiguredTime()
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
try
{
this.OpenConnection();
string sqlCommand ="select time_duration from takeaway_default_time";
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
Int32 configuredTime = Convert.ToInt32("0" + oReader["time_duration"]);
tempCustomerInfo.ConfiguredTime = configuredTime;
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in CustomerInfoGetByCustomerID()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at CustomerInfoGetByCustomerID()", ex);
}
else
{
throw new Exception("Exception occure at CustomerInfoGetByCustomerID()", ex);
}
}
finally
{
this.CloseConnection();
}
return tempCustomerInfo;
}
public CCustomerInfo CustomerInfoGetByCustomerID(Int64 inCustomerID)
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
try
{
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.CustomerInfoGetByCustomerID), inCustomerID);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
tempCustomerInfo = ReaderToCustomerInfo(oReader);
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in CustomerInfoGetByCustomerID()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at CustomerInfoGetByCustomerID()", ex);
}
else
{
throw new Exception("Exception occure at CustomerInfoGetByCustomerID()", ex);
}
}
finally
{
this.CloseConnection();
}
return tempCustomerInfo;
}
public void DeleteCustomerInfo(CCustomerInfo inCustomerInfo)
{
CCustomerInfo tempCustomerInfo = inCustomerInfo;
try
{
this.OpenConnection();
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.CustomerDelete),inCustomerInfo.CustomerID);
this.ExecuteNonQuery(sqlCommand);
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in DeleteCustomerInfo()", LogLevel.Error, "Database");
throw new Exception("Exception occure at DeleteCustomerInfo()", ex);
}
finally
{
this.CloseConnection();
}
}
/// <summary>
/// This function returns all the addresses of the selected criteria
/// </summary>
/// <param name="p_houseNumber"></param>
/// <param name="p_postCode"></param>
/// <returns></returns>
public CResult GetCustomerAddressInfo(string p_houseNumber, string p_postCode)
{
try
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
m_oResult.Data = Database.Instance.Customer.GetCustomerAddresses(p_houseNumber, p_postCode);
m_oResult.IsSuccess = true;
m_oResult.Message = "Data Read Successfully";
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at CustomerInfoGetByPhone() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
//m_oResult.SetParams(ex.Message);
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in CustomerInfoGetByPhone()", LogLevel.Error, "CCustomerManager");
}
return m_oResult;
}
/// <summary>
/// Modified by Baruri at 12.12.2008 for the new customer address format
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UpdateButton_Click(object sender, EventArgs e)
{
try
{
for (int rowIndex = 0; rowIndex < CustomerDataGridView.Rows.Count; rowIndex++)
{
if (CustomerDataGridView.Rows[rowIndex].Selected == true && CustomerDataGridView.Rows[rowIndex].Cells["PhoneNumber"].Value != null)
{
string phone = CustomerDataGridView.Rows[rowIndex].Cells[4].Value.ToString(); //for phone number
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult tempResult = tempCustomerManager.CustomerInfoGetByPhone(phone);
if (tempResult.IsSuccess)
{
CCustomerInfoForm tempCustomerInfoForm = new CCustomerInfoForm("Update", (CCustomerInfo)tempResult.Data);
tempCustomerInfoForm.Show();
CFormManager.Forms.Push(this);
this.Hide();
}
break;
}
}
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
try
{
for (int recordCounter = 0; recordCounter < CustomerDataGridView.Rows.Count; recordCounter++)
{
if (CustomerDataGridView.Rows[recordCounter].Selected == true && CustomerDataGridView.Rows[recordCounter].Cells["PhoneColumn"].Value != null)
{
DialogResult tempDialogResult = MessageBox.Show("WARNING!!!\nDeleting this Customer may also delete some other information.\nAre you sure to delete this Customer?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (tempDialogResult.Equals(DialogResult.No)) return;
else
{
string phone = CustomerDataGridView.Rows[recordCounter].Cells[4].Value.ToString();
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult tempResult = tempCustomerManager.CustomerInfoGetByPhone(phone);
if (tempResult.IsSuccess)
{
tempCustomerManager.DeleteCustomerInfo((CCustomerInfo)tempResult.Data);
this.LoadAllCustomerList();
}
}
break;
}
}
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
private CCustomerInfo ReaderToCustomerInfo(IDataReader inReader)
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
if (inReader["customer_id"] != null)
tempCustomerInfo.CustomerID = Int64.Parse(inReader["customer_id"].ToString());
if (inReader["name"] != null)
tempCustomerInfo.CustomerName= inReader["name"].ToString();
if (inReader["phone"] != null)
tempCustomerInfo.CustomerPhone= inReader["phone"].ToString();
if (inReader["postal_code"] != null)
tempCustomerInfo.CustomerPostalCode = inReader["postal_code"].ToString();
if (inReader["town"] != null)
tempCustomerInfo.CustomerTown = inReader["town"].ToString();
if (inReader["country"] != null)
tempCustomerInfo.CustomerCountry = inReader["country"].ToString();
if (inReader["floororapt_number"] != null)
tempCustomerInfo.FloorAptNumber = inReader["floororapt_number"].ToString();
if (inReader["building_name"] != null)
tempCustomerInfo.BuildingName = inReader["building_name"].ToString();
if (inReader["house_number"] != null)
tempCustomerInfo.HouseNumber = inReader["house_number"].ToString();
if (inReader["street_name"] != null)
tempCustomerInfo.StreetName = inReader["street_name"].ToString();
return tempCustomerInfo;
}
private void tmrCallerInfo_Tick(object sender, EventArgs e)
{
if ((RMSGlobal.m_phoneNumber.Replace(" ", "").ToUpper() == "There is no call".Replace(" ", "").ToUpper()) || (RMSGlobal.m_phoneNumber==String.Empty))
{
lblPhone.Text = RMSGlobal.m_phoneNumber;
lblCustomerName.Text = RMSGlobal.m_CallerName;
btnAccept.Image = global::RMS.Properties.Resources.ring_stop;
}
else if (RMSGlobal.m_isCallAccepted==true)
{
lblPhone.Text = RMSGlobal.m_phoneNumber;
lblCustomerName.Text = RMSGlobal.m_CallerName;
btnAccept.Image = global::RMS.Properties.Resources.ring_stop;
}
else
{
btnAccept.Image = global::RMS.Properties.Resources.ring;
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult oResult = tempCustomerManager.CustomerInfoGetByPhone(RMSGlobal.m_phoneNumber.Replace("-",""));//Collect the customer information
if (oResult.IsSuccess && oResult.Data != null)
{
tempCustomerInfo = (CCustomerInfo)oResult.Data;
if (tempCustomerInfo.CustomerName.Length > 0)
{
lblCustomerName.Text = tempCustomerInfo.CustomerName;
lblPhone.Text = tempCustomerInfo.CustomerPhone;
RMSGlobal.m_CallerAddress = tempCustomerInfo.StreetName.Replace("-","");
}
else
{
lblCustomerName.Text = "Unknow Customer";
lblPhone.Text = RMSGlobal.m_phoneNumber.Replace("-", "");
RMSGlobal.m_CallerAddress = "OUT OF AREA";
}
RMSGlobal.m_CallerName = lblCustomerName.Text;
}
}
}
/// <summary>
/// Online customer information of the selected order
/// </summary>
/// <param name="orderID"></param>
/// <returns></returns>
CCustomerInfo ICustomerInfoDAO.GetCustomerTakeawayInfo(long orderID)
{
string sqlCommand = String.Empty;
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
try
{
this.OpenConnection();
sqlCommand = String.Format(SqlQueries.GetQuery(Query.TakeawayCustomerInfo), orderID);
IDataReader oReader = this.ExecuteReader(sqlCommand);
string key = "";
if (oReader != null)
{
while (oReader.Read())
{
tempCustomerInfo.CustomerID = Convert.ToInt64("0"+oReader["customer_id"]);
tempCustomerInfo.CustomerName = Convert.ToString(oReader["name"]);
tempCustomerInfo.HouseNumber = Convert.ToString(oReader["house_number"]);
tempCustomerInfo.CustomerPostalCode = Convert.ToString(oReader["postal_code"]);
tempCustomerInfo.CustomerPhone = Convert.ToString(oReader["phone"]);
tempCustomerInfo.CustomerCountry = Convert.ToString(oReader["country"]);
tempCustomerInfo.CustomerTown = Convert.ToString(oReader["town"]);
tempCustomerInfo.BuildingName = Convert.ToString(oReader["building_name"]);
tempCustomerInfo.FloorAptNumber = Convert.ToString(oReader["floororapt_number"]);
tempCustomerInfo.StreetName = Convert.ToString(oReader["street_name"]);
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in GetOnlineCustomerInfoByOrderID()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at GetOnlineCustomerInfoByOrderID()", ex);
}
else
{
throw new Exception("Exception occure at GetOnlineCustomerInfoByOrderID()", ex);
}
}
finally
{
this.CloseConnection();
}
return tempCustomerInfo;
}
public void UpdateCustomerInfo(CCustomerInfo inCustomerInfo)
{
inCustomerInfo.CustomerName = inCustomerInfo.CustomerName.Replace("''", "'");
inCustomerInfo.CustomerName = inCustomerInfo.CustomerName.Replace("'", "''");
inCustomerInfo.CustomerPhone = inCustomerInfo.CustomerPhone.Replace("''", "'");
inCustomerInfo.CustomerPhone = inCustomerInfo.CustomerPhone.Replace("'", "''");
inCustomerInfo.CustomerPostalCode = inCustomerInfo.CustomerPostalCode.Replace("''", "'");
inCustomerInfo.CustomerPostalCode = inCustomerInfo.CustomerPostalCode.Replace("'", "''");
inCustomerInfo.CustomerAddress = inCustomerInfo.CustomerAddress.Replace("''", "'");
inCustomerInfo.CustomerAddress = inCustomerInfo.CustomerAddress.Replace("'", "''");
inCustomerInfo.CustomerTown = inCustomerInfo.CustomerTown.Replace("''", "'");
inCustomerInfo.CustomerTown = inCustomerInfo.CustomerTown.Replace("'", "''");
//inCustomerInfo.CustomerCounty = inCustomerInfo.CustomerCounty.Replace("''", "'");
//inCustomerInfo.CustomerCounty = inCustomerInfo.CustomerCounty.Replace("'", "''");
inCustomerInfo.CustomerCountry = inCustomerInfo.CustomerCountry.Replace("''", "'");
inCustomerInfo.CustomerCountry = inCustomerInfo.CustomerCountry.Replace("'", "''");
inCustomerInfo.FloorAptNumber = inCustomerInfo.FloorAptNumber.Replace("'", "''");
inCustomerInfo.BuildingName = inCustomerInfo.BuildingName.Replace("'", "''");
inCustomerInfo.HouseNumber = inCustomerInfo.HouseNumber.Replace("'", "''");
inCustomerInfo.StreetName = inCustomerInfo.StreetName.Replace("'", "''");
CCustomerInfo tempCustomerInfo = inCustomerInfo;
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.CustomerUpdate),
inCustomerInfo.CustomerName, inCustomerInfo.CustomerPhone, inCustomerInfo.CustomerPostalCode, inCustomerInfo.CustomerTown, inCustomerInfo.CustomerCountry,inCustomerInfo.FloorAptNumber,inCustomerInfo.BuildingName,inCustomerInfo.HouseNumber,inCustomerInfo.StreetName, inCustomerInfo.CustomerID);
this.ExecuteNonQuery(sSql);
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in UpdateCustomerInfo()", LogLevel.Error, "Database");
throw new Exception("Exception occure at UpdateCustomerInfo()", ex);
}
finally
{
this.CloseConnection();
}
}
private void tmrCallerID_Tick(object sender, EventArgs e)
{
if ((RMSGlobal.m_phoneNumber.Replace(" ", "").ToUpper() == "There is no call".Replace(" ", "").ToUpper()) || (RMSGlobal.m_phoneNumber == String.Empty)) //If there is no call
{
lblPhoneNumber.Text = RMSGlobal.m_phoneNumber;
lblPhoneNumber.Visible = false;
lblCallingStatus.Visible = false;
lblCustomerName.Visible = false;
grpCallerInfo.Visible = false;
}
else if (RMSGlobal.m_isCallAccepted == true)
{
lblPhoneNumber.Visible = false;
lblCallingStatus.Visible = false;
lblCustomerName.Visible = false;
grpCallerInfo.Visible = false;
}
else
{
lblPhoneNumber.Visible = true;
lblCallingStatus.Visible = true;
lblCustomerName.Visible = true;
grpCallerInfo.Visible = true;
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult oResult = tempCustomerManager.CustomerInfoGetByPhone(RMSGlobal.m_phoneNumber.Replace("-", ""));//Collect the customer information
if (oResult.IsSuccess && oResult.Data != null)
{
tempCustomerInfo = (CCustomerInfo)oResult.Data;
if (tempCustomerInfo.CustomerName.Length > 0)
{
lblPhoneNumber.Text = tempCustomerInfo.CustomerPhone;
lblCustomerName.Text = tempCustomerInfo.CustomerName;
RMSGlobal.m_CallerName = tempCustomerInfo.CustomerName;
RMSGlobal.m_CallerAddress = tempCustomerInfo.StreetName.Replace("-","");
}
else
{
lblPhoneNumber.Text = RMSGlobal.m_phoneNumber;
RMSGlobal.m_CallerName = RMSConstant.UnknownCustomer;
RMSGlobal.m_CallerAddress = RMSConstant.UnknownArea;
lblCustomerName.Text = RMSGlobal.m_CallerName;
}
RMSGlobal.m_phoneNumber = lblPhoneNumber.Text;
}
}
}
/// <summary>
/// Collecting the customer information by customer's name
/// </summary>
/// <param name="p_customerName"></param>
/// <returns></returns>
public CCustomerInfo GetCustomerInfoByName(string p_customerName)
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
tempCustomerInfo.CustomerDataTable.Columns.Add("Name");
tempCustomerInfo.CustomerDataTable.Columns.Add("address");
tempCustomerInfo.CustomerDataTable.Columns.Add("phone");
try
{
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.GetCustomersByName), p_customerName);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
tempCustomerInfo.CustomerDataTable.Rows.Add(new object[] { Convert.ToString(oReader["name"]), Convert.ToString(oReader["address"]), Convert.ToString(oReader["phone"]) });
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in GetCustomerInfoByName()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at GetCustomerInfoByName()", ex);
}
else
{
throw new Exception("Exception occure at GetCustomerInfoByName()", ex);
}
}
finally
{
this.CloseConnection();
}
return tempCustomerInfo;
}
/// <summary>
/// Collecting the recent orders of the selected customer.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void RecentOrderButton_Click(object sender, EventArgs e)
{
if (txtPhoneNumber.Text.Equals("")) //If phone number of the customer is not entered.
{
return;
}
try
{
string phone = txtPhoneNumber.Text.Trim();
this.ClearTextBoxes();
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult oResult = tempCustomerManager.CustomerInfoGetByPhone(phone);
if (oResult.IsSuccess && oResult.Data != null)
{
tempCustomerInfo = (CCustomerInfo)oResult.Data;
}
txtPhoneNumber.Text = tempCustomerInfo.CustomerPhone;
txtCustomerName.Text = tempCustomerInfo.CustomerName;
txtPostalCode.Text = tempCustomerInfo.CustomerPostalCode;
txtStreetName.Text = tempCustomerInfo.StreetName;
txtTown.Text = tempCustomerInfo.CustomerTown;
if (tempCustomerInfo.CustomerCountry.Length > 0)
{
cmbCountry.Text = tempCustomerInfo.CustomerCountry;
}
else
{
cmbCountry.Text = "United Kingdom (London) (EU)";
}
CRecentOrderForm tempOrderForm = new CRecentOrderForm(tempCustomerInfo.CustomerID, tempCustomerInfo.CustomerName, tempCustomerInfo.CustomerPhone, tempCustomerInfo.CustomerAddress);
tempOrderForm.ShowDialog();
m_htOrderInfo = CRecentOrderForm.m_htPreviousOrders; //Order details information from pervious order developed by baruri at10.09.2008
COrderInfoArchive tempOrderInfo = (COrderInfoArchive)m_htOrderInfo["orderinfo"]; //For detecting the order type
//if (tempOrderInfo.OrderType.ToString().ToUpper().Trim() == "TakeAway".ToString().ToUpper().Trim())
//{
// TakeAwayRadioButton.Checked = true;
//}
if (m_htOrderInfo.Count > 0)
{
FinishButton_Click(sender, e);
}
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
private void FinishButton_Click(object sender, EventArgs e)
{
CResult objResultant = new CResult();
try
{
if (!CheckEmpty() && m_orderIndex == 1)
{
CMessageBox tempMessageBox = new CMessageBox("Error", "Please enter all the mandatory values.");
tempMessageBox.ShowDialog();
return;
}
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
if (txtPhoneNumber.Text.Trim().Equals(String.Empty))
{
CResult oResult5 = tempCustomerManager.CustomerInfoGetByName(txtCustomerName.Text.Trim());
if (oResult5.IsSuccess && oResult5.Data != null)
{
tempCustomerInfo = (CCustomerInfo)oResult5.Data;
}
}
else
{
CResult oResult = tempCustomerManager.CustomerInfoGetByPhone(txtPhoneNumber.Text.Trim());
if (oResult.IsSuccess && oResult.Data != null)
{
tempCustomerInfo = (CCustomerInfo)oResult.Data;
}
}
if (txtCustomerName.Text.Length == 0 && (m_orderIndex == 2 || m_orderIndex == 3))
{
txtCustomerName.Text = m_order_name;
}
tempCustomerInfo.CustomerName = txtCustomerName.Text.Trim();
tempCustomerInfo.CustomerPhone = txtPhoneNumber.Text.Trim();
if (m_orderIndex == 1) //If only delivery type order is considered
{
tempCustomerInfo.CustomerPostalCode = txtPostalCode.Text.Trim();
tempCustomerInfo.FloorAptNumber = txtFloorAptNumber.Text.Trim();
tempCustomerInfo.HouseNumber = txtHouseNumber.Text.Trim();
tempCustomerInfo.StreetName = txtStreetName.Text.Trim() + "-" + txtStreet2.Text.Trim();
tempCustomerInfo.BuildingName = txtBuildingName.Text.Trim();
tempCustomerInfo.CustomerTown = txtTown.Text.Trim();
tempCustomerInfo.CustomerCountry = cmbCountry.Text;
tempCustomerInfo.UserName = RMSGlobal.LoginUserName;
tempCustomerInfo.TerminalId = RMSGlobal.Terminal_Id;
Int64 currentdateTime = DateTime.Now.Ticks;
tempCustomerInfo.InsertDate = currentdateTime;
}
if (tempCustomerInfo.CustomerID == 0)
{
CResult oResult6 = tempCustomerManager.InsertCustomerInfo(tempCustomerInfo);
if (oResult6.IsSuccess && oResult6.Data != null)
tempCustomerInfo = (CCustomerInfo)oResult6.Data;
}
else
{
tempCustomerManager.UpdateCustomerInfo(tempCustomerInfo);
}
#region "Older"
if (m_customerEditStatus == false)
{
if (m_iOrderID == 0)
{
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = new COrderInfo();
tempOrderInfo.CustomerID = tempCustomerInfo.CustomerID;
tempOrderInfo.OrderType = "TakeAway";
tempOrderInfo.OrderTime = System.DateTime.Now;
tempOrderInfo.TableNumber = GetValidTableNumber("TakeAway");
CTableInfo tempTableInfo = new CTableInfo();
tempTableInfo.TableNumber = tempOrderInfo.TableNumber;
tempTableInfo.TableType = "TakeAway";
tempOrderManager.InsertTableInfo(tempTableInfo);
if (m_orderIndex==1)
{
tempOrderInfo.Status = "Delivery";
}
else if (m_orderIndex ==2 )
{
tempOrderInfo.Status = "Collection";
}
else if (m_orderIndex == 3)
{
tempOrderInfo.Status = "Waiting";
}
m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>();
tempOrderInfo.UserID = m_oCommonConstants.UserInfo.UserID;
objResultant = tempOrderManager.InsertOrderInfo(tempOrderInfo); //New Order
COrderInfo tempOrderInfoNew = (COrderInfo)objResultant.Data;//Taking the order ID
m_iOrderID = tempOrderInfoNew.OrderID;
#region " Inserting Order details info if items are selected from the previous orders"
//Developed by baruri
List<COrderDetails> tempOrderDetailsList = new List<COrderDetails>();
if (m_htOrderInfo.Count > 0) //If item is selected from the previous order
{
tempOrderDetailsList = (List<COrderDetails>)m_htOrderInfo["orderdetail"];
}
if (tempOrderDetailsList.Count > 0) //Insert details for the new order
{
for (int itemDetailIndex = 0; itemDetailIndex < tempOrderDetailsList.Count; itemDetailIndex++)
{
COrderDetails objOrderDetails = (COrderDetails)tempOrderDetailsList[itemDetailIndex];
objOrderDetails.OrderID = tempOrderInfo.OrderID;
tempOrderManager.InsertOrderDetails(objOrderDetails);
}
m_htOrderInfo = new Hashtable();//Clearing the previous items from the order if there is any.
}
#endregion
//insert delivery time
if (tempOrderInfo.Status.Equals("Delivery"))
{
CDelivery tempDelivery = new CDelivery();
tempDelivery.DeliveryOrderID = tempOrderInfo.OrderID;
string deliveryTime = Convert.ToInt32("0" + cmbHour.Text).ToString("00") + ":" + Convert.ToInt32("0" + cmbMinute.Text).ToString("00") + " " + cmbMeridiem.Text;
tempDelivery.DeliveryTime = deliveryTime;// DeliveryTimeTextBox.Text.Trim();
tempOrderManager.InsertDeliveryInfo(tempDelivery);
}
//OLD Code
//Form tempForm = CFormManager.Forms.Pop();
//tempForm.Show();
try
{
WaiterForm waiterForm = new WaiterForm();
waiterForm.UserList = userList;
waiterForm.ShowDialog();
if (waiterForm.DialogResult == DialogResult.OK)
{
COrderWaiterDao orderwaiterDao = new COrderWaiterDao();
COrderwaiter orderwaiter = new COrderwaiter();
orderwaiter = orderwaiterDao.GetOrderwaiterByOrderID(tempOrderInfo.OrderID);
if (orderwaiter != null && orderwaiter.ID > 0 && orderwaiter.WaiterID != waiterForm.UserInfoData.UserID)
{
orderwaiter.OrderID = tempOrderInfo.OrderID;
orderwaiter.WaiterID = waiterForm.UserInfoData.UserID;
orderwaiter.WaiterName = waiterForm.UserInfoData.UserName;
orderwaiterDao.UpdateOrderwaiter(orderwaiter);
}
else if (orderwaiter.ID == 0)
{
orderwaiter.OrderID = tempOrderInfo.OrderID;
orderwaiter.WaiterID = waiterForm.UserInfoData.UserID;
orderwaiter.WaiterName = waiterForm.UserInfoData.UserName;
orderwaiterDao.InsertOrderwaiter(orderwaiter);
}
}
}
catch (Exception ex)
{
}
m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>();
CTableOrderForm tempForm = new CTableOrderForm(m_iOrderID, m_oCommonConstants.TakeAwayType, tempOrderInfo.TableNumber);
tempForm.m_orderUserName = RMSGlobal.LoginUserName;
tempForm.Show();
this.Close();
}
else
{
COrderManager tempOrderManager = new COrderManager();
CResult oResult7 = tempOrderManager.OrderInfoByOrderID(m_iOrderID);
COrderInfo tempOrderInfo = new COrderInfo();
if (oResult7.IsSuccess && oResult7.Data != null)
{
tempOrderInfo = (COrderInfo)oResult7.Data;
}
tempOrderInfo.OrderType = "TakeAway";
tempOrderInfo.Status = "TakeAway";
tempOrderInfo.GuestCount = 0;
tempOrderInfo.TableName = "";
tempOrderInfo.CustomerID = tempCustomerInfo.CustomerID;
tempOrderInfo.TableNumber = GetValidTableNumber("TakeAway");
CTableInfo tempTableInfo = new CTableInfo();
tempTableInfo.TableNumber = tempOrderInfo.TableNumber;
tempTableInfo.TableType = "TakeAway";
tempOrderManager.InsertTableInfo(tempTableInfo);
if (m_orderIndex == 1)
{
tempOrderInfo.Status = "Delivery";
}
else if (m_orderIndex == 3)
{
tempOrderInfo.Status = "Waiting";
}
else if (m_orderIndex == 2)
{
tempOrderInfo.Status = "Collection";
}
tempOrderManager.UpdateOrderInfo(tempOrderInfo);
//insert delivery time
if (tempOrderInfo.Status.Equals("Delivery"))
{
CDelivery tempDelivery = new CDelivery();
tempDelivery.DeliveryOrderID = tempOrderInfo.OrderID;
string deliveryTime = Convert.ToInt32("0" + cmbHour.Text).ToString("00") + ":" + Convert.ToInt32("0" + cmbMinute.Text).ToString("00") + " " + cmbMeridiem.Text;
tempDelivery.DeliveryTime = deliveryTime;// DeliveryTimeTextBox.Text.Trim();
tempOrderManager.InsertDeliveryInfo(tempDelivery);
}
try
{
WaiterForm waiterForm = new WaiterForm();
waiterForm.UserList = userList;
waiterForm.ShowDialog();
if (waiterForm.DialogResult == DialogResult.OK)
{
COrderWaiterDao orderwaiterDao = new COrderWaiterDao();
COrderwaiter orderwaiter = new COrderwaiter();
orderwaiter = orderwaiterDao.GetOrderwaiterByOrderID(tempOrderInfo.OrderID);
if (orderwaiter != null && orderwaiter.ID > 0 && orderwaiter.WaiterID != waiterForm.UserInfoData.UserID)
{
orderwaiter.OrderID = tempOrderInfo.OrderID;
orderwaiter.WaiterID = waiterForm.UserInfoData.UserID;
orderwaiter.WaiterName = waiterForm.UserInfoData.UserName;
orderwaiterDao.UpdateOrderwaiter(orderwaiter);
}
else if (orderwaiter.ID == 0)
{
orderwaiter.OrderID = tempOrderInfo.OrderID;
orderwaiter.WaiterID = waiterForm.UserInfoData.UserID;
orderwaiter.WaiterName = waiterForm.UserInfoData.UserName;
orderwaiterDao.InsertOrderwaiter(orderwaiter);
}
}
}
catch (Exception ex)
{
}
m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>();
CTableOrderForm tempForm = (CTableOrderForm)CFormManager.Forms.Pop();
tempForm.m_iType = m_oCommonConstants.TakeAwayType;
tempForm.Show();
this.Close();
}
}
#endregion
else //Edit order information.As here is reached from order details screen.
{
COrderInfo tempOrderInfo = new COrderInfo();
COrderManager tempOrderManager = new COrderManager();
CDelivery tempDelivery = null;
tempOrderInfo.OrderID = m_iOrderID;
tempOrderManager.DeleteDeliveryInfo(m_iOrderID);//Delete previous record from delivery information table
if (m_orderIndex==2)
{
tempOrderInfo.Status = "Collection";
}
else if (m_orderIndex==3)
{
tempOrderInfo.Status = "Waiting";
}
else
{
tempOrderInfo.Status = "Delivery";
tempDelivery = new CDelivery();
tempDelivery.DeliveryOrderID = tempOrderInfo.OrderID;
string deliveryTime = Convert.ToInt32("0" + cmbHour.Text).ToString("00") + ":" + Convert.ToInt32("0" + cmbMinute.Text).ToString("00") + " " + cmbMeridiem.Text;
tempDelivery.DeliveryTime = deliveryTime;//
tempOrderManager.InsertDeliveryInfo(tempDelivery);//Update delivery information
}
tempOrderManager.UpdateTakeawayOrderInfo(tempOrderInfo);//Update order information
try
{
WaiterForm waiterForm = new WaiterForm();
waiterForm.UserList = userList;
waiterForm.ShowDialog();
if (waiterForm.DialogResult == DialogResult.OK)
{
COrderWaiterDao orderwaiterDao = new COrderWaiterDao();
COrderwaiter orderwaiter = new COrderwaiter();
orderwaiter = orderwaiterDao.GetOrderwaiterByOrderID(tempOrderInfo.OrderID);
if (orderwaiter != null && orderwaiter.ID > 0 && orderwaiter.WaiterID != waiterForm.UserInfoData.UserID)
{
orderwaiter.OrderID = tempOrderInfo.OrderID;
orderwaiter.WaiterID = waiterForm.UserInfoData.UserID;
orderwaiter.WaiterName = waiterForm.UserInfoData.UserName;
orderwaiterDao.UpdateOrderwaiter(orderwaiter);
}
else if (orderwaiter.ID == 0)
{
orderwaiter.OrderID = tempOrderInfo.OrderID;
orderwaiter.WaiterID = waiterForm.UserInfoData.UserID;
orderwaiter.WaiterName = waiterForm.UserInfoData.UserName;
orderwaiterDao.InsertOrderwaiter(orderwaiter);
}
}
}
catch (Exception ex)
{
}
m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>();
CTableOrderForm tempForm = (CTableOrderForm)CFormManager.Forms.Pop();
tempForm.m_iType = m_oCommonConstants.TakeAwayType;
tempForm.Show();
this.Close();
}
m_phoneNumber = String.Empty;
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
/// <summary>
/// Modified by Baruri at 23.12.2008
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CTakeAwayForm_Activated(object sender, EventArgs e)
{
CCustomerManager tempCustomerManager = new CCustomerManager();
if (m_customerEditStatus == false)
{
CResult oResult = tempCustomerManager.CollectConfiguredTime();//Collect the configured time
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
tempCustomerInfo = (CCustomerInfo)oResult.Data;
Int32 configuredTime = tempCustomerInfo.ConfiguredTime;
cmbCountry.Text = "United Kingdom (London) (EU)";
DateTime dtCurent = DateTime.Now;
DateTime dtDelivery = dtCurent.AddMinutes(configuredTime);//As within 30-40 minutes order will be completed or completed.
int hour = dtDelivery.Hour;
int minute = dtDelivery.Minute;
string meridiem = dtDelivery.ToString("tt");
if (hour > 12) //If hour value is greater than 12 pm then go to 12 hr format clock settings
{
hour = hour - 12;
}
cmbHour.Text = hour.ToString();
cmbMinute.Text = minute.ToString();
cmbMeridiem.Text = meridiem;
//Showing the current city
XmlDocument xmlDoc = new XmlDocument();
string cityName = String.Empty;
string executableName = System.Reflection.Assembly.GetExecutingAssembly().Location;
FileInfo executableFileInfo = new FileInfo(executableName);
string currentDirectory = executableFileInfo.DirectoryName + "\\Config";
xmlDoc.Load(currentDirectory + "\\CommonConstants.xml");
XmlNode appSettingsNode =
xmlDoc.SelectSingleNode("CCommonConstants/cityname");
cityName = appSettingsNode.InnerText;
txtTown.Text = cityName;
if (CustomerListForm.m_phoneNumber.Length > 0)
{
txtPhoneNumber.Text = CustomerListForm.m_phoneNumber;
btnSearchByPhone_Click(sender, e);
}
}
else
{
//For modifying customer from order details form.
CResult oResult = tempCustomerManager.GetCustomerTakeawayInfo(m_iOrderID);
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
tempCustomerInfo = (CCustomerInfo)oResult.Data;
txtCustomerName.Text = tempCustomerInfo.CustomerName;
txtBuildingName.Text = tempCustomerInfo.BuildingName;
txtFloorAptNumber.Text = tempCustomerInfo.FloorAptNumber;
txtHouseNumber.Text = tempCustomerInfo.HouseNumber;
txtPhoneNumber.Text = tempCustomerInfo.CustomerPhone;
txtPostalCode.Text = tempCustomerInfo.CustomerPostalCode;
txtTown.Text = tempCustomerInfo.CustomerTown;
string[] street = new string[0];
street = tempCustomerInfo.StreetName.Split('-');
if (street.Length > 1)
{
txtStreetName.Text = street[0].ToString();
txtStreet2.Text = street[1].ToString();
}
else if (street.Length > 0 && street.Length < 2)
{
txtStreetName.Text = street[0].ToString();
}
cmbCountry.Text = tempCustomerInfo.CustomerCountry;
if (m_deliveryTime.Replace(" ", "").ToUpper() != "TakeAway".Replace(" ", "").ToUpper())
{
string[] delTime = m_deliveryTime.Split(':');
Int32 hourValue = Convert.ToInt32("0"+delTime[0].ToString());
cmbHour.Text = hourValue.ToString();
string[] minutes = delTime[1].Split(' ');
cmbMinute.Text =Convert.ToInt32(minutes[0]).ToString();
cmbMeridiem.Text = minutes[1].ToString();
//DeliveryRadioBtton.Checked = true;
}
else
{
CResult oResult2 = tempCustomerManager.CollectConfiguredTime();//Collect the configured time
tempCustomerInfo = new CCustomerInfo();
tempCustomerInfo = (CCustomerInfo)oResult2.Data;
Int32 configuredTime = tempCustomerInfo.ConfiguredTime;
DateTime dtCurent = DateTime.Now;
DateTime dtDelivery = dtCurent.AddMinutes(configuredTime);//As within 30-40 minutes order will be completed or completed.
int hour = dtDelivery.Hour;
int minute = dtDelivery.Minute;
string meridiem = dtDelivery.ToString("tt");
if (hour > 12) //If hour value is greater than 12 pm then go to 12 hr format clock settings
{
hour = hour - 12;
}
cmbHour.Text = hour.ToString();
cmbMinute.Text = minute.ToString();
cmbMeridiem.Text = meridiem;
//TakeAwayRadioButton.Checked = true;
}
}
txtPhoneNumber.Select();
m_cCurrentControl = txtPhoneNumber;
tmrCallerInfo.Start();
}
private void btnSearchByPhone_Click(object sender, EventArgs e)
{
if (txtPhoneNumber.Text.Equals("")) //If phone number is blank then return.
{
return;
}
try
{
string phone = txtPhoneNumber.Text.Trim();
this.ClearTextBoxes();
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult oResult = tempCustomerManager.CustomerInfoGetByPhone(phone);
if (oResult.IsSuccess && oResult.Data != null)
{
tempCustomerInfo = (CCustomerInfo)oResult.Data;
}
if (tempCustomerInfo.CustomerPhone.Length > 0)
{
txtPhoneNumber.Text = tempCustomerInfo.CustomerPhone;
}
txtCustomerName.Text = tempCustomerInfo.CustomerName;
txtPostalCode.Text = tempCustomerInfo.CustomerPostalCode;
txtBuildingName.Text = tempCustomerInfo.BuildingName;
txtFloorAptNumber.Text = tempCustomerInfo.FloorAptNumber;
txtHouseNumber.Text = tempCustomerInfo.HouseNumber;
string[] street=new string[0];
street=tempCustomerInfo.StreetName.Split('-');
if (street.Length > 1)
{
txtStreetName.Text = street[0].ToString();
txtStreet2.Text = street[1].ToString();
}
else if (street.Length > 0 && street.Length < 2)
{
txtStreetName.Text = street[0].ToString();
}
txtTown.Text = tempCustomerInfo.CustomerTown;
if (tempCustomerInfo.CustomerCountry.Length > 0)
{
cmbCountry.Text = tempCustomerInfo.CustomerCountry;
}
else
{
cmbCountry.Text = "United Kingdom (London) (EU)";
}
if (txtCustomerName.Text == String.Empty || txtCustomerName.Text == null)
{
MessageBox.Show("No customer has been found", RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
private void btnFindCustomer_Click(object sender, EventArgs e)
{
if (txtCustomerName.Text == "" || txtCustomerName.Text.Length < 1)
{
return;
}
try
{
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult oResult = tempCustomerManager.GetCustomerInfoByName(txtCustomerName.Text);
tempCustomerInfo = (CCustomerInfo)oResult.Data;
DataTable dtCustomerList = (DataTable)tempCustomerInfo.CustomerDataTable;
if (dtCustomerList.Rows.Count > 1)
{
CustomerListForm objCustomerList = new CustomerListForm(dtCustomerList);
objCustomerList.ShowDialog(this);
}
else if (dtCustomerList.Rows.Count == 1)
{
string phoneNumber = dtCustomerList.Rows[0]["phone"].ToString();
txtPhoneNumber.Text = phoneNumber;
btnSearchByPhone_Click(sender, e);
}
else
{
MessageBox.Show("No customer has been found",RMSGlobal.MessageBoxTitle,MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
SortedList ICustomerInfoDAO.GetCustomerAddresses(string p_houseNumber, string p_postCode)
{
SortedList slCustomerAddress = new SortedList();
string sqlCommand = String.Empty;
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
string[] houseNumberArray = new string[0];
try
{
this.OpenConnection();
if (p_houseNumber == String.Empty || p_houseNumber == null)
{
sqlCommand = String.Format(SqlQueries.GetQuery(Query.GetCustomerAddressWithoutHouseNumber), p_postCode.Replace(" ",""));
}
else
{
sqlCommand = String.Format(SqlQueries.GetQuery(Query.GetCustomerAddressDetails), p_houseNumber, p_postCode.Replace(" ", ""));
}
IDataReader oReader = this.ExecuteReader(sqlCommand);
string key ="";
if (oReader != null)
{
while (oReader.Read())
{
clsCustomerInfo objCustInfo = new clsCustomerInfo();
objCustInfo.ApartmentNumber = Convert.ToString(oReader["SBN"]);
objCustInfo.StreenName = Convert.ToString(oReader["STR"]);
objCustInfo.HouseNumber = Convert.ToString(oReader["NUM"]);
objCustInfo.Town = Convert.ToString(oReader["TWN"]);
objCustInfo.buildingName = Convert.ToString(oReader["BNA"]);
objCustInfo.PostalCode = p_postCode;
key = p_postCode.Replace(" ", "").ToUpper() + "-" + objCustInfo.ApartmentNumber.Replace(" ", "").ToUpper() + "-" + objCustInfo.HouseNumber.Replace(" ", "").ToUpper();
if (!slCustomerAddress.Contains(key))
{
slCustomerAddress.Add(key, objCustInfo);
}
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in CustomerInfoGetByCustomerID()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at CustomerInfoGetByCustomerID()", ex);
}
else
{
throw new Exception("Exception occure at CustomerInfoGetByCustomerID()", ex);
}
}
finally
{
this.CloseConnection();
}
return slCustomerAddress;
}
/// <summary>
/// This function collects the customer information taken from online
/// </summary>
/// <param name="p_orderID"></param>
/// <returns></returns>
public CResult GetOnlineCustomerInfoByOrderID(Int64 p_orderID)
{
try
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
m_oResult.Data = Database.Instance.Customer.GetCustomerTakeawayInfo(p_orderID);
m_oResult.IsSuccess = true;
m_oResult.Message = "Data Read Successfully";
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at GetOnlineCustomerInfoByOrderID() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in GetOnlineCustomerInfoByOrderID()", LogLevel.Error, "CCustomerManager");
}
return m_oResult;
}
public CCustomerInfo InsertCustomerInfo(CCustomerInfo inCustomerInfo)
{
inCustomerInfo.CustomerName = inCustomerInfo.CustomerName.Replace("''", "'");
inCustomerInfo.CustomerName = inCustomerInfo.CustomerName.Replace("'", "''");
inCustomerInfo.CustomerPhone = inCustomerInfo.CustomerPhone.Replace("''", "'");
inCustomerInfo.CustomerPhone = inCustomerInfo.CustomerPhone.Replace("'", "''");
inCustomerInfo.CustomerPostalCode = inCustomerInfo.CustomerPostalCode.Replace("''", "'");
inCustomerInfo.CustomerPostalCode = inCustomerInfo.CustomerPostalCode.Replace("'", "''");
inCustomerInfo.CustomerAddress = inCustomerInfo.CustomerAddress.Replace("''", "'");
inCustomerInfo.CustomerAddress = inCustomerInfo.CustomerAddress.Replace("'", "''");
inCustomerInfo.CustomerTown = inCustomerInfo.CustomerTown.Replace("''", "'");
inCustomerInfo.CustomerTown = inCustomerInfo.CustomerTown.Replace("'", "''");
inCustomerInfo.CustomerCounty = inCustomerInfo.CustomerCounty.Replace("''", "'");
inCustomerInfo.CustomerCounty = inCustomerInfo.CustomerCounty.Replace("'", "''");
inCustomerInfo.CustomerCountry = inCustomerInfo.CustomerCountry.Replace("''", "'");
inCustomerInfo.CustomerCountry = inCustomerInfo.CustomerCountry.Replace("'", "''");
inCustomerInfo.UserName = inCustomerInfo.UserName.Replace("'", "''");
CCustomerInfo tempCustomerInfo = inCustomerInfo;
try
{
this.OpenConnection();
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.CustomerInsert),
inCustomerInfo.CustomerName,inCustomerInfo.FloorAptNumber,inCustomerInfo.BuildingName,inCustomerInfo.HouseNumber,inCustomerInfo.CustomerPhone, inCustomerInfo.CustomerPostalCode, inCustomerInfo.CustomerTown, inCustomerInfo.CustomerCountry,inCustomerInfo.UserName,inCustomerInfo.InsertDate,inCustomerInfo.TerminalId,inCustomerInfo.StreetName);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = SqlQueries.GetQuery(Query.ScopeIdentity);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
bool bIsRead = oReader.Read();
if (bIsRead)
{
tempCustomerInfo.CustomerID = Int64.Parse(oReader[0].ToString());
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in InsertCustomerInfo()", LogLevel.Error, "Database");
throw new Exception("Exception occure at InsertCustomerInfo()", ex);
}
finally
{
this.CloseConnection();
}
return tempCustomerInfo;
}
public CResult UpdateCustomerInfo(CCustomerInfo inCustomerInfo)
{
try
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
Database.Instance.Customer.UpdateCustomerInfo(inCustomerInfo);
m_oResult.IsSuccess = true;
m_oResult.Message = "Data Updated Successfully";
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at UpdateCustomerInfo() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in UpdateCustomerInfo()", LogLevel.Error, "CCustomerManager");
}
return m_oResult;
}
private CCustomerInfo CollectAddressDetailsInfo(IDataReader inReader)
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
if (inReader["NUM"] != null)
tempCustomerInfo.HouseNumber = inReader["NUM"].ToString();
if (inReader["BNA"] != null)
tempCustomerInfo.BuildingName = inReader["BNA"].ToString();
if (inReader["DST"] != null)
tempCustomerInfo.StreetName = inReader["DST"].ToString();
if (inReader["TWN"] != null)
tempCustomerInfo.CustomerTown = inReader["TWN"].ToString();
if (inReader["PCD"] != null)
tempCustomerInfo.CustomerPostalCode = inReader["PCD"].ToString();
if (inReader["STR"] != null)
tempCustomerInfo.StreetName = inReader["STR"].ToString();
return tempCustomerInfo;
}
private void FillOrders()
{
COrderManager tempOrderManager = new COrderManager();
List<COrderShow> tempOrderShowList = (List<COrderShow>)tempOrderManager.OrderListShowByStatus("Paid").Data;
dgvCurrentOrders.RowCount = 0;
for (int orderCounter = 0; orderCounter < tempOrderShowList.Count; orderCounter++)
{
CTableIcon tableIcon = new CTableIcon();
tableIcon.User = tempOrderShowList[orderCounter].UserName;
tableIcon.GuestCount = tempOrderShowList[orderCounter].GuestCount.ToString();
tableIcon.TableName = tempOrderShowList[orderCounter].TableName;
tableIcon.Type = tempOrderShowList[orderCounter].OrderType;
tableIcon.OrderID = tempOrderShowList[orderCounter].OrderID;
if (tableIcon.Type.Equals("Table"))
{
tableIcon.TableName = "Table " + tempOrderShowList[orderCounter].TableNumber.ToString();
}
else if (tableIcon.Type.Equals("Tabs"))
{
tableIcon.TableName = "Tab " + tempOrderShowList[orderCounter].TableNumber.ToString();
}
else if (tableIcon.Type.Equals("TakeAway"))
{
COrderInfo temp2OrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(tempOrderShowList[orderCounter].OrderID).Data;
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerinfo = new CCustomerInfo();
tempCustomerinfo = (CCustomerInfo)tempCustomerManager.CustomerInfoGetByCustomerID(temp2OrderInfo.CustomerID).Data;
if (tempCustomerinfo != null)
{
tableIcon.TableName = tempCustomerinfo.CustomerName;
}
else
{
tableIcon.TableName = "Take Away";
}
tableIcon.GuestCountLabel.Text = tempOrderShowList[orderCounter].Status;
}
DataGridViewRowCollection dgvRow = (DataGridViewRowCollection)dgvCurrentOrders.Rows;
dgvRow.Add(tableIcon.OrderID, tableIcon.TableName, tempOrderShowList[orderCounter].OnlineOrderID);
}
}
private void DepositSearchButton_Click(object sender, EventArgs e)
{
try
{
Int64 tempDepositSerial = Int64.Parse(DepositSerialTextBox.Text.Trim());
DepositDataGridView.Rows.Clear();
CDepositManager tempDepositManager = new CDepositManager();
CDeposit tempDeposit = new CDeposit();
CResult oResult = tempDepositManager.DepositGetByDepositID(tempDepositSerial);
if (oResult.IsSuccess && oResult.Data != null)
{
tempDeposit = (CDeposit)oResult.Data;
}
if (tempDeposit.DepositBalance != 0)
{
string[] newRow ={
tempDeposit.DepositID.ToString(),
new DateTime(tempDeposit.DepositTime).ToShortDateString(),
tempDeposit.DepositTotalAmount.ToString("F02"),
tempDeposit.DepositBalance.ToString("F02"),
tempDeposit.DepositType
};
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
oResult = tempCustomerManager.CustomerInfoGetByCustomerID(tempDeposit.CustomerID);
if (oResult.IsSuccess && oResult.Data != null)
{
tempCustomerInfo = (CCustomerInfo)oResult.Data;
}
CustomerLabel.Text = tempCustomerInfo.CustomerName;
PhoneLabel.Text = tempCustomerInfo.CustomerPhone;
DepositDataGridView.Rows.Add(newRow);
}
else
{
MessageBox.Show("No deposit information found. This deposit may be already used or never existed.", "Info",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
DepositDataGridView.RowCount = 13;
}
catch (Exception exp)
{
throw exp;
}
}
private CCustomerInfo ReaderToCustomerInfo(IDataReader inReader)
{
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
if (inReader["customer_id"] != null)
tempCustomerInfo.CustomerID = Int64.Parse(inReader["customer_id"].ToString());
if (inReader["name"] != null)
tempCustomerInfo.CustomerName= inReader["name"].ToString();
if (inReader["phone"] != null)
tempCustomerInfo.CustomerPhone= inReader["phone"].ToString();
if (inReader["postal_code"] != null)
tempCustomerInfo.CustomerPostalCode = inReader["postal_code"].ToString();
if (inReader["address"] != null)
tempCustomerInfo.CustomerAddress = inReader["address"].ToString();
if (inReader["town"] != null)
tempCustomerInfo.CustomerTown = inReader["town"].ToString();
if (inReader["county"] != null)
tempCustomerInfo.CustomerCounty = inReader["county"].ToString();
if (inReader["country"] != null)
tempCustomerInfo.CustomerCountry = inReader["country"].ToString();
return tempCustomerInfo;
}
private void SaveButton_Click(object sender, EventArgs e)
{
try
{
CDepositManager tempDepositManager = new CDepositManager();
CDeposit tempDeposit = new CDeposit();
Double tempCash = 0.000;
Double tempEFT = 0.000;
Double tempCheque = 0.000;
Double tempAccount = 0.000;
Double tempTotal = 0.000;
Double.TryParse(g_CashLabel.Text.Substring(1), out tempCash);
Double.TryParse(g_EFTLabel.Text.Substring(1), out tempEFT);
Double.TryParse(g_ChequeLabel.Text.Substring(1), out tempCheque);
Double.TryParse(g_AccountLabel.Text.Substring(1), out tempAccount);
Double.TryParse(g_DepositTotalLabel.Text.Substring(1), out tempTotal);
if (tempTotal == 0)
{
MessageBox.Show("Zero amount given for deposit. Please recheck", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
tempDeposit.DepositBalance = tempTotal;
tempDeposit.DepositTime = DateTime.Now.Ticks;
tempDeposit.CustomerID=m_iCustomerID;
tempDeposit.DepositTotalAmount = tempTotal;
tempDeposit.DepositType = m_sDepositType;
tempDeposit.Status = 1;
CPcInfoManager tempPcInfoManager = new CPcInfoManager();
IPHostEntry ipEntry = System.Net.Dns.GetHostByName(Dns.GetHostName());
CPcInfo tempPcInfo=new CPcInfo();
CResult oResult= tempPcInfoManager.PcInfoByPcIP(ipEntry.AddressList[0].ToString());
if (oResult.IsSuccess && oResult.Data != null)
{
tempPcInfo = (CPcInfo)oResult.Data;
}
tempDeposit.PcID = tempPcInfo.PcID;
oResult = tempDepositManager.InsertDeposit(tempDeposit);
if (oResult.IsSuccess && oResult.Data != null)
{
tempDeposit = (CDeposit)oResult.Data;
}
//get customer name & phone
CCustomerManager tempCustomerManager= new CCustomerManager();
CCustomerInfo tempCustomerInfo= new CCustomerInfo();
oResult = tempCustomerManager.CustomerInfoGetByCustomerID(m_iCustomerID);
if(oResult.IsSuccess && oResult.Data!=null)
{
tempCustomerInfo = (CCustomerInfo)oResult.Data;
}
//string serialBody = "\r\n Deposit Token\r\n";
//serialBody += "\r\n Customer Name: "+tempCustomerInfo.CustomerName;
//serialBody += "\r\n Phone: " + tempCustomerInfo.CustomerPhone+"\r\n";
//serialBody += "\r\n By " + tempDeposit.DepositType;
//serialBody += "\r\n---------------------------------";
//serialBody += "\r\n Total: " + tempDeposit.DepositBalance.ToString("F02");
//serialBody += "\r\n";
//serialBody += "\r\nS/N: " + tempDeposit.DepositID.ToString();
string serialBody = "\r\n Deposit Token\r\n";
DateTime tempODate = new DateTime(tempDeposit.DepositTime);
string tempODateString = "Deposit Date: " + tempODate.ToLongDateString();
serialBody += "".PadRight((int)((45 - tempODateString.Length) / 2), ' ') + tempODateString.Trim() + "\r\n";
string tempDateString = "Reprint Date: " + DateTime.Now.ToLongDateString();
serialBody += "".PadRight((int)((45 - tempDateString.Length) / 2), ' ') + tempDateString.Trim() + "\r\n\r\n";
serialBody += "Customer Name: " + tempCustomerInfo.CustomerName + "\r\n";
string tempAddressString = "Customer Address: " + tempCustomerInfo.CustomerAddress.Trim();
if (tempAddressString.Length > 40)
{
tempAddressString = tempAddressString.Substring(0, 40) + "\r\n".PadRight(19, ' ') + tempAddressString.Substring(40);
}
serialBody += tempAddressString + "\r\n";
serialBody += "Phone: " + tempCustomerInfo.CustomerPhone + "\r\n\r\n";
serialBody += "Deposit Type: " + tempDeposit.DepositType + "\r\n";
serialBody += "Deposited Amount: " + tempDeposit.DepositTotalAmount.ToString("F02") + "\r\n";
double tempDepositUsed = (tempDeposit.DepositTotalAmount - tempDeposit.DepositBalance);
serialBody += "Deposit Used: " + tempDepositUsed.ToString("F02") + "\r\n";
serialBody += "---------------------------------\r\n";
serialBody += "Total Balance: " + tempDeposit.DepositBalance.ToString("F02") + "\r\n\r\n";
serialBody += "S/N: " + tempDeposit.DepositID.ToString() + "\r\n";
CPrintMethods tempPrintMethods = new CPrintMethods();
tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER,"",serialBody,"",tempDeposit.DepositID.ToString());
this.Close();
}
catch (Exception eee)
{
}
}
private void SetMembershipCard()
{
try
{
for (int recordCounter = 0; recordCounter < CustomerDataGridView.Rows.Count; recordCounter++)
{
if (CustomerDataGridView.Rows[recordCounter].Selected == true && CustomerDataGridView.Rows[recordCounter].Cells["PhoneColumn"].Value != null)
{
//DialogResult tempDialogResult = MessageBox.Show("WARNING!!!\nDeleting this Customer may also delete some other information.\nAre you sure to delete this Customer?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
//if (tempDialogResult.Equals(DialogResult.No)) return;
//else
//{
string phone = CustomerDataGridView.Rows[recordCounter].Cells[4].Value.ToString();
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = new CCustomerInfo();
CResult tempResult = tempCustomerManager.CustomerInfoGetByPhone(phone);
if (tempResult.IsSuccess)
{
CMemberShipAddForm tempCustomerInfoForm = new CMemberShipAddForm("Update", (CCustomerInfo)tempResult.Data);
tempCustomerInfoForm.ShowDialog();
// CFormManager.Forms.Push(this);
// this.Hide();
}
}
}
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
