}//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