public CMemberShipCardAddForm(String inOpType, MembershipCard inCustomer)
{
InitializeComponent();
m_sOpType = inOpType;
membershipCard = inCustomer;
this.ScreenTitle = "Membership Card";
}
private void SelectMembershipCard()
{
try
{
if (row_index == -1)
return;
Form tempForm;
bool isFound = false;
//for (int rowIndex = 0; rowIndex < dgvMembershipCard.Rows.Count; rowIndex++)
//{
if (dgvMembershipCard.Rows[row_index].Selected == true && dgvMembershipCard.Rows[row_index].Cells["id"].Value != null)
{
long ID = Convert.ToInt64(dgvMembershipCard.Rows[row_index].Cells["id"].Value.ToString()); //for phone number
membershipCard = membershipCardDao.GetMembershipCardByID(ID);
this.DialogResult = DialogResult.OK;
isFound = true;
// tempForm = CFormManager.Forms.Pop();
// tempForm.Show();
// this.Close();
//if (tempResult.IsSuccess)
//{
// CCustomerInfoForm tempCustomerInfoForm = new CCustomerInfoForm("Update", (CCustomerInfo)tempResult.Data);
// tempCustomerInfoForm.Show();
// CFormManager.Forms.Push(this);
// this.Hide();
//}
// break;
}
// }
if (!isFound)
{
this.DialogResult = DialogResult.No;
//// tempForm = CFormManager.Forms.Pop();
// tempForm.Show();
// this.Close();
}
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
public List<RMS.Common.ObjectModel.MembershipCard> GetAllMembershipCard()
{
List<MembershipCard> tempmembershipCardList = new List<MembershipCard> ();
MembershipCard tempmembershipCard = new MembershipCard();
try
{
this.OpenConnection();
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.GetAllMembershipCard));
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
tempmembershipCard = ReaderToMembershipCard(oReader);
tempmembershipCardList.Add(tempmembershipCard);
}
oReader.Close();
}
this.CommitTransection();
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in GetAllMembershipCard()", LogLevel.Error, "Database");
RollBackTransection();
throw new Exception("Exception occured at GetAllMembershipCard()", ex);
}
finally
{
this.CloseConnection();
}
return tempmembershipCardList;
}
//new Added
private MembershipCard ReaderToMembershipCard(IDataReader inReader)
{
MembershipCard tempMembershipCard = new MembershipCard();
if (inReader["code"] != null)
tempMembershipCard.code = inReader["code"].ToString();
if (inReader["creationDate"] != null && !inReader["creationDate"].ToString().Equals(""))
tempMembershipCard.creationDate = DateTime.Parse(inReader["creationDate"].ToString());
if (inReader["description"] != null)
tempMembershipCard.description = inReader["description"].ToString();
if (inReader["discountPercent"] != null)
tempMembershipCard.discountPercent = Convert.ToDouble(inReader["discountPercent"].ToString());
if (inReader["endDate"] != null)
tempMembershipCard.endDate = DateTime.Parse(inReader["endDate"].ToString());
if (inReader["startDate"] != null)
tempMembershipCard.startDate = DateTime.Parse(inReader["startDate"].ToString());
if (inReader["id"] != null)
tempMembershipCard.id = Convert.ToInt64(inReader["id"].ToString());
if (inReader["isActive"] != null)
tempMembershipCard.isActive = Convert.ToBoolean(inReader["isActive"].ToString());
if (inReader["name"] != null)
tempMembershipCard.name = Convert.ToString(inReader["name"].ToString());
if (inReader["points"] != null)
tempMembershipCard.points = Convert.ToDouble(inReader["points"].ToString());
if (inReader["title"] != null)
tempMembershipCard.title = inReader["title"].ToString();
if (inReader["type"] != null)
tempMembershipCard.type = inReader["type"].ToString();
return tempMembershipCard;
}
private void FillMembershipCard(MembershipCard membershipCard)
{
txtMembershipCardName.Tag = membershipCard;
dtpStartDate.Value = membershipCard.startDate;
dtpEndDate.Value = membershipCard.endDate;
txtMembershipCardName.Text = membershipCard.name;
cmbType.Text = membershipCard.type;
txtTitle.Text = membershipCard.title;
txtCode.Text = membershipCard.code;
txtPoint.Text = membershipCard.points.ToString();
txtDiscountPercentRate.Text = membershipCard.discountPercent.ToString();
}
private void FinishButton_Click(object sender, EventArgs e)
{
IMembershipCardDao membershipCardDao = new MembershipCardDao();
try
{
if (CheckEmpty())
{
return;
}
if (isModify)
{
membershipCard = txtMembershipCardName.Tag as MembershipCard;
}
else
{
membershipCard = new MembershipCard();
membershipCard.creationDate = System.DateTime.Now;
}
membershipCard.startDate = dtpStartDate.Value;
membershipCard.endDate = dtpEndDate.Value;
membershipCard.name = txtMembershipCardName.Text;
membershipCard.type = cmbType.Text;
if (rdbActive.Checked)
{
membershipCard.isActive = rdbActive.Checked;
}
else if (rdbInActive.Checked)
{
membershipCard.isActive = false;
}
membershipCard.title = txtTitle.Text;
membershipCard.code = txtCode.Text;
if (txtPoint.Text != null && !txtPoint.Text.ToString().Equals(""))
{
membershipCard.points = Convert.ToDouble(txtPoint.Text);
}
else
{
membershipCard.points = 0;
}
if (txtDiscountPercentRate.Text != null && !txtDiscountPercentRate.Text.ToString().Equals(""))
{
membershipCard.discountPercent = Convert.ToDouble(txtDiscountPercentRate.Text);
}
membershipCard.description = txtDescription.Text;
if (isModify)
{
membershipCardDao.UpdateMembershipCard(membershipCard);
MessageBox.Show("Membership Card " + membershipCard.id + " updated successfully");
}
else
{
membershipCardDao.AddMembershipCard(membershipCard);
MessageBox.Show("Membership Card " + membershipCard.id + " created successfully");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
//Console.Write(exp.Message);
}
}
