private void DataBinds()
{
if (!string.IsNullOrEmpty(MemberName.Trim()) || !string.IsNullOrEmpty(CustId.Trim()) || !string.IsNullOrEmpty(MemberCode.Trim()))
{
DataTable dt = null;
int totalCount = 0;
if (!string.IsNullOrEmpty(MemberName.Trim()) && NeedMemeberCode == "1")
{
dt = BLL.DealerInfo.Instance.GetMemberInfo(MemberName.Trim(), "", CustId.Trim(), "", PageCommon.Instance.PageIndex, PageSize, out totalCount);
}
else
{
dt = BLL.DealerInfo.Instance.GetMemberInfo(MemberName.Trim(), MemberCode.Trim(), CustId.Trim(), "", PageCommon.Instance.PageIndex, PageSize, out totalCount);
}
if (dt != null && dt.Rows.Count > 0)
{
try
{
repterFriendCustMappingList.DataSource = dt;
repterFriendCustMappingList.DataBind();
}
catch (Exception ex)
{
BLL.Loger.Log4Net.Error(ex.StackTrace);
}
}
litPagerDown.Text = PageCommon.Instance.LinkStringByPost(GetWhere(), GroupLength, totalCount, PageSize, PageCommon.Instance.PageIndex, 1);
}
}
private void LoadCustomers()
{
string query = @"SELECT c.CustomerId AS [Customer ID], c.Name, c.Phone as [Contact No.],
CONVERT(nVARCHAR(19), c.Date, 106) as [Inst. Date], b.BrandName as [Brand Name],
p.ProductName as [Product Name], s.Name AS [Salesman]
FROM Customer AS c LEFT OUTER JOIN
Brand AS b ON c.BrandId = b.BrandId LEFT OUTER JOIN
Product AS p ON c.ProductId = p.ProductId LEFT OUTER JOIN
Salesman AS s ON c.SalesmanId = s.SalesmanId";
switch (cboSearch.Text)
{
case "All":
break;
case "Customer ID":
long CustId;
try
{
CustId = Int64.Parse(txtSearch.Text);
query = query + " WHERE CustomerId = " + CustId.ToString();
}
catch (Exception)
{
MessageBox.Show("Invalid Customer ID, please enter valid Customer ID", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
break;
case "Contact No.":
query = query + " WHERE c.Phone like '%" + txtSearch.Text + "%'";
break;
case "Customer Name":
query = query + " WHERE c.Name like '%" + txtSearch.Text + "%'";
break;
case "Salesman Name":
query = query + " WHERE s.Name like '%" + txtSearch.Text + "%'";
break;
case "Brand":
query = query + " WHERE b.BrandName like '%" + txtSearch.Text + "%'";
break;
case "Product":
query = query + " WHERE p.ProductName like '%" + txtSearch.Text + "%'";
break;
}
//query = "select * from customer";
dtCustomers = dbWrapper.SelectData(query);
gridCustomer.DataSource = dtCustomers;
lblCount.Text = "Count: " + dtCustomers.Rows.Count.ToString();
txtCustomerName.Focus();
btnDelete.Enabled = false;
gridCustomer.Columns.Cast <DataGridViewColumn>().ToList().ForEach(f => f.SortMode = DataGridViewColumnSortMode.NotSortable);
}
private void btGetCustId_Click(object sender, EventArgs e)
{
int custId = 0;
int.TryParse(txtCustId.Text, out custId);
CustomerForm customerList = new CustomerForm();
customerList.isOpenByCustomerSelectUserControl = true;
customerList.CustId = custId;
customerList.ShowDialog();
if (customerList.CustId != 0)
{
CustId = customerList.CustId;
txtCustId.Text = CustId.ToString();
}
}
private string GetWhere()
{
string where = "";
string query = Request.Url.Query;
if ((!MemberName.Equals("")) || MemberName != null)
{
where += "&MemberName=" + BLL.Util.EscapeString(MemberName);
}
if ((!MemberCode.Equals("")) || MemberCode != null)
{
where += "&MemberCode=" + BLL.Util.EscapeString(MemberCode);
}
if ((!CustId.Equals("")) || CustId != null)
{
where += "&CustId=" + BLL.Util.EscapeString(CustId);
}
where += "&nmc=1&random=" + (new Random()).Next().ToString();
return(where);
}
//Rent movie implementation here
private void buttonRentMovie_Click(object sender, EventArgs e)
{
try
{
string CustId, MovieId, IssueDate, ReturnDate;
int totalDays = 0;
int temp = 0;
int TotalRent = 0;
CustId = cbCust.SelectedValue.ToString();
MovieId = cbMovi.SelectedValue.ToString();
IssueDate = dtissue.Value.ToShortDateString();
ReturnDate = dtReturn.Value.ToShortDateString();
if (CustId.Equals("") || CustId == null)
{
MessageBox.Show("Please select a customer", "Alert");
}
else if (MovieId.Equals("") || MovieId == null)
{
MessageBox.Show("Please select a movie", "Alert");
}
else if (DateTime.Parse(IssueDate) > DateTime.Parse(ReturnDate))
{
MessageBox.Show("Issue date can not be greater than retun date", "Alert");
}
else if (IssueDate == ReturnDate)
{
totalDays = 1;
temp = CalculateMovieRentCost(int.Parse(MovieId)); // Getting rent amount for that movie
TotalRent = totalDays * temp; // Calculate the Total Rent of issue movie
}
else
{
totalDays = Convert.ToInt32((DateTime.Parse(ReturnDate) - DateTime.Parse(IssueDate)).TotalDays);
temp = CalculateMovieRentCost(int.Parse(MovieId)); // Getting rent amount for that movie
TotalRent = totalDays * temp; // Calculate the Total Rent of issue movie
}
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "RentMovie";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MovieID", MovieId);
cmd.Parameters.AddWithValue("@CustID", CustId);
cmd.Parameters.AddWithValue("@RentDate", IssueDate);
cmd.Parameters.AddWithValue("@ReturnDate", ReturnDate);
cmd.Parameters.AddWithValue("@TotalRent", TotalRent);
bool result = cmd.ExecuteNonQuery() > 0;
if (result)
{
BindRentMovieGrid(); //method calling to Bind Grid for all rental movies
MessageBox.Show("Movie rented successfully!");
}
else
{
MessageBox.Show("Failed to rent this movie");
}
cmd.Dispose();
con.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
