public Result Delete(Retrieve_message message, string apiKey)
{
try
{
BusinessLayer.CustomerBusinessLayer b = new BusinessLayer.CustomerBusinessLayer();
return(b.Delete(message, apiKey));
}
catch (Exception e)
{
if (e.Message == "wrongkey")
{
Result ErrorObj = new Result();
ErrorObj.Status = "Failure";
ErrorObj.ExceptionDetails = "Invalid Api Key";
ErrorObj.ExceptionType = "AuthorizationException";
throw new WebFaultException <Result>(ErrorObj, System.Net.HttpStatusCode.Unauthorized);
}
else
{
Result obj = new Result();
obj.Status = "Failure";
obj.ExceptionType = e.GetType().ToString().Split('.')[1];
obj.ExceptionDetails = e.Message;
throw new WebFaultException <Result>(obj, System.Net.HttpStatusCode.InternalServerError);
}
}
}
//DELETE CUSTOMER BY ID
public Result Delete(Retrieve_message msg, string apiKey)
{
ICustomerDataBase customer = Toggle();
Result result_msg = new Result();
try
{
if (Authenticator.ApiKeyAuthenticator(apiKey) == false)
{
throw new Exception("wrongkey");
}
msg.Adminid = int.Parse(apiKey);
int ResultStatus = customer.DeleteDetails(msg);
if (ResultStatus == 0) //this is not always unauthorized so change code
{
string message = "You do not own the customer";
CMSLogger.SetProperties("AuthToken", msg.Adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Info(message);
throw new AuthorizationException(message);
}//
else
{
result_msg.Status = "Success";
result_msg.Message = "Customer Deleted Successfully";
}
}
catch (Exception ex)
{
throw;
}
return(result_msg);
}
public List <CustomerDataObject> RetrieveAll(Retrieve_message msg, string apiKey)
{
BusinessLayer.CustomerBusinessLayer BLObject = new BusinessLayer.CustomerBusinessLayer();
try
{
return(BLObject.RetrieveAll(msg, apiKey));
}
catch (Exception e)
{
#region catchblock
if (e.Message == "wrongkey")
{
Result ErrorObj = new Result()
{
};
ErrorObj.Status = "Failure";
ErrorObj.ExceptionDetails = "Invalid Api Key";
ErrorObj.ExceptionType = "AuthorizationException";
throw new WebFaultException <Result>(ErrorObj, System.Net.HttpStatusCode.Unauthorized);
}
else
{
Result ErrorObj = new Result();
ErrorObj.Status = "Failure";
ErrorObj.ExceptionType = e.GetType().ToString().Split('.')[1];
ErrorObj.ExceptionDetails = e.Message;
throw new WebFaultException <Result>(ErrorObj, System.Net.HttpStatusCode.InternalServerError);
}
#endregion
}
}
} //get detailsAll end
public int DeleteDetails(Retrieve_message message)
{ //DELETE details begin
//log
CMSLogger.SetProperties("AuthToken", message.Adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Info("DeleteDetailsInvoked");
int result = 0;
try
{
MySqlCommand cmd;
cnn.Open();
cmd = new MySqlCommand("deleteDetails", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@c_id", message.id);
cmd.Parameters.AddWithValue("@c_adminid", message.Adminid);
Console.WriteLine("\nConnection Open: record Deleted ! ");
result = cmd.ExecuteNonQuery();
Console.WriteLine("num of rows affected" + result);
cnn.Close();
}
catch (Exception ex)
{
cnn.Close();
CMSLogger.SetProperties("AuthToken", message.Adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Error(ex.Message, ex);
throw ex;
}
return(result);
}//END OF DELETE DETAILS
public Retrieve_message ValidateSearchCriteria(Retrieve_message Criteria)
{
if (Criteria.Start_index < 1)
{
Criteria.Start_index = 1;
}
return(Criteria);
}
public List <CustomerDataObject> GetDetailsAll(Retrieve_message Criteria)
{
try {
JsonCustomerDataBaseManager JsonDBM = new JsonCustomerDataBaseManager();
List <CustomerDataObject> CustomerList = JsonDBM.ReadFile("DB.json");
CustomerList = JsonDBM.RetrieveFromList(CustomerList, Criteria);
return(CustomerList);
}
catch
{
throw;
}
}
public int DeleteDetails(Retrieve_message Criteria)
{
try {
JsonCustomerDataBaseManager JsonDBM = new JsonCustomerDataBaseManager();
List <CustomerDataObject> CustomerList = JsonDBM.ReadFile("DB.json");
CustomerDataObject Record = new CustomerDataObject();
Record.Id = Criteria.id;
Record.Adminid = Criteria.Adminid;
CustomerList = JsonDBM.DeleteFromList(CustomerList, Record);
return(1);
}
catch
{
throw;
}
}
public List <CustomerDataObject> GetDetailsAll(Retrieve_message message) //string searchparam,string searchvalue,int adminid,int start_index,int end_index,string sortparam)
{ //get detailsAll begin
CMSLogger.SetProperties("AuthToken", message.Adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Info("GetDetailsALlInvoked");
CustomerDataObject[] obj = new CustomerDataObject[100];// = new DataBase[50]; //warning 100 manually coded here
MySqlCommand cmd;
DataTable dataTable = new DataTable();
List <CustomerDataObject> customer = new List <CustomerDataObject>();
try
{
if (message.Adminid == 9999)
{
cmd = new MySqlCommand("dummygetDetailsAll", cnn);
}
else
{
cmd = new MySqlCommand("getDetailsAll", cnn);
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@c_searchparam", message.Searchparam);
cmd.Parameters.AddWithValue("@c_searchvalue", message.Searchvalue);
cmd.Parameters.AddWithValue("@c_adminid", message.Adminid);
cmd.Parameters.AddWithValue("@c_start_index", message.Start_index);
cmd.Parameters.AddWithValue("@c_end_index", message.End_index);
cmd.Parameters.AddWithValue("@c_sortparam", message.Sortparam);
//cmd.Parameters.AddWithValue("@c_searchparam", "gender");
//cmd.Parameters.AddWithValue("@c_searchvalue", "male");
//cmd.Parameters.AddWithValue("@c_adminid", 9999);
//cmd.Parameters.AddWithValue("@c_start_index", 1);
//cmd.Parameters.AddWithValue("@c_end_index", 7);
//cmd.Parameters.AddWithValue("@c_sortparam", "age");
//cnn.Close();
cnn.Open();
using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
{
da.Fill(dataTable);
cnn.Close();
}
//to print the datatable
//to build db object
int dbobj_count = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
int count = 0;
obj[dbobj_count] = new CustomerDataObject();
foreach (var item in dataRow.ItemArray)
{
Console.WriteLine(item);
count++;
switch (count)
{
case 1: obj[dbobj_count].Id = (int)item; Console.WriteLine(obj[dbobj_count].Id); break;
case 2: obj[dbobj_count].CustomerName = (string)item; Console.WriteLine(obj[dbobj_count].CustomerName); break;
case 3: obj[dbobj_count].Gender = (string)item; break;
case 4: obj[dbobj_count].Age = (int)item; break;
case 5: obj[dbobj_count].Phone = (long)item; break;
case 6: obj[dbobj_count].Address = (string)item; break;
case 7: obj[dbobj_count].City = (string)item; break;
case 8: obj[dbobj_count].Emailid = (string)item; break;
case 9: obj[dbobj_count].Adminid = (int)item; break;
}
}
customer.Add(obj[dbobj_count]);
dbobj_count++;
}
}
catch (Exception ex)
{
cnn.Close();
CMSLogger.SetProperties("AuthToken", message.Adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Error(ex.Message, ex);
throw ex;
}
return(customer);
} //get detailsAll end
//retrieve ALL OR RETRIEVE ALL BY ADMINID
public List <CustomerDataObject> RetrieveAll(Retrieve_message msg, string apiKey)
{
ICustomerDataBase customer = Toggle();
List <CustomerDataObject> customerlist = new List <CustomerDataObject>();
try
{
//auth
if (Authenticator.ApiKeyAuthenticator(apiKey) == false)
{
throw new Exception("wrongkey");
}
//parse api key
msg.Adminid = int.Parse(apiKey);
// default all records if no searchparam mentioned
if (msg.Adminid == 1234 && (msg.Searchparam == null || msg.Searchvalue == null))
{
msg.Adminid = 9999;
}
if (msg.Searchparam == null || msg.Searchvalue == null)
{
msg.Searchparam = "adminid";
msg.Searchvalue = msg.Adminid.ToString();
}
if (msg.Sortparam == null)
{
msg.Sortparam = "id";
}
if (msg.Start_index < 0)
{
msg.Start_index = 1;
}
if (msg.End_index <= 0)
{
msg.End_index = 100;
}
customerlist = customer.GetDetailsAll(msg);//.Searchparam,msg.Searchvalue,msg.Adminid, msg.Start_index, msg.End_index, msg.Sortparam);
}
catch (Exception e)
{
if (e.Message.Contains(msg.Searchparam))
{
UnknownFilterException ufex = new UnknownFilterException("Unknown Search Parameter");
throw ufex;
}
else if (e.Message.Contains(msg.Sortparam))
{
UnknownFilterException ufex = new UnknownFilterException("Unknown Sort Parameter");
throw ufex;
}
else
{
throw;
}
}
return(customerlist);
}
public List <CustomerDataObject> RetrieveFromList(List <CustomerDataObject> CustomerList, Retrieve_message Criteria)
{
try
{
Criteria = ValidateSearchCriteria(Criteria);
List <CustomerDataObject> FilteredList;
FilteredList = CustomerList.FindAll(delegate(CustomerDataObject Obj) { return(Obj.CustomerName.Contains(Criteria.Searchvalue) || Obj.Emailid == Criteria.Searchvalue || Obj.Gender.Contains(Criteria.Searchvalue)); });
if (Criteria.End_index > FilteredList.Count)
{
Criteria.End_index = FilteredList.Count;
}
FilteredList = FilteredList.GetRange((Criteria.Start_index - 1), Criteria.End_index - Criteria.Start_index + 1);
switch (Criteria.Sortparam)
{
case "Name": FilteredList = FilteredList.OrderBy(cc => cc.CustomerName).ToList <CustomerDataObject>(); break;
case "Gender": FilteredList = FilteredList.OrderBy(cc => cc.Gender).ToList <CustomerDataObject>(); break;
case "Emailid": FilteredList = FilteredList.OrderBy(cc => cc.Emailid).ToList <CustomerDataObject>(); break;
}
return(FilteredList);
}
catch
{
throw;
}
}
