public UserSecurityType GetSingle(Int32 Id) { UserSecurityType obj = new UserSecurityType(); try { string query = "select * from user_security_types where ID = " + Id + ""; SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection); mySQLDBConnect.OpenConnection(); DataTable dt = new DataTable(); SqlDataAdapter dA = new SqlDataAdapter(cmd); dA.Fill(dt); dA.Dispose(); obj = (from x in dt.AsEnumerable() select new UserSecurityType { Id = x.Field <Int32>("id"), Name = x.Field <String>("name"), CreatedBy = x.Field <Int32>("created_by"), CreatedOn = x.Field <DateTime>("created_on"), UpdatedBy = x.Field <Int32?>("updated_by") == null ? 0 : x.Field <Int32>("updated_by"), UpdatedOn = x.Field <DateTime?>("updated_on"), Status = x.Field <Int32>("status"), }).ToList().FirstOrDefault(); mySQLDBConnect.CloseConnection(); } catch (Exception ex) { Console.Write(ex.ToString()); } return(obj); }
public UserSecurityType UpdateData(UserSecurityType obj) { try { obj = IUserSecurityTypeRepo.UpdateData(obj); } catch (Exception ex) { Console.Write(ex.ToString()); } return(obj); }
public UserSecurityType DeleteData(Int32 Id) { UserSecurityType obj = new UserSecurityType(); try { obj = IUserSecurityTypeRepo.DeleteData(Id); } catch (Exception ex) { Console.Write(ex.ToString()); } return(obj); }
public UserSecurityType UpdateData(UserSecurityType obj) { try { string query = obj.ObjectToQuery <UserSecurityType>("update"); SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection); mySQLDBConnect.OpenConnection(); cmd.ExecuteNonQuery(); mySQLDBConnect.CloseConnection(); } catch (Exception ex) { Console.Write(ex.ToString()); } return(obj); }
public UserSecurityType PostData(UserSecurityType obj) { try { string query = obj.ObjectToQuery <UserSecurityType>("insert") + "SELECT SCOPE_IDENTITY()"; SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection); mySQLDBConnect.OpenConnection(); // cmd.ExecuteNonQuery(); obj.Id = Convert.ToInt32(cmd.ExecuteScalar()); mySQLDBConnect.CloseConnection(); } catch (Exception ex) { Console.Write(ex.ToString()); } return(obj); }
public Int32 DeleteBulkData(List <Int32> Ids) { Int32 result = 0; try { string query = ""; Ids.ForEach(Id => { UserSecurityType obj = GetSingle(Id); query += obj.ObjectToQuery <UserSecurityType>("update"); }); SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection); mySQLDBConnect.OpenConnection(); result = cmd.ExecuteNonQuery(); mySQLDBConnect.CloseConnection(); } catch (Exception ex) { Console.Write(ex.ToString()); } return(result); }