}//END OF DELETE DETAILS
public int SetDetails(CustomerDataObject customerobj)
{//SET DETAILS BEGINS
CMSLogger.SetProperties("AuthToken", customerobj.Adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Info("setDetailsInvoked");
int result = 0;
try
{
MySqlCommand cmd;
cnn.Open();
cmd = new MySqlCommand("setDetails", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", customerobj.CustomerName);
cmd.Parameters.AddWithValue("@age", customerobj.Age);
cmd.Parameters.AddWithValue("@gender", customerobj.Gender);
cmd.Parameters.AddWithValue("@phone", customerobj.Phone);
cmd.Parameters.AddWithValue("@address", customerobj.Address);
cmd.Parameters.AddWithValue("@city", customerobj.City);
cmd.Parameters.AddWithValue("@emailid", customerobj.Emailid);
cmd.Parameters.AddWithValue("@adminid", customerobj.Adminid);
result = cmd.ExecuteNonQuery();
Console.WriteLine("num of rows affected" + result);
cnn.Close();
}
catch (Exception ex)
{
CMSLogger.SetProperties("AuthToken", customerobj.Adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Error(ex.Message, ex);
cnn.Close();
throw;
}
return(result);
}//SET DETAILS ENDS
public bool GetValidUser(int adminid)
{ //checks for Valid user- admin begin
try
{
CMSLogger.SetProperties("AuthToken", adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Info("getValidUserInvoked");
Conn.Open();
MySqlCommand cmd;
DataTable dataTable = new DataTable();
cmd = new MySqlCommand("getValidUser", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@c_adminid", adminid);
using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
{
da.Fill(dataTable);
}
if (dataTable.Rows.Count == 1)
{
Conn.Close();
return(true);
}
else
{
Conn.Close();
return(false);
}
}
catch (Exception ex)
{
CMSLogger.SetProperties("AuthToken", adminid.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Error(ex.Message, ex);
Conn.Close();
throw;
}
} //checks for Valid user- admin end
private void ClickThread()
{
while (!Quit)
{
if (ClickEvent)
{
ClickEvent = false;
Point p = System.Windows.Forms.Cursor.Position;
User32.mouse_event(2, p.X, p.Y, 0, 0); //Right mouse down at x,y
System.Threading.Thread.Sleep(100);
User32.mouse_event(4, p.X, p.Y, 0, 0); //Right mouse up at x,y
if (CMSLogger.CanCreateLogEvent(false, false, false, "CMSLogClickEvent"))
{
CMSLogClickEvent clickEvent = new CMSLogClickEvent();
if (clickEvent != null)
{
clickEvent.X = p.X;
clickEvent.Y = p.Y;
clickEvent.Width = CMSConstants.SCREEN_WIDTH;
clickEvent.Height = CMSConstants.SCREEN_HEIGHT;
clickEvent.ClickType = ClickType.LClk;
CMSLogger.SendLogEvent(clickEvent);
}
}
}
System.Threading.Thread.Sleep(100);
}
}
} //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
private void StartLongAction(ClickAction clickAction)
{
switch (clickAction)
{
case ClickAction.LeftDrag:
{
isDragging = true;
Point CursorPos = Cursor.Position;
mouse_event(MOUSEEVENTF_LEFTDOWN, CursorPos.X, CursorPos.Y, 0, 0);
if (CMSLogger.CanCreateLogEvent(false, false, false, "CMSLogClickEvent"))
{
CMSLogClickEvent clickEvent = new CMSLogClickEvent();
if (clickEvent != null)
{
Point c = Cursor.Position;
clickEvent.X = c.X;
clickEvent.Y = c.Y;
clickEvent.Width = CMSConstants.SCREEN_WIDTH;
clickEvent.Height = CMSConstants.SCREEN_HEIGHT;
clickEvent.ClickType
= GetXmlClickType(clickAction, true);
CMSLogger.SendLogEvent(clickEvent);
}
}
}
break;
default:
{
return;
}
}
}
//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 override void SendSuiteLogEvent()
{
if (CMSLogger.CanCreateLogEvent(false, false, false, "CMSLogBlinkLinkStandardTrackingEvent"))
{
CMSLogBlinkLinkStandardTrackingEvent logEvent = new CMSLogBlinkLinkStandardTrackingEvent();
logEvent.Suite = this;
CMSLogger.SendLogEvent(logEvent);
}
}
public override void SendSuiteLogEvent()
{
if (CMSLogger.CanCreateLogEvent(false, false, false, "AHMLogSuiteEvent"))
{
AHMLogSuiteEvent logEvent = new AHMLogSuiteEvent();
if (logEvent != null)
{
logEvent.SimpleTrackingSuite = this;
CMSLogger.SendLogEvent(logEvent);
}
}
}
} //checks for Valid user- admin end
public UserDataObject VerifyUser(string mail)
{
DataTable dataTable = new DataTable();
UserDataObject obj = new UserDataObject();
try
{
CMSLogger.SetProperties("AuthToken", mail, System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Info("VerifyUserInvoked");
Conn.Open();
MySqlCommand cmd;
cmd = new MySqlCommand("verifyuser", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mail", mail);
using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
{
da.Fill(dataTable);
}
//to fetch secret
if (dataTable.Rows.Count != 0)
{
obj.Adminid = (int)dataTable.Rows[0].ItemArray[0];
obj.UserName = (string)dataTable.Rows[0].ItemArray[1].ToString();
obj.Emailid = (string)dataTable.Rows[0].ItemArray[2].ToString();
obj.Password = (string)dataTable.Rows[0].ItemArray[3].ToString();
}
else
{
obj.Password = "******";
}
Conn.Close();
}
catch (Exception ex)
{
CMSLogger.SetProperties("AuthToken", mail, System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Error(ex.Message, ex);
Conn.Close();
throw;
}
return(obj);
}
private void PerformShortAction(ClickAction clickAction)
{
Point CursorPos = Cursor.Position;
switch (clickAction)
{
case ClickAction.DoubleClick:
{
mouse_event(MOUSEEVENTF_LEFTDOWN | MOUSEEVENTF_LEFTUP, CursorPos.X, CursorPos.Y, 0, 0);
Thread.Sleep(10);
mouse_event(MOUSEEVENTF_LEFTDOWN | MOUSEEVENTF_LEFTUP, CursorPos.X, CursorPos.Y, 0, 0);
}
break;
case ClickAction.LeftClick:
{
mouse_event(MOUSEEVENTF_LEFTDOWN | MOUSEEVENTF_LEFTUP, CursorPos.X, CursorPos.Y, 0, 0);
}
break;
case ClickAction.RightClick:
{
mouse_event(MOUSEEVENTF_RIGHTDOWN | MOUSEEVENTF_RIGHTUP, CursorPos.X, CursorPos.Y, 0, 0);
}
break;
default:
{
return;
}
}
if (CMSLogger.CanCreateLogEvent(false, false, false, "CMSLogClickEvent"))
{
CMSLogClickEvent clickEvent = new CMSLogClickEvent();
if (clickEvent != null)
{
Point c = Cursor.Position;
clickEvent.X = c.X;
clickEvent.Y = c.Y;
clickEvent.Width = CMSConstants.SCREEN_WIDTH;
clickEvent.Height = CMSConstants.SCREEN_HEIGHT;
clickEvent.ClickType
= GetXmlClickType(clickAction, false);
CMSLogger.SendLogEvent(clickEvent);
}
}
}
public int Register(UserDataObject userObj)
{//SET DETAILS BEGINS
int result = 0;
try
{
CMSLogger.SetProperties("AuthToken", "unassigned", System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Info("registerInvoked");
Conn.Open();
MySqlCommand cmd;
cmd = new MySqlCommand("registeruser", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@username", userObj.UserName);
cmd.Parameters.AddWithValue("@dob", userObj.Dob);
cmd.Parameters.AddWithValue("@gender", userObj.Gender);
cmd.Parameters.AddWithValue("@phone", userObj.Phone);
cmd.Parameters.AddWithValue("@address", userObj.Address);
cmd.Parameters.AddWithValue("@city", userObj.City);
cmd.Parameters.AddWithValue("@emailid", userObj.Emailid);
cmd.Parameters.AddWithValue("@password", userObj.Password);
result = cmd.ExecuteNonQuery();
Console.WriteLine("num of rows affected" + result);
Conn.Close();
}
catch (Exception ex)
{
CMSLogger.SetProperties("AuthToken", "unassigned", System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString());
CMSLogger.log.Error(ex.Message, ex);
Conn.Close();
throw;
}
return(result);
}//SET DETAILS END
private void ProcessAHM()
{
lock (mutex)
{
if (cameraMouseAssist == null)
{
return;
}
double ccMinProjSqdDist = 0.0;
double ccTanSqdDist = 0.0;
try
{
if (cameraMouseAssist != null && cameraMouseAssist.isReady())
{
if (_AHMWeights == null || _AHMWeights.Length != this.numTemplates)
{
_AHMWeights = new double[numTemplates];
}
float relX = 0.0f;
float relY = 0.0f;
if ((imagePoint.X >= obsSize / 2 + 10) && (imagePoint.Y >= obsSize / 2 + 10) &&
((imagePoint.X + imagePoint.Y / 2 + 10) < imageSize.Width) &&
((imagePoint.Y + obsSize / 2 + 10) < imageSize.Height))
{
if (this._AHMRealtimeObs == null)
{
this._AHMRealtimeObs = CvImageWrapper.CreateImage(new CvSize(obsSize + 20, obsSize + 20), 8, 3);
}
if (this._AHMBackFeature == null)
{
this._AHMBackFeature = CvImageWrapper.CreateImage(new CvSize(obsSize, obsSize), 8, 3);
}
if (this._AHMCurFeature == null)
{
this._AHMCurFeature = CvImageWrapper.CreateImage(new CvSize(obsSize, obsSize), 8, 3);
}
_AHMRect.x = (int)imagePoint.X - obsSize / 2 - 10;
_AHMRect.y = (int)imagePoint.Y - obsSize / 2 - 10;;
_AHMRect.height = obsSize + 20;
_AHMRect.width = obsSize + 20;
_curFrame.cropSubImage(_AHMRect, this._AHMRealtimeObs);
unsafe
{
int dx = 0, dy = 0;
IntPtr pMinProjSqdDist = new IntPtr(&ccMinProjSqdDist);
IntPtr pTanSqdDist = new IntPtr(&ccTanSqdDist);
IntPtr pDx = new IntPtr(&dx);
IntPtr pDy = new IntPtr(&dy);
long newTicks = Environment.TickCount;
if (newTicks - ticks > updateFrequency || updateFrequency == 0)
{
cameraMouseAssist.computeRelativePos(pMinProjSqdDist, pTanSqdDist, this._AHMRealtimeObs._rawPtr, pDx, pDy, _AHMWeights);
if (CMSLogger.CanCreateLogEvent(true, false, false, "AHMLogRealtimeEvent"))
{
AHMLogRealtimeEvent lEvent = new AHMLogRealtimeEvent();
if (lEvent != null)
{
lEvent.ProjSqrdDist = (float)ccMinProjSqdDist;
lEvent.TanSqrdDist = (float)ccTanSqdDist;
CMSLogger.SendLogEvent(lEvent);
}
}
imagePoint.X = imagePoint.X + dx;
imagePoint.Y = imagePoint.Y + dy;
_current_track_points[0].x = imagePoint.X;
_current_track_points[0].y = imagePoint.Y;
ticks = newTicks;
AHMLogRealtimeFeatureImagesEvent realtimeEvent = null;
if (CMSLogger.CanCreateLogEvent(true, true, false, "AHMLogRealtimeFeatureImagesEvent"))
{
realtimeEvent = new AHMLogRealtimeFeatureImagesEvent();
}
if (this.extraDisplay || realtimeEvent != null)
{
prevExtraDisplay = true;
cameraMouseAssist.retrieveBackFeature(this._AHMBackFeature._rawPtr);
cameraMouseAssist.retrieveCurFeature(this._AHMCurFeature._rawPtr);
extraImages[0] = _AHMBackFeature.GetBitMap().Clone() as Bitmap;
extraImages[1] = _AHMCurFeature.GetBitMap().Clone() as Bitmap;
extraImages[0].RotateFlip(RotateFlipType.RotateNoneFlipX);
extraImages[1].RotateFlip(RotateFlipType.RotateNoneFlipX);
if (realtimeEvent != null)
{
realtimeEvent.SetImages(extraImages[0], extraImages[1]);
CMSLogger.SendLogEvent(realtimeEvent);
}
if (extraDisplay)
{
trackingSuiteAdapter.SendMessages(extraImages, new string[] { "Background", "Reconstruction" });
}
//trackingSuiteAdapter.SendMessages(new Bitmap[]{}, new string[] { "Current Feature", "Background Feature" });
}
else if (!extraDisplay && prevExtraDisplay)
{
prevExtraDisplay = false;
trackingSuiteAdapter.SendMessages(null, null);
}
}
}
}
}
}
catch (Exception e)
{
}
}
}
private void SetState(AHMTrackingState newState)
{
string message = null;
lock (mutex)
{
if (CMSLogger.CanCreateLogEvent(false, false, false, "AHMLogStateEvent"))
{
AHMLogStateEvent stateEvent = new AHMLogStateEvent();
if (stateEvent != null)
{
stateEvent.State = newState.ToString();
CMSLogger.SendLogEvent(stateEvent);
}
}
if (newState.Equals(AHMTrackingState.NoFeature))
{
eyeLocatorTickCount = Environment.TickCount;
lastClickPoint = Point.Empty;
imagePoint = PointF.Empty;
autoStartEnded = false;
if (!autoStartMode.Equals(AutoStartMode.None))
{
if (eyeLocator != null)
{
eyeLocator.Reset();
}
}
if (state.Equals(AHMTrackingState.AHMSetup))
{
ahmSetup.Clean();
}
else if (state.Equals(AHMTrackingState.Tracking))
{
if (extraDisplay)
{
trackingSuiteAdapter.SendMessages(null, null);
}
if (cameraMouseAssist != null)
{
cameraMouseAssist.Dispose();
cameraMouseAssist = null;
}
}
trackingSuiteAdapter.ToggleSetup(true);
state = AHMTrackingState.NoFeature;
message = "Select Feature to Start Setup";
}
else if (newState.Equals(AHMTrackingState.Feature))
{
if (state.Equals(AHMTrackingState.AHMSetup))
{
ahmSetup.Clean();
}
else if (state.Equals(AHMTrackingState.Tracking))
{
if (extraDisplay)
{
trackingSuiteAdapter.SendMessages(null, null);
}
if (cameraMouseAssist != null)
{
cameraMouseAssist.Dispose();
cameraMouseAssist = null;
}
trackingSuiteAdapter.ToggleSetup(true);
}
state = AHMTrackingState.Feature;
message = "Press Tab to Start Training";
}
else if (newState.Equals(AHMTrackingState.AHMSetup))
{
StartAHMSetup();
state = AHMTrackingState.AHMSetup;
}
else if (newState.Equals(AHMTrackingState.Tracking))
{
//if (state.Equals(AHMTrackingState.AHMSetup))
//ahmSetup.Clean();
state = AHMTrackingState.Tracking;
trackingSuiteAdapter.ToggleSetup(false);
message = ", press Tab to reset";
if (!autoStartMode.Equals(AutoStartMode.None))
{
//message = ", control will start shortly";
Thread t = new Thread(new ThreadStart(StartControlThread));
t.Start();
}
}
}
if (message != null)
{
this.trackingSuiteAdapter.SendMessage(message);
}
}
public void Update(FastBitmap img, Point eyeLocation, float timeElapsed)
{
lock ( templateMutex )
{
if (IsReady)
{
Point searchAreaStartPoint = GetSearchAreaStartPoint(eyeLocation);
try
{
img.GetIntensityMap(searchAreaStartPoint.X, searchAreaStartPoint.Y,
initialSearchintensityMapWidth, initialSearchintensityMapHeight, initialSearchIntensityMap);
Point tempPoint;
float[] refinedSearchNccScores;
SetInitialNccSearchTemplates(eyeLocation);
refinedSearchNccScores = openEyeTemplate.GetTopNccScores(initialSearchTemplates, refinedSearchIndices);
inputOpenEyeNcc = float.NegativeInfinity;
for (int i = 0; i < refinedSearchIndices.Length; ++i)
{
FastBitmap.NccTemplate tempTemplate = initialSearchTemplates[refinedSearchIndices[i]];
float tempNcc = img.GetNccScore(openEyeTemplate, new Rectangle(tempTemplate.X - (stepAmount - 1),
tempTemplate.Y - (stepAmount - 1), (2 * stepAmount) - 1, (2 * stepAmount) - 1), out tempPoint);
if (tempNcc > inputOpenEyeNcc)
{
inputOpenEyeNcc = tempNcc;
eyeOpenLoc = tempPoint;
}
}
refinedSearchNccScores = closedEyeTemplate.GetTopNccScores(initialSearchTemplates, refinedSearchIndices);
inputClosedEyeNcc = float.NegativeInfinity;
for (int i = 0; i < refinedSearchIndices.Length; ++i)
{
FastBitmap.NccTemplate tempTemplate = initialSearchTemplates[refinedSearchIndices[i]];
float tempNcc = img.GetNccScore(closedEyeTemplate, new Rectangle(tempTemplate.X - (stepAmount - 1),
tempTemplate.Y - (stepAmount - 1), (2 * stepAmount) - 1, (2 * stepAmount) - 1), out tempPoint);
if (tempNcc > inputClosedEyeNcc)
{
inputClosedEyeNcc = tempNcc;
eyeClosedLoc = tempPoint;
}
}
}
catch (ArgumentOutOfRangeException)
{
// Set as eye open since this performs no action, set open eye location as estimated location
inputOpenEyeNcc = 1;
eyeOpenLoc = eyeLocation;
inputClosedEyeNcc = 0;
}
}
else
{
if (!xDistanceBetweenEyesSet)
{
throw new InvalidOperationException("Must call SetXDistanceBetweenEyes before calling Update");
}
try
{
initializationTemplates[nextInitializationImageIndex] = img.GetNccTemplate(GetTemplateRectange(eyeLocation));
}
catch (ArgumentOutOfRangeException)
{
return;
}
if (closeEyeMessageTimer > 0)
{
closeEyeMessageTimer -= timeElapsed;
inputOpenEyeNcc = img.GetNccScore(openEyeTemplate, GetFindingTemplateSearchArea(eyeLocation), 1, out eyeOpenLoc);
}
else
{
if (openEyeTemplate == null)
{
for (int i = 0; i < nextInitializationImageIndex; ++i)
{
initializationNccScores[i, nextInitializationImageIndex]
= initializationNccScores[nextInitializationImageIndex, i]
= initializationTemplates[i].GetNcc(initializationTemplates[nextInitializationImageIndex]);
}
}
else
{
inputOpenEyeNcc = img.GetNccScore(openEyeTemplate, GetFindingTemplateSearchArea(eyeLocation), 1, out eyeOpenLoc);
initializationNccScores[nextInitializationImageIndex, 0]
= openEyeTemplate.GetNcc(initializationTemplates[nextInitializationImageIndex]);
}
initializationNccScores[nextInitializationImageIndex, nextInitializationImageIndex] = 1;
nextInitializationImageIndex++;
if (InitializationImageCount == nextInitializationImageIndex)
{
if (openEyeTemplate == null)
{
int bestIndex = GetBestRepresentativeTemplateIndex();
openEyeTemplate = initializationTemplates[bestIndex];
cmsTrackingSuiteAdapter.SendMessage(CloseEyesMessage);
closeEyeMessageTimer = CloseEyeMessageStartTime;
if (CMSLogger.CanCreateLogEvent(false, true, false, "BlinkLinkLogTemplatesEvent"))
{
BlinkLinkLogTemplatesEvent logEvent = new BlinkLinkLogTemplatesEvent();
logEvent.IsOpenTemplates = true;
logEvent.SelectedTemplate = bestIndex;
logEvent.SetTemplates(initializationTemplates);
CMSLogger.SendLogEvent(logEvent);
}
}
else
{
float nccScore;
int bestIndex = GetFurtherestFromEyeOpen(out nccScore);
FastBitmap.NccTemplate representativeTemplate = initializationTemplates[bestIndex];
if (nccScore <= ClassDifferenceThreshold)
{
closedEyeTemplate = representativeTemplate;
if (CMSLogger.CanCreateLogEvent(false, true, false, "BlinkLinkLogTemplatesEvent"))
{
BlinkLinkLogTemplatesEvent logEvent = new BlinkLinkLogTemplatesEvent();
logEvent.IsOpenTemplates = false;
logEvent.SelectedTemplate = bestIndex;
logEvent.SetTemplates(initializationTemplates);
CMSLogger.SendLogEvent(logEvent);
}
}
}
nextInitializationImageIndex = 0;
}
}
}
}
}
private void SetState(AHMTrackingState newState)
{
string message = null;
lock (mutex)
{
if (CMSLogger.CanCreateLogEvent(false, false, false, "AHMLogStateEvent"))
{
AHMLogStateEvent stateEvent = new AHMLogStateEvent();
if (stateEvent != null)
{
stateEvent.State = newState.ToString();
CMSLogger.SendLogEvent(stateEvent);
}
}
if (newState.Equals(AHMTrackingState.NoFeature))
{
autoStartEnded = false;
eyeLocatorTickCount = Environment.TickCount;
lastClickPoint = Point.Empty;
imagePoint = PointF.Empty;
if (eyeLocator != null)
{
eyeLocator.Reset();
}
if (state.Equals(AHMTrackingState.AHMSetup))
{
ahmSetup.Clean();
}
else if (state.Equals(AHMTrackingState.Tracking))
{
for (int i = 0; i < cameraMouseAssists.Length; i++)
{
if (cameraMouseAssists[i] != null)
{
cameraMouseAssists[i].Dispose();
cameraMouseAssists[i] = null;
}
}
}
trackingSuiteAdapter.ToggleSetup(true);
state = AHMTrackingState.NoFeature;
message = "Select Feature to Start Setup";
}
else if (newState.Equals(AHMTrackingState.AHMSetup))
{
StartAHMSetup();
state = AHMTrackingState.AHMSetup;
}
else if (newState.Equals(AHMTrackingState.Tracking))
{
//if (state.Equals(AHMTrackingState.AHMSetup))
//ahmSetup.Clean();
state = AHMTrackingState.Tracking;
//trackingSuiteAdapter.ToggleSetup(false);
//message = ", Press Tab to reset";
//trackingSuiteAdapter.ToggleControl(true);
}
}
if (message != null)
{
this.trackingSuiteAdapter.SendMessage(message);
}
}
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