public int SaveComplaint(complaintItem complaint)
{
asynSaveImage = new SaveImageBytes(ImageController.SavePicture);
try
{
context = new SocialCopsEntities();
// Add Log
logger.LogMethod("ENTER","SaveComplaint","Userid/" + complaint.userId.ToString()+ "/ started SaveComplaint", null);
// New Complaint
Complaint temp = new Complaint();
temp = complaintItem.convertComplaint(complaint);
//Add a new Complaint
context.Complaints.Add(temp);
context.SaveChanges();
//Image Upload Async
byte[] image = complaint.ImageByte;
if (image.Length > 0)
{
IAsyncResult result = asynSaveImage.BeginInvoke(image, temp.complaintId.ToString(), new AsyncCallback(FinishImageUpload), asynSaveImage);
}
// Exit Log
logger.LogMethod("EXIT", "SaveComplaint", "Userid/" + complaint.userId.ToString() + "/ finished SaveComplaint", null);
return temp.complaintId;
}
catch (Exception ex)
{
logger.LogMethod("ERROR", "SaveComplaint", "Userid/" + complaint.userId.ToString() + "/ " + ex.ToString(), null);
error.Result = false;
error.ErrorMessage = "unforeseen error occured. Please try later.";
error.ErrorDetails = ex.ToString();
throw new FaultException<Bug>(error, ex.ToString());
}
}
public static complaintItem convertComplaint(Complaint temp)
{
complaintItem complaint = new complaintItem();
complaint.complaintId = temp.complaintId;
complaint.userId = temp.userId;
complaint.title = temp.title;
complaint.details = temp.details;
complaint.numLikes = (int)temp.numLikes;
complaint.numComments = (int)temp.numComments;
complaint.picture = temp.picture;
complaint.complaintDate = (DateTime)temp.complaintDate;
complaint.location = temp.location;
complaint.latitude = (float)temp.latitude;
complaint.longitude = (float)temp.longitude;
complaint.category = temp.category;
complaint.complaintStatus = temp.complaintStatus;
complaint.date = temp.date;
complaint.isAnonymous = temp.isAnonymous;
complaint.city = temp.city;
complaint.state = temp.state;
complaint.country = temp.country;
complaint.pincode = temp.pincode;
complaint.thumbImage1 = temp.thumbImage1;
complaint.thumbImage2 = temp.thumbImage2;
return(complaint);
}
public static Complaint convertComplaint(complaintItem item)
{
Complaint temp = new Complaint();
temp.userId = item.userId;
temp.title = item.title;
temp.details = item.details;
temp.numLikes = (int)item.numLikes;
temp.numComments = (int)item.numComments;
temp.picture = item.picture;
temp.complaintDate = (DateTime)item.complaintDate;
temp.location = item.location;
temp.latitude = (float)item.latitude;
temp.longitude = (float)item.longitude;
temp.category = item.category;
temp.complaintStatus = item.complaintStatus;
temp.date = item.date;
temp.isAnonymous = item.isAnonymous;
temp.city = item.city;
temp.state = item.state;
temp.country = item.country;
temp.pincode = item.pincode;
return(temp);
}
public complaintItem[] GetComplaintsByStatus(string complaintStatus)
{
try
{
logger.LogMethod("DEBUG", "GetComplaintsByStatus/{complaintStatus}", complaintStatus + "/ started GetComplaintsByStatus/{complaintStatus}", null);
key = complaintStatus + "GetComplaintsByStatus";
List<complaintItem> list = new List<complaintItem>();
context = new SocialCopsEntities();
//Checking if the complaints exist in cache
//retrieveing complaints if they do.
if (CachingConfig.CachingEnabled)
{
list = (List<complaintItem>)WCFCache.Current[key];
if (list != null)
{
logger.LogMethod("CACHE", "GetComplaintsByStatus/{complaintStatus}", complaintStatus + "/ Cache Found - GetComplaintsByStatus/{complaintStatus}", null);
return list.ToArray();
}
}
list = new List<complaintItem>();
List<Complaint> complaints = (from c
in context.Complaints
where c.complaintStatus == complaintStatus
orderby c.complaintDate descending
select c).ToList();
foreach (Complaint temp in complaints)
{
complaintItem complaint = new complaintItem();
complaint=complaintItem.convertComplaint(temp);
list.Add(complaint);
}
Cache.Cache.AddToCache(key, list);
logger.LogMethod("DEBUG", "GetComplaintsByStatus/{complaintStatus}", complaintStatus + "/ finished GetComplaintsByStatus/{complaintStatus}", null);
return list.ToArray();
}
catch (Exception ex)
{
logger.LogMethod("ERROR", "GetComplaintsByStatus/{complaintStatus}", complaintStatus + "/ " + ex.Message);
error.Result = false;
error.ErrorMessage = "unforeseen error occured. Please try later.";
error.ErrorDetails = ex.ToString();
throw new FaultException<Bug>(error, ex.ToString());
}
}
public complaintItem[] GetComplaintsByPin(string pin)
{
try
{
logger.LogMethod("jo", "GetComplaintsByPin", "Enter");
key = pin + "GetComplaintsByPin";
List<complaintItem> list = new List<complaintItem>();
context = new SocialCopsEntities();
//Checking if the complaints exist in cache
//retrieveing complaints if they do.
if (CachingConfig.CachingEnabled)
{
list = (List<complaintItem>)WCFCache.Current[key];
if (list != null)
{
logger.LogMethod("jo", "GetComplaintsByPin", "Cache Found");
return list.ToArray();
}
}
list = new List<complaintItem>();
List<Complaint> complaints = (from c
in context.Complaints
where c.pincode == pin
orderby c.complaintDate descending
select c).ToList();
foreach (Complaint temp in complaints)
{
complaintItem complaint = new complaintItem();
complaint= complaintItem.convertComplaint(temp);
list.Add(complaint);
}
Cache.Cache.AddToCache(key, list);
logger.LogMethod("jo", "GetComplaintsByPin", "Exit");
return list.ToArray();
}
catch (Exception ex)
{
error.Result = false;
error.ErrorMessage = "unforeseen error occured. Please try later.";
error.ErrorDetails = ex.ToString();
throw new FaultException<Bug>(error, ex.ToString());
}
}
public complaintItem GetComplaintsById(string id)
{
complaintItem temp = new complaintItem();
key = id + "GetComplaints";
try
{
logger.LogMethod("DEBUG", "GetComplaints/{id}", id+ "/ started GetComplaints/{id}", null);
context = new SocialCopsEntities();
if (CachingConfig.CachingEnabled)
{
temp = (complaintItem)WCFCache.Current[key];
if (temp != null)
{
logger.LogMethod("CACHE", "GetComplaints/{id}", id + "/ Cache Found - finished GetComplaints/{id}", null);
return temp;
}
}
int cId = Convert.ToInt32(id);
List<Complaint> complaints = (from c
in context.Complaints
where c.complaintId == cId
select c).ToList();
temp = new complaintItem();
if (complaints.Count == 0)
{
error.Result = false;
error.ErrorMessage = "Invalid request. There is no complaint of the given id.";
logger.LogMethod("ERROR", "GetComplaints/{id}", id+ "/ Invalid request. There is no complaint of the given id.", null);
throw new FaultException<Bug>(error);
}
foreach (Complaint complaint in complaints)
{
temp = complaintItem.convertComplaint(complaint);
}
Cache.Cache.AddToCache(key, temp);
logger.LogMethod("DEBUG", "GetComplaints/{id}", id + "/ finished GetComplaints/{id}", null);
return temp;
}
catch (Exception ex)
{
error.Result = false;
error.ErrorMessage = "unforeseen error occured. Please try again later";
logger.LogMethod("ERROR", "GetComplaints/{id}", id+ "/ "+ ex.Message);
throw new FaultException<Bug>(error, ex.ToString());
}
}
public int SaveComplaint(complaintItem complaint)
{
cc = new ComplaintController();
int result = cc.SaveComplaint(complaint);
return result;
}
public complaintItem GetCopy()
{
complaintItem copy = (complaintItem)this.MemberwiseClone();
return(copy);
}
public complaintItem[] GetComplaintsByAuthId(string authId)
{
try
{
logger.LogMethod("jo", "GetComplaintsByAuthId", "Enter");
List<complaintItem> list = new List<complaintItem>();
key = authId + "GetComplaintsByAuthId";
if (CachingConfig.CachingEnabled)
{
list = (List<complaintItem>)WCFCache.Current[key];
if (list != null)
{
logger.LogMethod("jo", "GetComplaintsbyAuthId", "Cache found");
return list.ToArray();
}
}
list = new List<complaintItem>();
int aid = Convert.ToInt32(authId);
context = new SocialCopsEntities();
//Getting the complaintIds from jurisdiction table where id is authId
var complaintIds = (from c
in context.Jurisdictions
where c.authId == aid
select c.complaintId);
if (complaintIds == null)
{
logger.LogMethod("jo", "GetComplaintsByAuthId", "No Complaints exist under the given authority");
return null;
}
List<Complaint> complaints = (from c
in context.Complaints
where complaintIds.Contains(c.complaintId)
orderby c.complaintDate descending
select c).ToList();
foreach (Complaint temp in complaints)
{
complaintItem complaint = new complaintItem();
complaint.complaintId = temp.complaintId;
complaint.userId = temp.userId;
complaint.title = temp.title;
complaint.details = temp.details;
complaint.numLikes = (int)temp.numLikes;
complaint.numComments = (int)temp.numComments;
complaint.picture = temp.picture;
complaint.complaintDate = (DateTime)temp.complaintDate;
complaint.location = temp.location;
complaint.latitude = (float)temp.latitude;
complaint.longitude = (float)temp.longitude;
complaint.category = temp.category;
complaint.complaintStatus = temp.complaintStatus;
complaint.date = temp.date;
complaint.isAnonymous = temp.isAnonymous;
complaint.thumbImage1 = temp.thumbImage1;
complaint.thumbImage2 = temp.thumbImage2;
complaint.city = temp.city;
complaint.country = temp.country;
complaint.state = temp.state;
complaint.pincode = temp.pincode;
list.Add(complaint);
}
Cache.Cache.AddToCache(key, list);
logger.LogMethod("jo", "GetComplaintsByAuthId", "Exit");
return list.ToArray();
}
catch (Exception ex)
{
error.ErrorMessage = "An error occurred. Sorry!";
error.Result = true;
logger.LogMethod("jo", "GetComplaintsByAuthId", ex.Message);
throw new FaultException<Bug>(error, ex.Message);
}
}
public static complaintItem convertComplaint(Complaint temp)
{
complaintItem complaint = new complaintItem();
complaint.complaintId = temp.complaintId;
complaint.userId = temp.userId;
complaint.title = temp.title;
complaint.details = temp.details;
complaint.numLikes = (int)temp.numLikes;
complaint.numComments = (int)temp.numComments;
complaint.picture = temp.picture;
complaint.complaintDate = (DateTime)temp.complaintDate;
complaint.location = temp.location;
complaint.latitude = (float)temp.latitude;
complaint.longitude = (float)temp.longitude;
complaint.category = temp.category;
complaint.complaintStatus = temp.complaintStatus;
complaint.date = temp.date;
complaint.isAnonymous = temp.isAnonymous;
complaint.city = temp.city;
complaint.state = temp.state;
complaint.country = temp.country;
complaint.pincode = temp.pincode;
complaint.thumbImage1 = temp.thumbImage1;
complaint.thumbImage2 = temp.thumbImage2;
return complaint;
}
public static Complaint convertComplaint(complaintItem item)
{
Complaint temp = new Complaint();
temp.userId = item.userId;
temp.title = item.title;
temp.details = item.details;
temp.numLikes = (int)item.numLikes;
temp.numComments = (int)item.numComments;
temp.picture = item.picture;
temp.complaintDate = (DateTime)item.complaintDate;
temp.location = item.location;
temp.latitude = (float)item.latitude;
temp.longitude = (float)item.longitude;
temp.category = item.category;
temp.complaintStatus = item.complaintStatus;
temp.date = item.date;
temp.isAnonymous = item.isAnonymous;
temp.city = item.city;
temp.state = item.state;
temp.country = item.country;
temp.pincode = item.pincode;
return temp;
}