public static bool deleteEmployee(string searchID) { bool status; var response = ConnectionToES.EsClient().Delete<DocumentAttributes>(searchID, d => d .Index("employee") .Type("doc")); if (response.IsValid) { status = true; } else { status = false; } return status; }
public static Tuple<string, string, string, string> GetEmployeeByID(string ID) { string id = ""; string name = ""; string address = ""; string MobileNo = ""; var response = ConnectionToES.EsClient().Search<DocumentAttributes>(s => s .Index("employee") .Type("doc") .Query(q => q.Term(t => t.Field("_id").Value(ID)))); //Search based on employeeID foreach (var hit in response.Hits) { id = hit.Id.ToString(); name = Convert.ToString(hit.Source.name); address = Convert.ToString(hit.Source.address); MobileNo = Convert.ToString(hit.Source.MobileNo); } return Tuple.Create(id, name, address, MobileNo); }
public static DataTable getAllDocument() { DataTable dataTable = new DataTable("Employee"); dataTable.Columns.Add("ID", typeof(string)); dataTable.Columns.Add("Name", typeof(string)); dataTable.Columns.Add("address", typeof(string)); dataTable.Columns.Add("MobileNo", typeof(string)); var res = ConnectionToES.EsClient().Search<Employee>(s => s .Index("employee") .Type("doc") .From(0) .Size(1000) .Query(q => q.MatchAll())); foreach (var hit in res.Hits) { dataTable.Rows.Add(hit.Id.ToString(), Convert.ToString(hit.Source.name), Convert.ToString(hit.Source.address), Convert.ToString(hit.Source.MobileNo)); } return dataTable; }
public static bool insertEmployee(int ID, string Name, string Address, string MobileNO) { bool status; var myJson = new { name = Name, address = Address, MobileNo = MobileNO }; var response = ConnectionToES.EsClient().Index(myJson, i => i.Index("employee").Type("doc").Id(ID)); if (response.IsValid) { status = true; } else { status = false; } return status; }
public static bool updateEmployee(int ID, string Name, string Address, string MobileNO) { bool status; var response = ConnectionToES.EsClient().Update<DocumentAttributes, UpdateDocumentAttributes>(ID, d => d .Index("employee") .Type("doc") .Doc(new UpdateDocumentAttributes { name = Name, address = Address, MobileNo = MobileNO })); if (response.IsValid) { status = true; } else { status = false; } return status; }