private void btnEdit_Click(object sender, RoutedEventArgs e)
{
ClientModel cm = dgvClient.SelectedItem as ClientModel;
if (cm != null)
{
int id = Convert.ToInt32(cm.ID1);
cm = getClientDetails(id);
cm.ID1 = id.ToString();
if (cm.isLoyal.Equals("1"))
{
LoyaltyCardModel lcm = getServiceCountForLoyaltyOwner(cm.LoyaltyID);
cm.ServiceCount = lcm.ServiceCount.ToString();
cm.FirstFree = lcm.FirstFree;
cm.SecondFree = lcm.SecondFree;
}
cm.IfViewDetails = false;
cm.IfEditDetails = true;
ClientDetails cd = new ClientDetails(this, cm, user);
cd.ShowDialog();
}
else
{
System.Windows.MessageBox.Show("No record selected!");
}
}
public HttpResponseMessage Post(LoyaltyCardModel model)
{
try
{
var entity = model.ToEnity();
entity.CreatedOn = DateTime.UtcNow;
entity.ModifiedOn = DateTime.UtcNow;
var CardTypes = _loyaltyCardTypeService.All();
var CardType = _loyaltyCardTypeService.Find(x => x.SpentThreshold <= entity.TotalSpent)?.FirstOrDefault();
entity.LoyaltyCardTypeId = CardType.Id;
entity.StartDate = DateTime.UtcNow;
if (CardType != null)
{
entity.EndDate = entity.StartDate.Value.AddDays(CardType.Duration);
}
else
{
entity.EndDate = entity.StartDate;
}
_loyaltyCardService.Insert(entity);
return(Request.CreateResponse(HttpStatusCode.OK, "Card is Created!"));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, e));
}
}
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
LoyaltyCardModel loyalty = dgvLoyaltyCard.SelectedItem as LoyaltyCardModel;
if (loyalty != null)
{
LoyalCardDetails lcd = new LoyalCardDetails(this, loyalty);
lcd.ShowDialog();
}
else
{
System.Windows.MessageBox.Show("No record selected!");
}
}
private List <LoyaltyCardModel> getCardWithNoClient()
{
List <LoyaltyCardModel> lstLoyaltyCard = new List <LoyaltyCardModel>();
LoyaltyCardModel loyalty = new LoyaltyCardModel();
queryString = "SELECT dbspa.tblloyaltycard.ID, serialnumber FROM dbspa.tblloyaltycard WHERE dbspa.tblloyaltycard.clientID = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
loyalty.ID = reader["ID"].ToString();
loyalty.SerialNumber = reader["serialnumber"].ToString();
loyalty.ClientName = "";
lstLoyaltyCard.Add(loyalty);
loyalty = new LoyaltyCardModel();
}
conDB.closeConnection();
return(lstLoyaltyCard);
}
private LoyaltyCardModel getServiceCountForLoyaltyOwner(string cardID)
{
LoyaltyCardModel lcm = new LoyaltyCardModel();
queryString = "SELECT servicecount, firstfree, secondfree FROM dbspa.tblloyaltycard WHERE ID = ?";
parameters = new List <string>();
parameters.Add(cardID);
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
lcm.ServiceCount = Convert.ToInt32(reader["servicecount"].ToString());
lcm.FirstFree = reader["firstfree"].ToString();
lcm.SecondFree = reader["secondfree"].ToString();
}
conDB.closeConnection();
return(lcm);
}
public IActionResult Post([FromRoute] string value)
{
var model = new LoyaltyCardModel()
{
ID = DateTime.UtcNow.Ticks.ToString(),
};
if (string.IsNullOrWhiteSpace(value))
{
model.Code = "LT" + model.ID;
}
model.Code = value.Substring(0, 2).ToUpper() + model.ID;
model.LoyaltyCartTypeId = 0;
model.CreatedOn = DateTime.UtcNow;
model.ModifiedOn = DateTime.UtcNow;
var loyatyCardDA = new LoyaltyCardDataAccess();
loyatyCardDA.SaveToDatabase(model);
return(Ok("Done"));
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
DialogResult dialogResult = System.Windows.Forms.MessageBox.Show("Are you sure you want to Delete record?", "Delete Record", MessageBoxButtons.YesNo);
if (dialogResult == System.Windows.Forms.DialogResult.Yes)
{
LoyaltyCardModel lc = dgvLoyaltyCard.SelectedItem as LoyaltyCardModel;
if (lc != null)
{
deleteRecord(lc.ID);
if (!string.IsNullOrEmpty(lc.ClientName))
{
removeLoyaltyCardFromClient(lc.ID);
}
loadDataGridDetails();
System.Windows.MessageBox.Show("RECORD DELETED SUCCESSFULLY!");
}
}
}
private void loadDataGridDetails()
{
List <LoyaltyCardModel> lstLoyaltyCard = new List <LoyaltyCardModel>();
LoyaltyCardModel loyalty = new LoyaltyCardModel();
queryString = "SELECT dbspa.tblloyaltycard.ID, dbspa.tblclient.ID AS 'clientID', serialnumber,CONCAT(dbspa.tblclient.firstName, ' ', dbspa.tblclient.lastName) as 'Whole Name' " +
"FROM (dbspa.tblloyaltycard INNER JOIN dbspa.tblclient ON dbspa.tblloyaltycard.clientID = dbspa.tblclient.ID)";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
loyalty.ID = reader["ID"].ToString();
loyalty.ClientID = reader["clientID"].ToString();
loyalty.SerialNumber = reader["serialnumber"].ToString();
loyalty.ClientName = reader["Whole Name"].ToString();
lstLoyaltyCard.Add(loyalty);
loyalty = new LoyaltyCardModel();
}
conDB.closeConnection();
lstLoyaltyCard.AddRange(getCardWithNoClient());
loyaltyWindow.dgvLoyaltyCard.ItemsSource = lstLoyaltyCard;
}
private void fillLoyaltyCards()
{
queryString = "SELECT ID, serialnumber FROM dbspa.tblloyaltycard WHERE isDeleted = 0 AND clientID = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
LoyaltyCardModel lcm = new LoyaltyCardModel();
lcm.ID = reader["ID"].ToString();
lcm.SerialNumber = reader["serialnumber"].ToString();
cmbLoyaltycards.Items.Add(lcm);
if (clientModel != null)
{
if (lcm.ID.Equals(clientModel.LoyaltyID))
{
cmbLoyaltycards.SelectedItem = lcm;
}
}
}
conDB.closeConnection();
}
public LoyalCardDetails(LoyaltyCardWindow lcw, LoyaltyCardModel lcm)
{
loyaltyWindow = lcw;
loyaltyCard = lcm;
InitializeComponent();
}
private bool insertClientRecord(string serial, string cod)
{
bool allCorrect = false;
LoyaltyCardModel loyalCard = cmbLoyaltycards.SelectedItem as LoyaltyCardModel;
try
{
queryString = "INSERT INTO dbspa.tblclient (dateServiced, datejoined,serialNo,cod,firstName,lastName,address,phonenumber,servicemode,totalamt,timeIn,timeOut,isDeleted,isLoyal,LoyaltyID) " +
" VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
parameters = new List <string>();
DateTime date = DateTime.Parse(datePicker.Text);
parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
parameters.Add(serial.ToString());
parameters.Add(cod.ToString());
parameters.Add(txtFirstName.Text);
parameters.Add(txtLastName.Text);
parameters.Add(txtAddress.Text);
if (string.IsNullOrEmpty(txtPhoneNumber.Text))
{
parameters.Add("0");
}
else
{
parameters.Add(txtPhoneNumber.Text);
}
parameters.Add(cmbServiceMode.SelectedValue.ToString());
parameters.Add("0");
parameters.Add(timeInPicker.Text);
parameters.Add("0");
parameters.Add(0.ToString());
if (chkAvailLoyalty.IsChecked == true)
{
parameters.Add("1");
if (loyalCard != null)
{
parameters.Add(loyalCard.ID);
}
}
else
{
parameters.Add("0");
parameters.Add("0");
}
conDB.AddRecordToDatabase(queryString, parameters);
conDB.closeConnection();
allCorrect = true;
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("Failed to save record!" + ex.Message);
Console.WriteLine(ex.Message);
allCorrect = false;
}
return(allCorrect);
}
