public int CUDCustomer(customerEntity customerEntity, char Operation)
{
Hashtable hashtable = new Hashtable();
if (Operation == 'I')
{
hashtable.Add("@TravellerId", 0);
//need to change updated by after session createds
hashtable.Add("@UpdatedBy", 0);
//need to change updated by after session createds
hashtable.Add("@CreatedBy", 0);
}
else
{
hashtable.Add("@TravellerId", customerEntity.TravellerId);
//need to change updated by after session createds
hashtable.Add("@UpdatedBy", 0);
hashtable.Add("@CreatedBy", 0);
}
hashtable.Add("@TravellerTitel", customerEntity.TravellerTitel);
hashtable.Add("@TravellerFirstName", customerEntity.TravellerFirstName);
hashtable.Add("@TravellerLastName", customerEntity.TravellerLastName);
hashtable.Add("@TravellerMailId", customerEntity.TravellerMailId);
hashtable.Add("@TravellerPhone", customerEntity.TravellerPhone);
hashtable.Add("@TravellerMobile", customerEntity.TravellerMobile);
hashtable.Add("@TravellerAddress", customerEntity.TravellerAddress);
hashtable.Add("@TravellerPassPortNo", customerEntity.TravellerPassPortNo);
if (customerEntity.PassportIssueDate != "")
{
hashtable.Add("@PassportIssueDate", DateTime.ParseExact(customerEntity.PassportIssueDate, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@PassportIssueDate", DBNull.Value);
}
if (customerEntity.PassportExpiryDate != "")
{
hashtable.Add("@PassportExpiryDate", DateTime.ParseExact(customerEntity.PassportExpiryDate, "dd-MM-yyyy", null));
}
else
{
hashtable.Add("@PassportExpiryDate", DBNull.Value);
}
hashtable.Add("@CompanyId", customerEntity.CompanyId);
hashtable.Add("@Operation", Operation);
int result = dataUtilities.ExecuteNonQuery("usp_CUDCustomer", hashtable);
return(result);
}
public void GetSingleCustomer(customerEntity customer)
{
var id = customer.foo_id;
// etc
}
