public CustomerRelation Delete(CustomerRelation cust)
{
CustomerRelation _customer = null;
using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection))
{
sqlConnection.Open();
_customer = sqlConnection.Get <CustomerRelation>(cust.RELATION_NUMBER);
_customer.RECORD_STATUS = 0;
_customer.UPDATE_DATE = DateTime.Now;
_customer.UPDATE_USER = cust.UPDATE_USER;
_customer.CUSTOMER_NAME = cust.CUSTOMER_NAME;
_customer.CUSTOMER_MIDDLE_NAME = cust.CUSTOMER_MIDDLE_NAME;
_customer.CUSTOMER_SURNAME = cust.CUSTOMER_SURNAME;
_customer.RELATION_NUMBER = cust.RELATION_NUMBER;
_customer.EMAIL = cust.EMAIL;
_customer.PHONE_NUMBER = cust.PHONE_NUMBER;
_customer.GENDER = cust.GENDER;
sqlConnection.Update <CustomerRelation>(_customer);
var result = sqlConnection.Get <CustomerRelation>(cust.RELATION_NUMBER);
}
return(_customer);
}
public long Insert(CustomerRelation cust)
{
using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection))
{
sqlConnection.Open();
var _customer = new CustomerRelation()
{
GUID = Guid.NewGuid().ToString(),
RECORD_STATUS = 1,
INSERT_DATE = DateTime.Now,
INSERT_USER = cust.INSERT_USER,
UPDATE_DATE = DateTime.Now,
UPDATE_USER = cust.UPDATE_USER,
CUSTOMER_NUMBER = cust.CUSTOMER_NUMBER,
CUSTOMER_NAME = cust.CUSTOMER_NAME,
CUSTOMER_MIDDLE_NAME = cust.CUSTOMER_MIDDLE_NAME,
CUSTOMER_SURNAME = cust.CUSTOMER_SURNAME,
IDENTIFICATION_ID = cust.IDENTIFICATION_ID,
EMAIL = cust.EMAIL,
PHONE_NUMBER = cust.PHONE_NUMBER,
GENDER = cust.GENDER
};
var customerGuid = sqlConnection.Insert <CustomerRelation>(_customer);
sqlConnection.Close();
return(customerGuid);
}
}
public override void DoOperation()
{
try
{
//Validate Reques Header / Constants
this.baseResponseMessage = ValidateInput();
if (!this.baseResponseMessage.header.IsSuccess)
{
throw new Exception(this.baseResponseMessage.header.ResponseMessage);
}
//Operation
switch (this.request.Header.OperationTypes)
{
case (int)OperationType.OperationTypes.ADD:
long checkGuid = 0;
this.customer = new CustomerRelation
{
INSERT_USER = this.request.INSERT_USER,
UPDATE_USER = this.request.UPDATE_USER,
CUSTOMER_NAME = this.request.CUSTOMER_NAME,
CUSTOMER_SURNAME = this.request.CUSTOMER_SURNAME,
CUSTOMER_MIDDLE_NAME = this.request.CUSTOMER_MIDDLE_NAME,
CUSTOMER_NUMBER = this.request.CUSTOMER_NUMBER,
IDENTIFICATION_ID = this.request.IDENTIFICATION_ID,
EMAIL = this.request.EMAIL,
PHONE_NUMBER = this.request.PHONE_NUMBER,
GENDER = this.request.GENDER
};
//Add Data to Database
checkGuid = CustomerRelation.Insert(this.customer);
responsedata = new ResponseCustomerRelation
{
INSERT_USER = this.request.INSERT_USER,
UPDATE_USER = this.request.UPDATE_USER,
CUSTOMER_NAME = this.request.CUSTOMER_NAME,
CUSTOMER_SURNAME = this.request.CUSTOMER_SURNAME,
CUSTOMER_MIDDLE_NAME = this.request.CUSTOMER_MIDDLE_NAME,
RELATION_NUMBER = checkGuid,
CUSTOMER_NUMBER = this.request.CUSTOMER_NUMBER,
IDENTIFICATION_ID = this.request.IDENTIFICATION_ID,
EMAIL = this.request.EMAIL,
PHONE_NUMBER = this.request.PHONE_NUMBER,
GENDER = this.request.GENDER,
header = new ResponseHeader
{
IsSuccess = checkGuid == 0 ? false : true,
ResponseCode = checkGuid == 0 ? CommonDefinitions.INTERNAL_SYSTEM_UNKNOWN_ERROR : CommonDefinitions.SUCCESS,
ResponseMessage = checkGuid == 0 ? CommonDefinitions.ERROR_MESSAGE : CommonDefinitions.SUCCESS_MESSAGE
}
};
break;
case (int)OperationType.OperationTypes.GET:
//Get Data
this.listcustomerRelation = CustomerRelation.SelectByCustomerNumber(this.request.CUSTOMER_NUMBER);
this.listcustomerRelationResponse = new List <ResponseCustomerRelation>();
foreach (var item in this.listcustomerRelationResponse)
{
responsedata = new ResponseCustomerRelation
{
INSERT_USER = item.INSERT_USER,
UPDATE_USER = item.UPDATE_USER,
CUSTOMER_NAME = item.CUSTOMER_NAME,
CUSTOMER_SURNAME = item.CUSTOMER_SURNAME,
CUSTOMER_MIDDLE_NAME = item.CUSTOMER_MIDDLE_NAME,
RELATION_NUMBER = item.RELATION_NUMBER,
CUSTOMER_NUMBER = item.CUSTOMER_NUMBER,
IDENTIFICATION_ID = item.IDENTIFICATION_ID,
EMAIL = item.EMAIL,
PHONE_NUMBER = item.PHONE_NUMBER,
GENDER = item.GENDER,
header = new ResponseHeader
{
IsSuccess = true,
ResponseCode = CommonDefinitions.SUCCESS,
ResponseMessage = CommonDefinitions.SUCCESS_MESSAGE
}
};
this.response.Add(responsedata);
}
break;
case (int)OperationType.OperationTypes.UPDATE:
this.listcustomerRelation = CustomerRelation.SelectByCustomerNumber(this.request.RELATION_NUMBER);
this.customer = new CustomerRelation
{
INSERT_USER = this.request.INSERT_USER,
UPDATE_USER = this.request.UPDATE_USER,
CUSTOMER_NAME = this.request.CUSTOMER_NAME,
CUSTOMER_SURNAME = this.request.CUSTOMER_SURNAME,
CUSTOMER_MIDDLE_NAME = this.request.CUSTOMER_MIDDLE_NAME,
RELATION_NUMBER = this.request.RELATION_NUMBER,
CUSTOMER_NUMBER = this.request.CUSTOMER_NUMBER,
IDENTIFICATION_ID = this.request.IDENTIFICATION_ID,
EMAIL = this.request.EMAIL,
PHONE_NUMBER = this.request.PHONE_NUMBER,
GENDER = this.request.GENDER,
};
//Update Customer Information
CustomerRelation.Update(this.customer);
foreach (var item in this.listcustomerRelationResponse)
{
responsedata = new ResponseCustomerRelation
{
INSERT_USER = item.INSERT_USER,
UPDATE_USER = item.UPDATE_USER,
CUSTOMER_NAME = item.CUSTOMER_NAME,
CUSTOMER_SURNAME = item.CUSTOMER_SURNAME,
CUSTOMER_MIDDLE_NAME = item.CUSTOMER_MIDDLE_NAME,
RELATION_NUMBER = item.RELATION_NUMBER,
CUSTOMER_NUMBER = item.CUSTOMER_NUMBER,
IDENTIFICATION_ID = item.IDENTIFICATION_ID,
EMAIL = item.EMAIL,
PHONE_NUMBER = item.PHONE_NUMBER,
GENDER = item.GENDER,
header = new ResponseHeader
{
IsSuccess = true,
ResponseCode = CommonDefinitions.SUCCESS,
ResponseMessage = CommonDefinitions.SUCCESS_MESSAGE
}
};
this.response.Add(responsedata);
}
break;
case (int)OperationType.OperationTypes.DELETE:
this.listcustomerRelation = CustomerRelation.SelectByCustomerNumber(this.request.RELATION_NUMBER);
this.customer = new CustomerRelation
{
INSERT_USER = this.request.INSERT_USER,
RECORD_STATUS = 0,
UPDATE_USER = this.request.UPDATE_USER,
CUSTOMER_NAME = this.request.CUSTOMER_NAME,
CUSTOMER_SURNAME = this.request.CUSTOMER_SURNAME,
CUSTOMER_MIDDLE_NAME = this.request.CUSTOMER_MIDDLE_NAME,
RELATION_NUMBER = this.request.RELATION_NUMBER,
CUSTOMER_NUMBER = this.request.CUSTOMER_NUMBER,
IDENTIFICATION_ID = this.request.IDENTIFICATION_ID,
EMAIL = this.request.EMAIL,
PHONE_NUMBER = this.request.PHONE_NUMBER,
GENDER = this.request.GENDER
};
//Update Customer to Passive
CustomerRelation.Delete(this.customer);
foreach (var item in this.listcustomerRelationResponse)
{
responsedata = new ResponseCustomerRelation
{
INSERT_USER = item.INSERT_USER,
UPDATE_USER = item.UPDATE_USER,
CUSTOMER_NAME = item.CUSTOMER_NAME,
CUSTOMER_SURNAME = item.CUSTOMER_SURNAME,
CUSTOMER_MIDDLE_NAME = item.CUSTOMER_MIDDLE_NAME,
RELATION_NUMBER = item.RELATION_NUMBER,
CUSTOMER_NUMBER = item.CUSTOMER_NUMBER,
IDENTIFICATION_ID = item.IDENTIFICATION_ID,
EMAIL = item.EMAIL,
PHONE_NUMBER = item.PHONE_NUMBER,
GENDER = item.GENDER,
header = new ResponseHeader
{
IsSuccess = true,
ResponseCode = CommonDefinitions.SUCCESS,
ResponseMessage = CommonDefinitions.SUCCESS_MESSAGE
}
};
this.response.Add(responsedata);
}
break;
default:
break;
}
}
catch (Exception ex)
{
string operationError = "HATA:[" + "CustomerNumber:" + this.request.RELATION_NUMBER + ",ResponseCode:" + this.baseResponseMessage.header.ResponseCode + ", ResponseMessage:" + ex.Message + "]";
log.InfoFormat(operationError, ex);
throw new Exception(ex.Message, ex.InnerException);
}
}
