private List <string> Get_Lic_Data()
{
List <string> retData = new List <string>();
try
{
string Prc_id = GetProc_Id();
string HDD_id = GetHardDiskSerialNo();
string OS_id = GetOSSerialNo();
string Comp_data = "";
Database.ConnStr db = new Database.ConnStr();
DataTable dtbl = db.GetCompInfo();
if (dtbl.Rows.Count > 0)
{
retData.Add(dtbl.Rows[0]["ID"].ToString());
retData.Add(dtbl.Rows[0]["Client_Name"].ToString());
retData.Add(dtbl.Rows[0]["Client_Place"].ToString());
retData.Add(dtbl.Rows[0]["Mobile_No"].ToString());
retData.Add(dtbl.Rows[0]["Lic_info"].ToString());
retData.Add(dtbl.Rows[0]["Lic_Status"].ToString());
Comp_data = dtbl.Rows[0]["Client_Name"].ToString() + dtbl.Rows[0]["Mobile_No"].ToString();
}
retData.Add(Prc_id + HDD_id + OS_id + Comp_data);
}
catch
{
}
return(retData);
}
private void Save()
{
try
{
decimal enterpoint = decimal.Parse(txtPoints.Text.Trim());
if (intType > 0)
{
if (enterpoint > availpoint)
{
MessageBox.Show("Availalble Point is " + availpoint + " only" + Environment.NewLine
+ "This customer can not redeem " + enterpoint + " Points");
txtPoints.Focus();
return;
}
}
Database.ConnStr obj = new Database.ConnStr();
string sql = "call SP_SavePoint('" + dtpDate.Value.ToString("yyyy-MM-dd")
+ "','" + txtBarcode.Tag.ToString()
+ "','" + txtPoints.Text.Trim()
+ "','" + intType
+ "')";
obj.RunQuery(sql);
MessageBox.Show("Record Saved!", "Smart Loyalty", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshGrid();
ClearText();
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, ":: User Account ::", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void radioButton_Click(object sender, EventArgs e)
{
RadioButton rb = (RadioButton)sender;
string sql = "";
int Cust_Id = (cmbCustomer.SelectedValue != null) ? int.Parse(cmbCustomer.SelectedValue.ToString()) : 0;
if (rb.Checked)
{
if (rb.Name == "RB1")
{
sql = string.Format("Call SP_Report_Details(0,'" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "','" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "');", "");
}
else if (rb.Name == "RB2")
{
sql = string.Format("Call SP_Report_Details(" + Cust_Id + ",'" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "','" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "');", "");
}
else if (rb.Name == "RB3")
{
sql = string.Format("Call SP_Report_Summary(0,'" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "','" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "');", "");
}
else if (rb.Name == "RB4")
{
sql = string.Format("Call SP_Report_Summary(" + Cust_Id + ",'" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "','" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "');", "");
}
else if (rb.Name == "RB5")
{
sql = string.Format("Call SP_Report_PendingPoints();", "");
}
Database.ConnStr obj = new Database.ConnStr();
DataTable dt = new DataTable();
dt = obj.GetRecords(sql);
dgvReprt.DataSource = dt;
}
}
private void LoadWidgetData()
{
try
{
Database.ConnStr obj = new Database.ConnStr();
string sql;
DataTable dt = new DataTable();
sql = string.Format("SELECT FORMAT(CustTotal,0) AS CustTotal," +
" FORMAT(EarndPoint,0) AS EarndPoint," +
" FORMAT(RedPoint, 0) AS RedPoint, " +
" FORMAT(EarndPoint-RedPoint,0) AS AvailPoint FROM ( SELECT " +
" (SELECT Count(*) FROM tbl_customers) as CustTotal, " +
" (SELECT SUM(Point) FROM tbl_point_add) as EarndPoint," +
" (SELECT SUM(Point) FROM tbl_point_redeem) as RedPoint)t; ", "");
dt = obj.GetRecords(sql);
if (dt.Rows.Count > 0)
{
lblCountCust.Text = dt.Rows[0]["CustTotal"].ToString();
lblCountAvailPoint.Text = dt.Rows[0]["AvailPoint"].ToString();
lblCountEarnedPoint.Text = dt.Rows[0]["EarndPoint"].ToString();
lblCountRedPoint.Text = dt.Rows[0]["RedPoint"].ToString();
}
}
catch
{
}
}
private void Save()
{
try
{
if (IsExistBarcode(txtBarcode.Text.Trim()))
{
MessageBox.Show("This Barcode already used!", "Smart Loyalty", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtBarcode.Focus();
}
else
{
Database.ConnStr obj = new Database.ConnStr();
string sql = "Insert into tbl_customers(Barcode, Cust_name, Place, Mobile, email) values('"
+ txtBarcode.Text.Trim() + "','" + txtname.Text.Trim() + "','" + txtplace.Text.Trim() + "','"
+ txtmobile.Text.Trim() + "','" + txtemail.Text.Trim() + "')";
obj.RunQuery(sql);
MessageBox.Show("Record Saved!", "Smart Loyalty", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshGrid();
ClearText();
}
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, ":: User Account ::", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void RefreshGrid()
{
Database.ConnStr obj = new Database.ConnStr();
string sql;
DataTable dt = new DataTable();
sql = string.Format("Call SP_ViewCustomerPointAlltrabs(" + intType + ")", "");
dt = obj.GetRecords(sql);
dgvPointadded.DataSource = dt;
txtBarcode.Focus();
}
private void FillCustomers()
{
Database.ConnStr obj = new Database.ConnStr();
string sql;
DataTable dt = new DataTable();
sql = string.Format("SELECT ID,concat(Barcode,'-',Cust_name) as Cname FROM smartl.tbl_customers;", "");
dt = obj.GetRecords(sql);
cmbCustomer.ValueMember = "ID";
cmbCustomer.DisplayMember = "Cname";
cmbCustomer.DataSource = dt;
}
private void RefreshGrid()
{
Database.ConnStr obj = new Database.ConnStr();
string sql;
DataTable dt = new DataTable();
sql = string.Format("Select * from tbl_customers", "");
dt = obj.GetRecords(sql);
dgvCust.DataSource = dt;
txtBarcode.Focus();
}
private bool IsExistBarcode(string strBarcode)
{
bool sts = false;
try
{
Database.ConnStr obj = new Database.ConnStr();
string sql;
DataTable dt = new DataTable();
sql = string.Format("Call SP_ViewDdetByBarcode(" + strBarcode + ")", "");
dt = obj.GetRecords(sql);
sts = (dt.Rows.Count > 0);
}
catch
{
}
return(sts);
}
private int Customer_detbyBarcode(string strBarcode)
{
int Cust_Id = 0;
try
{
Database.ConnStr obj = new Database.ConnStr();
string sql;
DataTable dt = new DataTable();
sql = string.Format("Call SP_ViewDdetByBarcode(" + strBarcode + ")", "");
dt = obj.GetRecords(sql);
if (dt.Rows.Count > 0)
{
Cust_Id = int.Parse(dt.Rows[0]["ID"].ToString());
string custde = "";
custde += String.Format("{0}\t{1}", "Name :", dt.Rows[0]["Cust_name"].ToString()) + Environment.NewLine;
custde += String.Format("{0}\t{1}", "Mobile :", dt.Rows[0]["Mobile"].ToString()) + Environment.NewLine;
custde += String.Format("{0}\t{1}", "Place :", dt.Rows[0]["Place"].ToString()) + Environment.NewLine;
sql = string.Format("Call SP_ViewAddRedTotalPoints(" + Cust_Id + ")", "");
dt = obj.GetRecords(sql);
if (dt.Rows.Count > 0)
{
decimal ep = 0;
decimal.TryParse(dt.Rows[0]["EarnedPoint"].ToString(), out ep);
decimal rp = 0;
decimal.TryParse(dt.Rows[0]["RedeemedPoint"].ToString(), out rp);
availpoint = ep - rp;
custde += String.Format("{0}\t{1}", "Earned Points :", ep) + Environment.NewLine;
custde += String.Format("{0}\t{1}", "Redeemed Points :", rp) + Environment.NewLine;
custde += String.Format("{0}\t{1}", "Available Points :", availpoint) + Environment.NewLine;
}
lblCustdet.Text = custde;
}
}
catch
{
}
return(Cust_Id);
}
private void Delete(int ID)
{
try
{
Database.ConnStr obj = new Database.ConnStr();
DialogResult dlk = MessageBox.Show("Do you want to delete the customer?", "Smart Loyalty", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlk == DialogResult.Yes)
{
string sql = "DELETE FROM tbl_customers WHERE ID = '" + ID + "'";
obj.RunQuery(sql);
MessageBox.Show("Record Deleted!", "Smart Loyalty", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshGrid();
}
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, "Smart Loyalty", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private int CheckUserLogin(string GivUid, string GivPswd)
{
Database.ConnStr obj = new Database.ConnStr();
string sql;
int ActUid = 0;
DataTable dt = new DataTable();
sql = string.Format("SELECT * FROM tbl_users;", "");
dt = obj.GetRecords(sql);
List <string> users = new List <string>();
List <string> passwords = new List <string>();
List <int> ids = new List <int>();
for (int i = 0; i < dt.Rows.Count; i++)
{
string tempUser, tempPassword;
int tmpID;
tmpID = int.Parse(dt.Rows[i]["ID"].ToString());
tempUser = dt.Rows[i]["Username"].ToString();
tempPassword = dt.Rows[i]["Password"].ToString();
ids.Add(tmpID);
users.Add(tempUser);
passwords.Add(tempPassword);
}
for (int x = 0; x < users.Count; x++)
{
if (users[x] == GivUid && passwords[x] == GivPswd)
{
ActUid = ids[x];
Database.Username = users[x];
}
}
if (ActUid < 1)
{
MessageBox.Show("Incorrect Username or Password!", "Samrt Loylty", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return(ActUid);
}
private void Edit()
{
try
{
Database.ConnStr obj = new Database.ConnStr();
string sql = "call SP_EditPoint(" + CurrID + ",'" + dtpDate.Value.ToString("yyyy-MM-dd")
+ "','" + txtBarcode.Tag.ToString()
+ "','" + txtPoints.Text.Trim()
+ "','" + intType
+ "')";
obj.RunQuery(sql);
MessageBox.Show("Record Updated!", "Smart Loyalty", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshGrid();
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, ":: User Account ::", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Edit()
{
try
{
Database.ConnStr obj = new Database.ConnStr();
string sql = "UPDATE tbl_customers SET "
+ " Barcode = '" + txtBarcode.Text
+ "', Cust_name = '" + txtname.Text
+ "', Place = '" + txtplace.Text
+ "', Mobile = '" + txtmobile.Text
+ "', email = '" + txtmobile.Text
+ "' WHERE ID = '" + CurrID + "'";
obj.RunQuery(sql);
MessageBox.Show("Record Updated!", "Smart Loyalty", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshGrid();
ClearText();
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, ":: User Account ::", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
