/// <summary>
/// Added By : Himanshu Pandya
/// Date : 30-12-2012
/// Desc : Fill Customer Details from Cearch Search Popup
/// </summary>
public void BindCustomerDetails()
{
try
{
if (!string.IsNullOrEmpty(hdnCustomerId.Value))
{
objCustomer = new clsCustomer();
dtCustomer = new DataTable();
objCustomer.CustomerId = Convert.ToInt64(hdnCustomerId.Value);
dtCustomer = objCustomer.SearcheAllCustomerWSearchFilters();
if (dtCustomer.Rows.Count > 0)
{
//Fill Customer Details
txtFDCustomerNo.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["CustomerCode"].ToString()) ? dtCustomer.Rows[0]["CustomerCode"].ToString() : string.Empty;
ddlCustomerType.SelectedIndex = ddlCustomerType.Items.IndexOf(ddlCustomerType.Items.FindByText(dtCustomer.Rows[0]["CustomerTypeName"].ToString()));
ddlFDCustomernamePrefix.SelectedIndex = ddlFDCustomernamePrefix.Items.IndexOf(ddlFDCustomernamePrefix.Items.FindByText(dtCustomer.Rows[0]["NamePrifix"].ToString()));
txtFDCusotmerFirstname.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["FirstName"].ToString()) ? dtCustomer.Rows[0]["FirstName"].ToString() : string.Empty;
txtFDCustomerMiddlename.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["MiddleName"].ToString()) ? dtCustomer.Rows[0]["MiddleName"].ToString() : string.Empty;
txtFDCustomerLastname.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["LastName"].ToString()) ? dtCustomer.Rows[0]["LastName"].ToString() : string.Empty;
BindFixDepositeTypes();
}
}
}
catch
{ }
finally
{
objCustomer = new clsCustomer();
dtCustomer = new DataTable();
}
}
public void ListAndCountOK()
{
clsCustomerCollection AllCustomers = new clsCustomerCollection();
List <clsCustomer> TestList = new List <clsCustomer>();
clsCustomer TestCustomer = new clsCustomer();
TestCustomer.Customer_id = 1;
TestCustomer.Name = "Joe,Bloggs";
TestCustomer.Address = "2 Random Street,RandomTown,RandomCounty,RN27FT";
TestCustomer.Email = "*****@*****.**";
TestCustomer.Password = "******";
TestCustomer.Marketing_emails = false;
TestCustomer.Registration_date = DateTime.Now.Date;
TestList.Add(TestCustomer);
AllCustomers.CustomerList = TestList;
Assert.AreEqual(AllCustomers.Count, TestList.Count);
}
public void DateOfBirthExtremeMin()
{
//create instance of class we want
clsCustomer ACustomer = new clsCustomer();
//string variable to store error message
String Error = "";
//test data to pass
DateTime TestDate;
TestDate = DateTime.Now.Date.AddYears(-1000);//this should trigger an error
string DateOfBirth = TestDate.ToString();
//invoke method
Error = ACustomer.Valid(CustomerName, CustomerEmail, DateAdded,
DateOfBirth, Ballance);
//see if result is correct
Assert.AreNotEqual(Error, "");
}
public void CustomerListOK()
{
//create an instance of the class we want to create
clsCustomerCollection AllCustomers = new clsCustomerCollection();
//Test data to assign to property
List <clsCustomer> TestList = new List <clsCustomer>();
clsCustomer TestItem = new clsCustomer();
TestItem.ID = 1;
TestItem.FullName = "John Green";
TestItem.Address = "Test street";
TestItem.EmailAddress = "*****@*****.**";
TestItem.DateRegistered = DateTime.Now.Date;
TestItem.Above18 = true;
TestList.Add(TestItem);
AllCustomers.CustomerList = TestList;
Assert.AreEqual(AllCustomers.CustomerList, TestList);
}
public void CustomerDateOfBirthExtremeMin()
{
//create an instance of the class customer
clsCustomer ACustomer = new clsCustomer();
//string variable to store error message
string Error = "";
DateTime TestDate;
//set to todays date
TestDate = DateTime.Now.Date;
//convert date to a string variable
string CDOB = TestDate.ToString();
//invoke the method
Error = ACustomer.Valid(CName, CDOB, CEmail, CBillingAddress, CPass);
//test to see if result is correct
Assert.AreNotEqual(Error, "");
}
public void TestAnyCurrentOrdersFound()
{
clsCustomer AnCustomer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 2;
Found = AnCustomer.Find(CustomerNo);
if (AnCustomer.CurrentOrder != true)
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestCustomerShippingAddressFound()
{
clsCustomer AnCustomer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 2;
Found = AnCustomer.Find(CustomerNo);
if (AnCustomer.CustomerShippingAddress != "69 Zoo Doe")
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestCustomerEmailFound()
{
clsCustomer AnCustomer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 2;
Found = AnCustomer.Find(CustomerNo);
if (AnCustomer.CustomerEmail != "*****@*****.**")
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestCustomerNameFound()
{
clsCustomer AnCustomer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 2;
Found = AnCustomer.Find(CustomerNo);
if (AnCustomer.CustomerName != "Doe Cameron")
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestDateWhenJoinedFound()
{
clsCustomer AnCustomer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 2;
Found = AnCustomer.Find(CustomerNo);
if (AnCustomer.DateWhenJoined != Convert.ToDateTime("27/02/2020"))
{
OK = false;
}
Assert.IsTrue(OK);
}
public void UpdateMethodOK()
{
//create an instance of the class we waqnt to create
clsCustomerCollection AllCustomers = new clsCustomerCollection();
//create the item of test data
clsCustomer TestItem = new clsCustomer();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.CustomerID = 21;
TestItem.CustomerFirstName = "Sophie";
TestItem.CustomerLastName = "Vergara";
TestItem.Email = "*****@*****.**";
TestItem.TelephoneNo = "07965847361";
TestItem.Address1 = "123 ABC Lane";
TestItem.Address2 = "San Jose";
TestItem.PostCode = "SJ1 98KL";
TestItem.CustomerPassword = "******";
//set ThisCustomer to the test data
AllCustomers.ThisCustomer = TestItem;
//add the record
PrimaryKey = AllCustomers.Add();
//set the primary key of the test data
TestItem.CustomerID = PrimaryKey;
//modify the test data
TestItem.CustomerID = 21;
TestItem.CustomerFirstName = "Sophie";
TestItem.CustomerLastName = "Vergara";
TestItem.Email = "*****@*****.**";
TestItem.TelephoneNo = "07965847361";
TestItem.Address1 = "1 Apple Street";
TestItem.Address2 = "San Jose";
TestItem.PostCode = "SJ1 9OP";
TestItem.CustomerPassword = "******";
//set the record based on the new test data
AllCustomers.ThisCustomer = TestItem;
//update the record
AllCustomers.Update();
//find the record
AllCustomers.ThisCustomer.Find(PrimaryKey);
//test to see ThisCustomer matches the test data
Assert.AreEqual(AllCustomers.ThisCustomer, TestItem);
}
public void UpdateMethodOK()
{
//create an instance of the class we want to create
clsCustomerCollection AllCustomers = new clsCustomerCollection();
//create the item of test data
clsCustomer TestItem = new clsCustomer();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.Active = true;
TestItem.CustomerID = 21;
TestItem.FirstName = "Ryan";
TestItem.LastName = "Fretwell";
TestItem.Address = "Somewhere";
TestItem.PostCode = "LE30EB";
TestItem.PhoneNumber = "07775734887";
TestItem.EmailAddress = "*****@*****.**";
TestItem.DateAdded = DateTime.Now.Date;
//set ThisCustomer to the test data
AllCustomers.ThisCustomer = TestItem;
//add the record
PrimaryKey = AllCustomers.Add();
//set the primary key of the test data
TestItem.CustomerID = PrimaryKey;
//modify the test data
TestItem.Active = false;
TestItem.CustomerID = 11;
TestItem.FirstName = "Ryann";
TestItem.LastName = "Fretwelll";
TestItem.Address = "Somewheree";
TestItem.PostCode = "LE20EB";
TestItem.PhoneNumber = "07775734888";
TestItem.EmailAddress = "*****@*****.**";
TestItem.DateAdded = DateTime.Now.Date;
//set the record based on the new test data
AllCustomers.ThisCustomer = TestItem;
//update the record
AllCustomers.Update();
//find the record
AllCustomers.ThisCustomer.Find(PrimaryKey);
//test to see ThisCustomer matches the test data
Assert.AreEqual(AllCustomers.ThisCustomer, TestItem);
}
public void UpdateMethodOK()
{
//create an instance of the class we want to create
clsCustomerCollection AllCustomer = new clsCustomerCollection("Fbloggs");
//create an instance of test data
clsCustomer TestItem = new clsCustomer();
//var to store primary key
Int32 PK = 0;
//set the properties
TestItem.FirstName = "fred";
TestItem.Surname = "bloggs";
TestItem.dateOfBirth = DateTime.Now.Date.AddYears(-19);
TestItem.Gender = "male";
TestItem.ContactNumber = "01167";
TestItem.EMail = "*****@*****.**";
TestItem.HouseNo = "2";
TestItem.PostCode = "LE5 6HP";
TestItem.Title = "Mr";
//set ThisCustomer to validate test data
AllCustomer.ThisCustomer = TestItem;
//add the record
PK = AllCustomer.Add();
//set primary key of test data
TestItem.Id = PK;
//modify the record
TestItem.FirstName = "fred";
TestItem.Surname = "bloggs";
TestItem.dateOfBirth = DateTime.Now.Date.AddYears(-19);
TestItem.Gender = "male";
TestItem.ContactNumber = "01167";
TestItem.EMail = "*****@*****.**";
TestItem.HouseNo = "2";
TestItem.PostCode = "LE5 6HP";
TestItem.Title = "Mr";
//set the record based on the new record
AllCustomer.ThisCustomer = TestItem;
//update the record
AllCustomer.Update();
//find the record
AllCustomer.ThisCustomer.Find(PK);
//test to see that it exists
Assert.AreEqual(AllCustomer.ThisCustomer, TestItem);
}
public void DateaddedMin()
{
//create an instance of the class we want
clsCustomer AnCustomer = new clsCustomer();
//string variable to store any error message
String Error = "";
//create a variable to store the test data
DateTime TestDate;
//set the data to todays date
TestDate = DateTime.Now.Date;
//convert the data variable to a string variable
string Dateadded = TestDate.ToString();
//invoke the method
Error = AnCustomer.Valid(CustomerFirstName, CustomerLastName, CustomerUserName, Dateadded);
//test to see that the results is correct
Assert.AreEqual(Error, "");
}
public void ListAndCountOK()
{
clsCustomerCollection AllCustomers = new clsCustomerCollection();
List <clsCustomer> TestList = new List <clsCustomer>();
clsCustomer TestItem = new clsCustomer();
//TestItem.Active = true;
TestItem.ProductNo = 1;
TestItem.PhoneNumber = "0777777777777";
TestItem.FullName = "Bob Smith";
TestItem.Email = "*****@*****.**";
TestItem.CustomerID = 1;
TestItem.Date = DateTime.Now.Date;
TestItem.Address = "9 Hamilton Road LE5 J3D";
TestItem.OrderNo = 1;
TestList.Add(TestItem);
AllCustomers.CustomerList = TestList;
Assert.AreEqual(AllCustomers.Count, TestList.Count);
}
protected void btnSave_Click(object sender, EventArgs e)
{
clsCustomer obj = new clsCustomer();
obj.Name = txtName.Text;
obj.Address = txtAddress.Text;
obj.Phone = txtPhone.Text;
obj.Email = txtEmail.Text;
obj.Logo = UploadImage();
obj.Op = 1;
obj.CustomerMaster(obj);
msg.Text = "<script type='text/javascript'>alert('Saved');</script>";
LoadCustomer();
txtName.Text = "";
txtAddress.Text = "";
txtEmail.Text = "";
txtPhone.Text = "";
pnlExisting.Visible = true;
}
protected void btnOK_Click(object sender, EventArgs e)
{
//create a new instance of clsCustomer
clsCustomer ACustomer = new clsCustomer();
//capture the data
string Username = txtUsername.Text;
string Password = txtPassword.Text;
string Email = txtEmail.Text;
string DateCreated = txtDateCreated.Text;
string Error = "";
// validate the data
Error = ACustomer.Valid(Username, Password, Email, DateCreated);
if (Error == "")
{
//capture the data
ACustomer.CustomerId = CustomerId;
ACustomer.Username = Username;
ACustomer.Password = Password;
ACustomer.Email = Email;
ACustomer.DateCreated = Convert.ToDateTime(DateCreated);
ACustomer.Active = chkActiveAccount.Checked;
clsCustomerCollection Customers = new clsCustomerCollection();
if (CustomerId == -1)
{
Customers.ThisCustomer = ACustomer;
Customers.Add();
}
else
{
Customers.ThisCustomer.Find(CustomerId);
Customers.ThisCustomer = ACustomer;
Customers.Update();
}
Response.Redirect("CustomerList.aspx");
}
else
{
lblError.Text = Error;
}
}
public void EmailValidTests()
{
//examples of valid emails
clsCustomer newCustomer = new clsCustomer();
String[] validEmails = new string[3]
{
"*****@*****.**",
"*****@*****.**",
"*****@*****.**"
};
bool outcome = false;
foreach (String email in validEmails)
{
outcome |= !(newCustomer.ValidateEmail(email) == "");
}
Assert.AreEqual(outcome, false);
}
protected void Page_Load(object sender, EventArgs e)
{
clsCustomer newCustomer = new clsCustomer();
newCustomer = (clsCustomer)Session["newCustomer"];
//Response.Write(newCustomer.name);
if (newCustomer != null)
{
IDAppearBox.Text = Convert.ToString(newCustomer.CustomerID);
NameAppearBox.Text = newCustomer.name;
SurnameAppearBox.Text = newCustomer.surname;
MobileAppearBox.Text = Convert.ToString(newCustomer.PhoneNumber);
EmailAppearBox.Text = newCustomer.email;
AddressAppearBox.Text = newCustomer.Address;
DateAppearBox.Text = Convert.ToString(newCustomer.DOB);
toDeleteCheckBox.Checked = newCustomer.toDelete;
globalCustomer = newCustomer;
}
}
public void TestHouseNoFound()
{
clsCustomer Customer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 48;
Found = Customer.Find(CustomerNo);
if (Customer.HouseNo != 999)
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestEMailFound()
{
clsCustomer Customer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 48;
Found = Customer.Find(CustomerNo);
if (Customer.EMail != "*****@*****.**")
{
OK = false;
}
Assert.IsTrue(OK);
}
protected void grdCustomer_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
HiddenField hdID = (HiddenField)grdCustomer.Rows[e.RowIndex].FindControl("hdID");
Label lblName = (Label)grdCustomer.Rows[e.RowIndex].FindControl("lblName");
Label lblAddress = (Label)grdCustomer.Rows[e.RowIndex].FindControl("lblAddress");
Label lblPhone = (Label)grdCustomer.Rows[e.RowIndex].FindControl("lblPhone");
Label lblEmail = (Label)grdCustomer.Rows[e.RowIndex].FindControl("lblEmail");
HiddenField hdLogo = (HiddenField)grdCustomer.Rows[e.RowIndex].FindControl("hdLogo");
clsCustomer obj = new clsCustomer();
txtEName.Text = lblName.Text;
txtEAddress.Text = lblAddress.Text;
txtEPhone.Text = lblPhone.Text;
txtEEmail.Text = lblEmail.Text;
EImg.ImageUrl = hdLogo.Value;
hdEID.Value = hdID.Value;
pnlUpdate.Visible = true;
pnlExisting.Visible = false;
}
public void TestHouseStreetFound()
{
clsCustomer Customer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 48;
Found = Customer.Find(CustomerNo);
if (Customer.HouseStreet != "TESTDATA")
{
OK = false;
}
Assert.IsTrue(OK);
}
protected void btnFind_Click(object sender, EventArgs e)
{
clsCustomer ACustomer = new clsCustomer();
Int32 CustomerID;
Boolean Found = false;
CustomerID = Convert.ToInt32(txtCustomerID.text);
Found = ACustomer.Find(Customer);
if (Found == true)
{
txtCustomerID.text = ACustomer.CustomerID;
txtName.text = ACustomer.Name;
txtAddress = ACustomer.Address;
txtDatecreated = ACustomer.DateCreated;
txtRegistered = ACustomer.Registered;
txtBalance = ACustomer.Balance;
}
}
public void DateOfBirthMin()
{
//create an instance of the class we want to create
clsCustomer AnCustomer = new clsCustomer();
//string variable to store any error message
String Error = "";
//create a variable to store the test date data
DateTime TestDate;
//set the date to todays date
TestDate = DateTime.Now.Date;
//convert the date variable to a string variable
string DateOfBirth = TestDate.ToString();
//invoke the method
Error = AnCustomer.Valid(Username, Password, Address, DateOfBirth);
//test to see that the result is correct
Assert.AreEqual(Error, "");
}
public void AddMethodOK()
{
clsCustomerCollection AllCustomers = new clsCustomerCollection();
clsCustomer TestItem = new clsCustomer();
Int32 PrimaryKey = 0;
TestItem.AccountVerified = true;
TestItem.AccountNo = 1;
TestItem.Ballance = 1;
TestItem.CustomerName = "Gary";
TestItem.CustomerEmail = "*****@*****.**";
TestItem.DateAdded = DateTime.Now.Date;
TestItem.DateOfBirth = Convert.ToDateTime("01/01/2000");
AllCustomers.ThisCustomer = TestItem;
PrimaryKey = AllCustomers.Add();
TestItem.AccountNo = PrimaryKey;
Assert.AreEqual(AllCustomers.ThisCustomer, TestItem);
}
public void ThisCustomerPropertyOK()
{
//create list and check if you can access
clsCustomerCollection AllCustomers = new clsCustomerCollection();
//create test item
clsCustomer TestItem = new clsCustomer();
//create test properties
TestItem.cusId = 1000;
TestItem.cusName = "Rodney Dangerfield";
TestItem.cusEmail = "*****@*****.**";
TestItem.cusPassword = "******";
TestItem.cusAccountStatus = true;
TestItem.cusDateRegister = DateTime.Now.Date;
//set allCustomers.thisCustomer as the customer I just created
AllCustomers.ThisCustomer = TestItem;
//compare
Assert.AreEqual(AllCustomers.ThisCustomer, TestItem);
}
public void DateOfBirthMin()
{
//create an instance of the class we want to create
clsCustomer ACustomer = new clsCustomer();
//string variable to store any error message
String Error = "";
//create a variable to store the test date data
DateTime TestDate;
//set the date to today's date
TestDate = DateTime.Now.Date.AddYears(-13);
//convert the date variable to a string variable
string DateOfBirth = TestDate.ToString();
//invoke the method
Error = ACustomer.Valid(Email, Password, FirstName, SurName, DateOfBirth, PhoneNumber, Address, Gender);
//test to see that the result is correct
Assert.AreEqual(Error, "");
}
public void ThisCustomerPropertyOK()
{
//create an instance of the class we want to create
clsCustomerCollection AllCustomers = new clsCustomerCollection();
//create some test data to assign to the property
clsCustomer TestCustomer = new clsCustomer();
//set the properties of the test object
TestCustomer.CustomerFirstName = "some first name";
TestCustomer.CustomerLastName = "some last name";
TestCustomer.Email = "*****@*****.**";
TestCustomer.Address1 = "some address1";
TestCustomer.Address2 = "some address2";
TestCustomer.PostCode = "LE1 1WE";
//assign the data to the property
AllCustomers.ThisCustomer = TestCustomer;
//test to seee that the two values are the same
Assert.AreEqual(AllCustomers.ThisCustomer, TestCustomer);
}
public void ThisCustomerPropertyOK()
{
//create an instanceof the clas we watn to create
clsCustomerCollection AllCustomers = new clsCustomerCollection();
//create some test data to asign ot the property
clsCustomer TestCustomer = new clsCustomer();
//set its properties
TestCustomer.Active = true;
TestCustomer.CustomerID = 1;
TestCustomer.CustomerFirstName = "First";
TestCustomer.CustomerLastName = "Last";
TestCustomer.CustomerEmail = "*****@*****.**";
TestCustomer.CustomerTeleNo = "XXXXXXXXXX";
//asign the data to the property
AllCustomers.ThisCustomer = TestCustomer;
//test to see that the teo valies are the same
Assert.AreEqual(AllCustomers.ThisCustomer, TestCustomer);
}
public void TestPostCodeFound()
{
clsCustomer Customer = new clsCustomer();
Boolean Found = false;
Boolean OK = true;
Int32 CustomerNo = 48;
Found = Customer.Find(CustomerNo);
if (Customer.PostCode != "TEST1")
{
OK = false;
}
Assert.IsTrue(OK);
}
protected void Page_Load(object sender, EventArgs e)
{
if (security.LoginChecker() == true)
{
clsCustomer customer = new clsCustomer();
DataTable dt = new DataTable();
dt = customer.SearchCustomerByUsername(security.LoginUsername);
if (dt.Rows.Count > 0 && dt != null)
{
txtName.Text = dt.Rows[0]["Forename"].ToString();
txtSurname.Text = dt.Rows[0]["Surname"].ToString();
if (dt.Rows[0]["SEX"].ToString() == "M")
{
rdbMale.Checked = true;
}
else
{
rdbFemale.Checked = true;
}
if (!string.IsNullOrEmpty(dt.Rows[0]["IDCard"].ToString()))
{
txtIDCardNo.Text = dt.Rows[0]["IDCard"].ToString();
}
txtAddress.Text = dt.Rows[0]["Address"].ToString();
txtDistrict.Text = dt.Rows[0]["District"].ToString();
txtPrefecture.Text = dt.Rows[0]["Prefecture"].ToString();
txtProvince.Text = dt.Rows[0]["Province"].ToString();
txtZipcode.Text = dt.Rows[0]["Zipcode"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
txtTel.Text = dt.Rows[0]["Tel"].ToString();
txtDetail.Text = dt.Rows[0]["Detail"].ToString();
}
}
BindSelectedPackage();
BindContent();
}
/// <summary>
/// Added By : Himanshu Pandya
/// Date : 30-12-2012
/// Desc : Fill Customer Details from Cearch Search Popup
/// </summary>
public void BindCustomerDetails(Int64 CustomerId)
{
DataTable dtCustomer;
try
{
if (CustomerId > 0)
{
ObjCust = new clsCustomer();
dtCustomer = new DataTable();
ObjCust.CustomerId = CustomerId;
dtCustomer = ObjCust.General_SearcheAllCustomerWSearchFilters();
if (dtCustomer.Rows.Count > 0)
{
//Fill Customer Details
hdnCustomerId.Value = Convert.ToString(CustomerId);
txtCustomerNo.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["CustomerCode"].ToString()) ? dtCustomer.Rows[0]["CustomerCode"].ToString() : string.Empty;
ddlCustomerPrefix.SelectedIndex = ddlCustomerPrefix.Items.IndexOf(ddlCustomerPrefix.Items.FindByText(dtCustomer.Rows[0]["NamePrifix"].ToString()));
txtFirstName.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["FirstName"].ToString()) ? dtCustomer.Rows[0]["FirstName"].ToString() : string.Empty;
txtMiddleName.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["MiddleName"].ToString()) ? dtCustomer.Rows[0]["MiddleName"].ToString() : string.Empty;
txtLastName.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["LastName"].ToString()) ? dtCustomer.Rows[0]["LastName"].ToString() : string.Empty;
txtCustomerServiceYear.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["EmploymentYear"].ToString()) ? dtCustomer.Rows[0]["EmploymentYear"].ToString() : string.Empty;
txtCusotmerRetirementDate.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["RetirementYear"].ToString()) ? dtCustomer.Rows[0]["RetirementYear"].ToString() : string.Empty;
txtCustomerSalary.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["Salary"].ToString()) ? CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtCustomer.Rows[0]["Salary"])) : string.Empty;
hdnBindLoanData.Value = string.Empty;
}
}
}
catch
{ }
finally
{
ObjCust = new clsCustomer();
dtCustomer = new DataTable();
}
}
/// <summary>
/// Added By : Himanshu Pandya
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvCustomer_RowEditing(object sender, GridViewEditEventArgs e)
{
ObjCustomer = new clsCustomer();
dtCustomer = new DataTable();
int iCustomerId;
try
{
iCustomerId = Convert.ToInt32(((Label)gvCustomer.Rows[e.NewEditIndex].FindControl("lblCustomerId")).Text);
if (iCustomerId > 0)
{
ObjCustomer.CustomerCode = string.Empty;
ObjCustomer.FirstName = string.Empty;
ObjCustomer.DistrictName = string.Empty;
ObjCustomer.CustomerId = iCustomerId;
dtCustomer = ObjCustomer.SearcheAllCustomerWSearchFilters();
if (dtCustomer.Rows.Count > 0)
{
//Fill Cusotmer Details
hdnCusotmerId.Value = dtCustomer.Rows[0]["CustomerId"].ToString();
//ddlCustomerCodePrefix.SelectedIndex = ddlCustomerCodePrefix.Items.IndexOf(ddlCustomerCodePrefix.Items.FindByValue(dtCustomer.Rows[0]["CustomerCode"].ToString().Substring(0, 3)));
//txtCustomerNo.Text = dtCustomer.Rows[0]["CustomerCode"].ToString().Substring(4, (Convert.ToInt32(dtCustomer.Rows[0]["CustomerCode"].ToString().Length) - 4));
txtCustomerNo.Text = dtCustomer.Rows[0]["CustomerCode"].ToString();
ddlCustomerType.SelectedIndex = ddlCustomerType.Items.IndexOf(ddlCustomerType.Items.FindByValue(dtCustomer.Rows[0]["CustomerTypeId"].ToString().Trim()));
if (ddlCustomerType.SelectedValue.ToString().Equals(clsEnum.CustomerType.Sadharan.GetHashCode().ToString()))
{
ShowHideCustomerTypeFields(true);
}
else if (ddlCustomerType.SelectedValue.ToString().Equals(clsEnum.CustomerType.NaamMatra.GetHashCode().ToString()))
{
ShowHideCustomerTypeFields(false);
}
else
{
ShowHideCustomerTypeFields(true);
}
ddlCustomernamePrefix.SelectedIndex = ddlCustomernamePrefix.Items.IndexOf(ddlCustomernamePrefix.Items.FindByValue(dtCustomer.Rows[0]["NamePrifix"].ToString().Trim()));
ddlBankBranches.SelectedIndex = ddlBankBranches.Items.IndexOf(ddlBankBranches.Items.FindByValue(dtCustomer.Rows[0]["BankBranchId"].ToString().Trim()));
txtCusotmerFirstname.Text = dtCustomer.Rows[0]["FirstName"].ToString().Trim();
txtCustomerMiddlename.Text = dtCustomer.Rows[0]["MiddleName"].ToString().Trim();
txtCustomerLastname.Text = dtCustomer.Rows[0]["LastName"].ToString().Trim();
txtCusotomerAddress.Text = dtCustomer.Rows[0]["Address1"].ToString().Trim();
ddlCustomerVillage.Text = dtCustomer.Rows[0]["VillageId"].ToString().Trim();
//ddlCustomerVillage.SelectedIndex = ddlCustomerVillage.Items.IndexOf(ddlCustomerVillage.Items.FindByValue(dtCustomer.Rows[0]["VillageId"].ToString().Trim()));
ddlCustomerTaluka.SelectedIndex = ddlCustomerTaluka.Items.IndexOf(ddlCustomerTaluka.Items.FindByValue(dtCustomer.Rows[0]["TahsilId"].ToString().Trim()));
ddlCustomerDistrict.SelectedIndex = ddlCustomerDistrict.Items.IndexOf(ddlCustomerDistrict.Items.FindByValue(dtCustomer.Rows[0]["DistrictId"].ToString().Trim()));
txtCustomerPinCode.Text = dtCustomer.Rows[0]["Pincode"].ToString().Trim();
txtCustomerPhoneNumber.Text = dtCustomer.Rows[0]["PhoneNumber"].ToString().Trim();
txtCustomerDOB.Text = dtCustomer.Rows[0]["DateOfBirth"].ToString();
txtCustomerEmail.Text = dtCustomer.Rows[0]["Email"].ToString();
txtCustomerSchoolname.Text = dtCustomer.Rows[0]["SchoolName"].ToString();
ddlCustomerSchoolTaluka.SelectedIndex = ddlCustomerSchoolTaluka.Items.IndexOf(ddlCustomerSchoolTaluka.Items.FindByValue(dtCustomer.Rows[0]["SchoolTahsilId"].ToString()));
ddlCusotmerSchoolDistrict.SelectedIndex = ddlCusotmerSchoolDistrict.Items.IndexOf(ddlCusotmerSchoolDistrict.Items.FindByValue(dtCustomer.Rows[0]["SchoolDistrictId"].ToString()));
txtCustomerSchoolPinCode.Text = dtCustomer.Rows[0]["SchoolPinCode"].ToString().Trim();
txtCustomerPanCard.Text = dtCustomer.Rows[0]["CustomerPanCard"].ToString().Trim();
//txtCustTotalYearOfService.Text = dtCustomer.Rows[0]["TotalYearOfService"].ToString().Trim();
txtCustEmploymentYear.Text = dtCustomer.Rows[0]["EmploymentYear"].ToString().Trim();
//txtCustomerYear.Text = dtCustomer.Rows[0]["CustomerYear"].ToString().Trim();
if (!string.IsNullOrEmpty(dtCustomer.Rows[0]["Salary"].ToString()))
{
txtCustomerSalary.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtCustomer.Rows[0]["Salary"]));
}
txtCustRetirementDate.Text = dtCustomer.Rows[0]["RetirementYear"].ToString().Trim();
//Fill Nominee Details
hdnNomineeId.Value = dtCustomer.Rows[0]["NomineeId"].ToString().Trim();
ddlCustNomineePrefix.SelectedIndex = ddlCustNomineePrefix.Items.IndexOf(ddlCustNomineePrefix.Items.FindByValue(dtCustomer.Rows[0]["NomineeNamePrefix"].ToString().Trim()));
txtCustnomineeFirstname.Text = dtCustomer.Rows[0]["NomineeFirstName"].ToString().Trim();
txtCustnomineeMiddlename.Text = dtCustomer.Rows[0]["NomineeMiddleName"].ToString().Trim();
txtCustnomineeLastname.Text = dtCustomer.Rows[0]["NomineeLastName"].ToString().Trim();
txtCustNomineeAddress.Text = dtCustomer.Rows[0]["NomineeAddress"].ToString().Trim();
ddlCustNomineeVillage.Text =dtCustomer.Rows[0]["NomineeVillageId"].ToString().Trim();
ddlCustNomineeTaluka.SelectedIndex = ddlCustNomineeTaluka.Items.IndexOf(ddlCustNomineeTaluka.Items.FindByValue(dtCustomer.Rows[0]["NomineeTahsilId"].ToString().Trim()));
ddlCustNomineeDistrict.SelectedIndex = ddlCustNomineeDistrict.Items.IndexOf(ddlCustNomineeDistrict.Items.FindByValue(dtCustomer.Rows[0]["NomineeDistrictId"].ToString().Trim()));
txtCustNomineePinCode.Text = dtCustomer.Rows[0]["NomineePinCode"].ToString().Trim();
txtCustNomineePhonenumber.Text = dtCustomer.Rows[0]["NomineePhoneNumber"].ToString().Trim();
txtCustNomineeOccupation.Text = dtCustomer.Rows[0]["NomineeOccupation"].ToString().Trim();
txtCustRelationWithNominee.Text = dtCustomer.Rows[0]["NomineeRelationWith"].ToString().Trim();
hdnAccountId.Value = dtCustomer.Rows[0]["AccountId"].ToString().Trim();
txtCustomerAccNumber.Text = dtCustomer.Rows[0]["AccountNumber"].ToString().Trim();
txtCustomerAccOpenDate.Text = dtCustomer.Rows[0]["OpeningDate"].ToString().Trim();
txtCustomerOpeningBalance.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtCustomer.Rows[0]["OpeningBalance"]));
txtCustomerShareAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtCustomer.Rows[0]["ShareBalance"]));
//ddlCustomerAccType.SelectedIndex = ddlCustomerAccType.Items.IndexOf(ddlCustomerAccType.Items.FindByValue(dtCustomer.Rows[0]["AccountTypeId"].ToString().Trim()));
//txtCustomerKayamnidhiBal.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtCustomer.Rows[0]["KayamNidhiBalance"]));
//txtCustomerAccountBal.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtCustomer.Rows[0]["AccountBalance"]));
/*teprary validation false
*
* txtCustomerAccNumber.Enabled = false;
txtCustomerAccOpenDate.Enabled = false;
txtCustomerOpeningBalance.Enabled = false;
txtCustomerShareAmt.Enabled = false;
ddlCustomerType.Enabled = false;
*/
ShowHideCusotmerGrid(false);
}
}
}
catch (Exception) { }
finally { ObjCustomer = null; dtCustomer = null; }
ShowHideCusotmerGrid(false);
}
/// <summary>
/// Added By : Himanshu Pandya
/// Date : 30-12-2012
/// Desc : Fill Customer Details from Cearch Search Popup
/// </summary>
public void BindWitnessDetails(Int64 CustomerId, string WitnessId)
{
DataTable dtCustomer;
try
{
if ((CustomerId > 1) && (!string.IsNullOrEmpty(WitnessId)))
{
ObjCust = new clsCustomer();
dtCustomer = new DataTable();
ObjCust.CustomerId = CustomerId;
dtCustomer = ObjCust.SearcheAllCustomerWSearchFilters();
if (dtCustomer.Rows.Count > 0)
{
//Fill Customer Details
switch (WitnessId)
{
case "1":
hdnWitnessID1.Value = Convert.ToString(CustomerId);
txtCustWitnessNo1.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["CustomerCode"].ToString()) ? dtCustomer.Rows[0]["CustomerCode"].ToString() : string.Empty;
ddlCustWitnessPrefix1.SelectedIndex = ddlCustWitnessPrefix1.Items.IndexOf(ddlCustWitnessPrefix1.Items.FindByText(dtCustomer.Rows[0]["NamePrifix"].ToString()));
txtCustWitnessFirstName1.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["FirstName"].ToString()) ? dtCustomer.Rows[0]["FirstName"].ToString() : string.Empty;
txtCustWitnessMiddleName1.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["MiddleName"].ToString()) ? dtCustomer.Rows[0]["MiddleName"].ToString() : string.Empty;
txtCustWitnessLastName1.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["LastName"].ToString()) ? dtCustomer.Rows[0]["LastName"].ToString() : string.Empty;
txtCustWitnessSchool1.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["SchoolName"].ToString()) ? dtCustomer.Rows[0]["SchoolName"].ToString() : string.Empty;
ddlCustWitnessTaluka1.SelectedIndex = ddlCustWitnessTaluka1.Items.IndexOf(ddlCustWitnessTaluka1.Items.FindByValue(dtCustomer.Rows[0]["TahsilId"].ToString()));
break;
case "2":
hdnWitnessID2.Value = Convert.ToString(CustomerId);
txtCustWitnessNo2.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["CustomerCode"].ToString()) ? dtCustomer.Rows[0]["CustomerCode"].ToString() : string.Empty;
ddlCustWitnessPrefix2.SelectedIndex = ddlCustWitnessPrefix2.Items.IndexOf(ddlCustWitnessPrefix2.Items.FindByText(dtCustomer.Rows[0]["NamePrifix"].ToString()));
txtCustWitnessFirstName2.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["FirstName"].ToString()) ? dtCustomer.Rows[0]["FirstName"].ToString() : string.Empty;
txtCustWitnessMiddleName2.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["MiddleName"].ToString()) ? dtCustomer.Rows[0]["MiddleName"].ToString() : string.Empty;
txtCustWitnessLastName2.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["LastName"].ToString()) ? dtCustomer.Rows[0]["LastName"].ToString() : string.Empty;
txtCustWitnessSchool2.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["SchoolName"].ToString()) ? dtCustomer.Rows[0]["SchoolName"].ToString() : string.Empty;
ddlCustWitnessTaluka2.SelectedIndex = ddlCustWitnessTaluka2.Items.IndexOf(ddlCustWitnessTaluka2.Items.FindByValue(dtCustomer.Rows[0]["TahsilId"].ToString()));
break;
case "3":
hdnWitnessID3.Value = Convert.ToString(CustomerId);
txtCustWitnessNo3.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["CustomerCode"].ToString()) ? dtCustomer.Rows[0]["CustomerCode"].ToString() : string.Empty;
ddlCustWitnessPrefix3.SelectedIndex = ddlCustWitnessPrefix3.Items.IndexOf(ddlCustWitnessPrefix3.Items.FindByText(dtCustomer.Rows[0]["NamePrifix"].ToString()));
txtCustWitnessFirstName3.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["FirstName"].ToString()) ? dtCustomer.Rows[0]["FirstName"].ToString() : string.Empty;
txtCustWitnessMiddleName3.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["MiddleName"].ToString()) ? dtCustomer.Rows[0]["MiddleName"].ToString() : string.Empty;
txtCustWitnessLastName3.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["LastName"].ToString()) ? dtCustomer.Rows[0]["LastName"].ToString() : string.Empty;
txtCustWitnessSchool3.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["SchoolName"].ToString()) ? dtCustomer.Rows[0]["SchoolName"].ToString() : string.Empty;
ddlCustWitnessTaluka3.SelectedIndex = ddlCustWitnessTaluka3.Items.IndexOf(ddlCustWitnessTaluka3.Items.FindByValue(dtCustomer.Rows[0]["TahsilId"].ToString()));
break;
case "4":
hdnWitnessID4.Value = Convert.ToString(CustomerId);
txtCustWitnessNo4.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["CustomerCode"].ToString()) ? dtCustomer.Rows[0]["CustomerCode"].ToString() : string.Empty;
ddlCustWitnessPrefix4.SelectedIndex = ddlCustWitnessPrefix4.Items.IndexOf(ddlCustWitnessPrefix4.Items.FindByText(dtCustomer.Rows[0]["NamePrifix"].ToString()));
txtCustWitnessFirstName4.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["FirstName"].ToString()) ? dtCustomer.Rows[0]["FirstName"].ToString() : string.Empty;
txtCustWitnessMiddleName4.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["MiddleName"].ToString()) ? dtCustomer.Rows[0]["MiddleName"].ToString() : string.Empty;
txtCustWitnessLastName4.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["LastName"].ToString()) ? dtCustomer.Rows[0]["LastName"].ToString() : string.Empty;
txtCustWitnessSchool4.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["SchoolName"].ToString()) ? dtCustomer.Rows[0]["SchoolName"].ToString() : string.Empty;
ddlCustWitnessTaluka4.SelectedIndex = ddlCustWitnessTaluka4.Items.IndexOf(ddlCustWitnessTaluka4.Items.FindByValue(dtCustomer.Rows[0]["TahsilId"].ToString()));
break;
}
hdnBindLoanData.Value = string.Empty;
}
}
}
catch { }
finally
{
ObjCust = new clsCustomer();
dtCustomer = new DataTable();
}
}
/// <summary>
/// Added By : pradip pawar
/// Date : 25-03-2013
/// Desc : Fill Customer Details from Search Popup
/// </summary>
private void BindCustomerDetails()
{
objCustomer = new clsCustomer();
dtCustomer = new DataTable();
try
{
if (!string.IsNullOrEmpty(hdnCustomerId.Value))
{
objCustomer.CustomerId = Convert.ToInt64(hdnCustomerId.Value);
dtCustomer = objCustomer.GetCustomerDetailsByCustomerID();
if (dtCustomer.Rows.Count > 0)
{
//Fill Customer Details
ClearControl();
txtCustomerNo.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["CustomerCode"].ToString()) ? dtCustomer.Rows[0]["CustomerCode"].ToString() : string.Empty;
lblCustomerName.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["FULLNAME"].ToString()) ? dtCustomer.Rows[0]["FirstName"].ToString() : string.Empty;
lblCustomerType.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["CustomerTypeName"].ToString()) ? dtCustomer.Rows[0]["CustomerTypeName"].ToString() : string.Empty;
lblbShareBalance.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["ShareBalance"].ToString()) ? Convert.ToDouble(dtCustomer.Rows[0]["ShareBalance"]).ToString("N2") : string.Empty;
lblKayamNidhiBalance.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["KayamNidhiBalance"].ToString()) ?Convert.ToDouble( dtCustomer.Rows[0]["KayamNidhiBalance"]).ToString("N2") : string.Empty;
lblAccountBalance.Text = !string.IsNullOrEmpty(dtCustomer.Rows[0]["AccountBalance"].ToString()) ?Convert.ToDouble(dtCustomer.Rows[0]["AccountBalance"]).ToString("N2") : string.Empty;
}
}
}
catch (Exception ex)
{ }
finally
{
objCustomer = new clsCustomer();
dtCustomer = new DataTable();
}
}
/// <summary>
/// //Added By : Pradip pawar
/// Date:30-3-13
/// Description: Bind Loan Type On Condition created date of customer
///
/// Sadhe Karj:From 6 month
/// prasangik:2 months
/// vishesh:4 months
/// aakasmik:1 month
///
/// </summary>
public void BindLoanType(Int64 CustomerId)
{
DataTable dtLoanType;
try
{
if (CustomerId > 0)
{
ObjCust = new clsCustomer();
dtLoanType = new DataTable();
ObjCust.CustomerId = CustomerId;
dtLoanType = ObjCust.General_BindLoanTypeByCustomerId();
ddlLoanType.Items.Clear();
if (dtLoanType.Rows.Count > 0)
{
ddlLoanType.Items.Clear();
ddlLoanType.DataSource = null;
ddlLoanType.DataSource = dtLoanType;
ddlLoanType.DataTextField = "LoanTypeName";
ddlLoanType.DataValueField = "LoanTypeID";
ddlLoanType.DataBind();
ddlLoanType.Items.Insert(0, new ListItem("fuoMk", string.Empty));
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('"+(String)GetGlobalResourceObject("SharedResource", "NewCustomerLoanNotAllowed")+"')", true);
lblMessage.CssClass = "FailureMessage";
lblMessage.Text = (String)GetGlobalResourceObject("SharedResource", "NewCustomerLoanNotAllowed");
}
}
}
catch
{ }
finally
{
ObjCust = new clsCustomer();
dtLoanType = new DataTable();
}
}
/// <summary>
/// Added By : Himanshu Pandya
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSaveCustomer_Click(object sender, EventArgs e)
{
ObjCustomer = new clsCustomer();
ObjNominee = new clsNominees();
ObjAccounts = new clsAccounts();
try
{
if (!string.IsNullOrEmpty(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())))
{
//Customer Detials
ObjCustomer.CustomerId = !string.IsNullOrEmpty(hdnCusotmerId.Value) ? Convert.ToInt32(hdnCusotmerId.Value.ToString()) : 0;
//ObjCustomer.CustomerCode = (!string.IsNullOrEmpty(ddlCustomerCodePrefix.SelectedValue) ? ddlCustomerCodePrefix.SelectedValue.ToString() : string.Empty) + "-" + (!string.IsNullOrEmpty(txtCustomerNo.Text) ? txtCustomerNo.Text : string.Empty);
ObjCustomer.CustomerCode = !string.IsNullOrEmpty(txtCustomerNo.Text) ? txtCustomerNo.Text : string.Empty;
ObjCustomer.CustomerTypeId = !string.IsNullOrEmpty(ddlCustomerType.SelectedValue) ? Convert.ToInt32(ddlCustomerType.SelectedValue.ToString()) : 0;
ObjCustomer.BankBranchId = !string.IsNullOrEmpty(ddlBankBranches.SelectedValue) ? Convert.ToInt32(ddlBankBranches.SelectedValue.ToString()) : 0;
ObjCustomer.NamePrifix = !string.IsNullOrEmpty(ddlCustomernamePrefix.SelectedValue) ? ddlCustomernamePrefix.SelectedValue.ToString() : string.Empty;
ObjCustomer.FirstName = !string.IsNullOrEmpty(txtCusotmerFirstname.Text) ? txtCusotmerFirstname.Text : string.Empty;
ObjCustomer.MiddleName = !string.IsNullOrEmpty(txtCustomerMiddlename.Text) ? txtCustomerMiddlename.Text : string.Empty;
ObjCustomer.LastName = !string.IsNullOrEmpty(txtCustomerLastname.Text) ? txtCustomerLastname.Text : string.Empty;
ObjCustomer.Address1 = !string.IsNullOrEmpty(txtCusotomerAddress.Text) ? txtCusotomerAddress.Text : string.Empty;
ObjCustomer.VillageId = !string.IsNullOrEmpty(ddlCustomerVillage.Text) ? ddlCustomerVillage.Text : string.Empty;
//ObjCustomer.VillageId = !string.IsNullOrEmpty(ddlCustomerVillage.SelectedValue) ? Convert.ToInt32(ddlCustomerVillage.SelectedValue.ToString()) : 0;
ObjCustomer.TahsilId = !string.IsNullOrEmpty(ddlCustomerTaluka.SelectedValue) ? Convert.ToInt32(ddlCustomerTaluka.SelectedValue.ToString()) : 0;
ObjCustomer.DistrictId = !string.IsNullOrEmpty(ddlCustomerDistrict.SelectedValue) ? Convert.ToInt32(ddlCustomerDistrict.SelectedValue.ToString()) : 0;
ObjCustomer.Pincode = !string.IsNullOrEmpty(txtCustomerPinCode.Text) ? txtCustomerPinCode.Text.ToString() : string.Empty;
ObjCustomer.PhoneNumber = !string.IsNullOrEmpty(txtCustomerPhoneNumber.Text) ? txtCustomerPhoneNumber.Text.ToString() : "";
ObjCustomer.DateOfBirth = !string.IsNullOrEmpty(txtCustomerDOB.Text) ? txtCustomerDOB.Text.ToString() : string.Empty;
ObjCustomer.Email = !string.IsNullOrEmpty(txtCustomerEmail.Text) ? txtCustomerEmail.Text.ToString() : string.Empty;
ObjCustomer.SchoolName = !string.IsNullOrEmpty(txtCustomerSchoolname.Text) ? txtCustomerSchoolname.Text.ToString() : string.Empty;
ObjCustomer.SchoolTahsilId = !string.IsNullOrEmpty(ddlCustomerSchoolTaluka.SelectedValue) ? Convert.ToInt32(ddlCustomerSchoolTaluka.SelectedValue.ToString()) : 0;
ObjCustomer.SchoolDistrictId = !string.IsNullOrEmpty(ddlCusotmerSchoolDistrict.SelectedValue) ? Convert.ToInt32(ddlCusotmerSchoolDistrict.SelectedValue.ToString()) : 0;
ObjCustomer.SchoolPinCode = !string.IsNullOrEmpty(txtCustomerSchoolPinCode.Text) ? txtCustomerSchoolPinCode.Text.ToString() : string.Empty;
ObjCustomer.CustomerPanCard = !string.IsNullOrEmpty(txtCustomerPanCard.Text) ? txtCustomerPanCard.Text.ToString() : string.Empty;
//ObjCustomer.TotalYearOfService = !string.IsNullOrEmpty(txtCustTotalYearOfService.Text) ? txtCustTotalYearOfService.Text.ToString() : string.Empty;
ObjCustomer.EmploymentYear = !string.IsNullOrEmpty(txtCustEmploymentYear.Text) ? txtCustEmploymentYear.Text.ToString() : string.Empty;
//ObjCustomer.CustomerYear = !string.IsNullOrEmpty(txtCustomerYear.Text) ? txtCustomerYear.Text.ToString() : string.Empty;
ObjCustomer.Salary = !string.IsNullOrEmpty(txtCustomerSalary.Text) ? Convert.ToDecimal(txtCustomerSalary.Text.ToString()) : 0;
ObjCustomer.RetirementYear = !string.IsNullOrEmpty(txtCustRetirementDate.Text) ? txtCustRetirementDate.Text.ToString() : string.Empty;
ObjCustomer.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
ObjCustomer.CreatedDate = Convert.ToDateTime(txtCustomerAccOpenDate.Text);
ObjCustomer.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
ObjCustomer.UpdatedDate = Convert.ToDateTime(txtCustomerAccOpenDate.Text);
ObjCustomer.IsActive = true;
if (ObjCustomer.Insert())
{
//Customer Nominee Details
ObjNominee.NomineeId = !string.IsNullOrEmpty(hdnNomineeId.Value) ? Convert.ToInt32(hdnNomineeId.Value.ToString()) : 0;
ObjNominee.NomineeReferenceId = ObjCustomer.CustomerId > 0 ? ObjCustomer.CustomerId : 0;
ObjNominee.NomineeTypeId = Convert.ToInt32(clsEnum.NomineeType.Customer.GetHashCode().ToString());
ObjNominee.NamePrefix = !string.IsNullOrEmpty(ddlCustNomineePrefix.SelectedValue) ? ddlCustNomineePrefix.SelectedValue.ToString() : string.Empty;
ObjNominee.FirstName = !string.IsNullOrEmpty(txtCustnomineeFirstname.Text) ? txtCustnomineeFirstname.Text.ToString() : string.Empty;
ObjNominee.MiddleName = !string.IsNullOrEmpty(txtCustnomineeMiddlename.Text) ? txtCustnomineeMiddlename.Text.ToString() : string.Empty;
ObjNominee.LastName = !string.IsNullOrEmpty(txtCustnomineeLastname.Text) ? txtCustnomineeLastname.Text.ToString() : string.Empty;
ObjNominee.Address = !string.IsNullOrEmpty(txtCustNomineeAddress.Text) ? txtCustNomineeAddress.Text.ToString() : string.Empty;
ObjNominee.RelationWith = !string.IsNullOrEmpty(txtCustRelationWithNominee.Text) ? txtCustRelationWithNominee.Text.ToString() : string.Empty;
ObjNominee.VillageId = !string.IsNullOrEmpty(ddlCustNomineeVillage.Text) ? ddlCustNomineeVillage.Text.ToString() : string.Empty;
ObjNominee.TahsilId = !string.IsNullOrEmpty(ddlCustNomineeTaluka.SelectedValue) ? Convert.ToInt32(ddlCustNomineeTaluka.SelectedValue.ToString()) : 0;
ObjNominee.DistrictId = !string.IsNullOrEmpty(ddlCustNomineeDistrict.SelectedValue) ? Convert.ToInt32(ddlCustNomineeDistrict.SelectedValue.ToString()) : 0;
ObjNominee.PinCode = !string.IsNullOrEmpty(txtCustNomineePinCode.Text) ? txtCustNomineePinCode.Text.ToString() : string.Empty;
ObjNominee.PhoneNumber = !string.IsNullOrEmpty(txtCustNomineePhonenumber.Text) ? txtCustNomineePhonenumber.Text.ToString() : string.Empty;
ObjNominee.Occupation = !string.IsNullOrEmpty(txtCustNomineeOccupation.Text) ? txtCustNomineeOccupation.Text.ToString() : string.Empty;
ObjNominee.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
ObjNominee.CreatedDate = Convert.ToDateTime(txtCustomerAccOpenDate.Text);
ObjNominee.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
ObjNominee.UpdatedDate = Convert.ToDateTime(txtCustomerAccOpenDate.Text);
ObjNominee.IsActive = true;
ObjNominee.Insert();
if (!ddlCustomerType.SelectedValue.ToString().Equals(clsEnum.CustomerType.NaamMatra.GetHashCode().ToString()))
{
//Account Details
ObjAccounts.AccountId = !string.IsNullOrEmpty(hdnAccountId.Value) ? Convert.ToInt32(hdnAccountId.Value.ToString()) : 0;
ObjAccounts.AccountNumber = !string.IsNullOrEmpty(txtCustomerAccNumber.Text) ? txtCustomerAccNumber.Text.ToString() : string.Empty;
ObjAccounts.CustomerId = ObjCustomer.CustomerId > 0 ? ObjCustomer.CustomerId : 0;
ObjAccounts.OpeningDate = !string.IsNullOrEmpty(txtCustomerAccOpenDate.Text) ? txtCustomerAccOpenDate.Text.ToString() : string.Empty;
//ObjAccounts.AccountTypeId = !string.IsNullOrEmpty(ddlCustomerAccType.SelectedValue) ? Convert.ToInt32(ddlCustomerAccType.SelectedValue.ToString()) : 0;
ObjAccounts.AccountTypeId = Convert.ToInt32(clsEnum.AccountTypes.SavingAccount.GetHashCode().ToString());
ObjAccounts.OpeningBalance = !string.IsNullOrEmpty(txtCustomerOpeningBalance.Text) ? Convert.ToDecimal(txtCustomerOpeningBalance.Text.ToString()) : 0;
ObjAccounts.ShareBalance = !string.IsNullOrEmpty(txtCustomerShareAmt.Text) ? Convert.ToDecimal(txtCustomerShareAmt.Text.ToString()) : 0;
//ObjAccounts.KayamNidhiBalance = !string.IsNullOrEmpty(txtCustomerKayamnidhiBal.Text) ? Convert.ToDecimal(txtCustomerKayamnidhiBal.Text.ToString()) : 0;
//ObjAccounts.AccountBalance = !string.IsNullOrEmpty(txtCustomerAccountBal.Text) ? Convert.ToDecimal(txtCustomerAccountBal.Text.ToString()) : 0;
ObjAccounts.KayamNidhiBalance = 0;
ObjAccounts.AccountBalance = !string.IsNullOrEmpty(txtCustomerOpeningBalance.Text) ? Convert.ToDecimal(txtCustomerOpeningBalance.Text.ToString()) : 0;
ObjAccounts.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
ObjAccounts.CreatedDate = Convert.ToDateTime(txtCustomerAccOpenDate.Text);
ObjAccounts.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
ObjAccounts.UpdatedDate = Convert.ToDateTime(txtCustomerAccOpenDate.Text);
ObjAccounts.IsActive = true;
ObjAccounts.Insert();
}
else
{
//Account Details
ObjAccounts.AccountId = !string.IsNullOrEmpty(hdnAccountId.Value) ? Convert.ToInt32(hdnAccountId.Value.ToString()) : 0;
ObjAccounts.AccountNumber = string.Empty;
ObjAccounts.CustomerId = ObjCustomer.CustomerId > 0 ? ObjCustomer.CustomerId : 0;
ObjAccounts.OpeningDate = txtCustomerAccOpenDate.Text;
ObjAccounts.AccountTypeId = Convert.ToInt32(clsEnum.AccountTypes.SavingAccount.GetHashCode().ToString());
ObjAccounts.OpeningBalance = 0;
ObjAccounts.ShareBalance = 0;
ObjAccounts.KayamNidhiBalance = 0;
ObjAccounts.AccountBalance = 0;
ObjAccounts.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
ObjAccounts.CreatedDate = Convert.ToDateTime(txtCustomerAccOpenDate.Text);
ObjAccounts.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()));
ObjAccounts.UpdatedDate = Convert.ToDateTime(txtCustomerAccOpenDate.Text);
ObjAccounts.IsActive = true;
ObjAccounts.Insert();
}
lblMessage.CssClass = "SuccessfulMessage";
lblMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavedSuccessfully");
}
}
else
{
lblMessage.CssClass = "FailureMessage";
lblMessage.Text = (String)GetGlobalResourceObject("SharedResource", "LoginSessionExpire");
}
BindCustomerGrid();
}
catch
{
lblMessage.CssClass = "FailureMessage";
lblMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavingFailure");
}
finally
{
ObjCustomer = null;
ObjNominee = null;
ObjAccounts = null;
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvCustomerLoan_RowEditing(object sender, GridViewEditEventArgs e)
{
ObjLoan = new clsLoan();
dtLoan = new DataTable();
clsComFun = new CommonFunctions();
int iLoanId;
string strValue = string.Empty;
int intMonth = 0, intYear = 0;
try
{
//BindLoanTypes();
iLoanId = Convert.ToInt32(((Label)gvCustomerLoan.Rows[e.NewEditIndex].FindControl("lblLoanId")).Text);
if (iLoanId > 0)
{
ObjLoan.LoanId = iLoanId;
dtLoan = ObjLoan.LoanWithSearchFilters();
if (dtLoan.Rows.Count > 0)
{
//Fill Loan Details
hdnCustomerId.Value = dtLoan.Rows[0]["CustomerId"].ToString();
hdnLoanId.Value = dtLoan.Rows[0]["LoanID"].ToString();
//Loan Details
txtLoanDate.Text = dtLoan.Rows[0]["LoanDate"].ToString();
ddlLoanType.SelectedValue = dtLoan.Rows[0]["LoanTypeID"].ToString();
txtLoanAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtLoan.Rows[0]["LoanAmount"]));
txtEmiAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtLoan.Rows[0]["InstallmentAmount"]));
strValue = dtLoan.Rows[0]["LoanPeriod"].ToString();
intYear = (System.Convert.ToInt32(strValue) / 12);
ddlLoanYear.SelectedValue = intYear.ToString();
intMonth = (System.Convert.ToInt32(strValue) - (intYear * 12));
ddlLoanMonth.SelectedValue = intMonth.ToString();
ddlCustomerPastLoanEMI.SelectedValue = dtLoan.Rows[0]["LoanPaidTypeID"].ToString();
txtCustomerLoanPurpose.Text = dtLoan.Rows[0]["LoanReason"].ToString();
txtTotalLoanInstallmentAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtLoan.Rows[0]["TotalInstallment"]));
BindCustomerDetails(Convert.ToInt64(dtLoan.Rows[0]["CustomerId"].ToString()));
BindWitnessDetails(Convert.ToInt64(dtLoan.Rows[0]["WitnessID1"]), "1");
BindWitnessDetails(Convert.ToInt64(dtLoan.Rows[0]["WitnessID2"]), "2");
BindWitnessDetails(Convert.ToInt64(dtLoan.Rows[0]["WitnessID3"]), "3");
BindWitnessDetails(Convert.ToInt64(dtLoan.Rows[0]["WitnessID4"]), "4");
EnableDisabledControls(false);
ShowHideLoanGrid(false);
ShowHideLoanWitnessFields(false);
}
}
}
catch (Exception) { }
finally
{
ObjLoan = null;
ObjCust = null;
dtLoan = null;
}
ShowHideLoanGrid(false);
EnableDisabledControls(false);
}
/// <summary>
/// Added By : Himanshu Pandya
/// </summary>
private void BindCustomerGrid()
{
ObjCustomer = new clsCustomer();
dtCustomer = new DataTable();
try
{
ShowHideCusotmerGrid(true);
if (!string.IsNullOrEmpty(txtSearchCustomer.Text) && !string.IsNullOrEmpty(ddlCustomerSearch.SelectedValue))
{
string strsearch = ddlCustomerSearch.SelectedValue.ToString();
switch (strsearch)
{
case "CustomerNo":
ObjCustomer.CustomerCode = txtSearchCustomer.Text.ToString();
break;
case "CusotmerName":
ObjCustomer.FirstName = txtSearchCustomer.Text.ToString();
break;
case "CusotmerDistrict":
ObjCustomer.DistrictName = txtSearchCustomer.Text.ToString();
break;
default:
break;
}
}
else
{
ObjCustomer.CustomerCode = string.Empty;
ObjCustomer.FirstName = string.Empty;
ObjCustomer.DistrictName = string.Empty;
}
dtCustomer = ObjCustomer.SearcheAllCustomerWSearchFilters();
if (dtCustomer.Rows.Count > 0)
{
gvCustomer.DataSource = dtCustomer;
}
else
{
gvCustomer.DataSource = null;
}
gvCustomer.PageSize = Convert.ToInt32(ddlPager.SelectedValue.ToString());
gvCustomer.DataBind();
}
catch { }
finally { ObjCustomer = null; dtCustomer = null; }
}
