public static void InsertData(string Username, string Password, int Role, int Division) { PenjaminanDatasetTableAdapters.UserProfileTableAdapter ta = new PenjaminanDatasetTableAdapters.UserProfileTableAdapter(); try { var data = ta.validasiEmail(Username); if (data == 0) { ta.Insert(Username, Password, Role.ToString(), Division.ToString(), 1, DateTime.Now, 1, DateTime.Now, 0); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static void SoftDeleteData(int id) { PenjaminanDatasetTableAdapters.UserProfileTableAdapter ta = new PenjaminanDatasetTableAdapters.UserProfileTableAdapter(); PenjaminanDataset.UserProfileDataTable dt = ta.GetDataUserProfileByID(id); try { if (dt != null) { dt[0].deleted = 1; ta.Update(dt); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static PenjaminanDataset.UserProfileRow getUserLogin(string username, string password) { PenjaminanDatasetTableAdapters.UserProfileTableAdapter ta = new PenjaminanDatasetTableAdapters.UserProfileTableAdapter(); PenjaminanDataset.UserProfileDataTable dt = new PenjaminanDataset.UserProfileDataTable(); PenjaminanDataset.UserProfileRow dr = null; try { ta.FillUserProfileByUsernamePassword(dt, username, password); if (dt.Count > 0) { dr = dt[0]; } return(dr); } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static PenjaminanDataset.UserProfileRow selectUserProfileByID(int id) { PenjaminanDatasetTableAdapters.UserProfileTableAdapter ta = new PenjaminanDatasetTableAdapters.UserProfileTableAdapter(); PenjaminanDataset.UserProfileDataTable dt = new PenjaminanDataset.UserProfileDataTable(); PenjaminanDataset.UserProfileRow dr = null; try { ta.FillUserProfileByID(dt, id); if (dt.Count > 0) { dr = dt[0]; } return(dr); } catch (Exception ex) { throw new ApplicationException("Failed to load user profile data : " + ex.Message); } }
public static void UpdateData(int Id, string Username, string Password, int Role, int Division) { PenjaminanDatasetTableAdapters.UserProfileTableAdapter ta = new PenjaminanDatasetTableAdapters.UserProfileTableAdapter(); PenjaminanDataset.UserProfileDataTable dt = ta.GetDataUserProfileByID(Id); try { if (dt != null) { dt[0].username = Username; dt[0].password = Password; dt[0].role = Role.ToString(); dt[0].division = Division.ToString(); dt[0].lastupdatedby = 1; dt[0].lastupdateddate = DateTime.Now; ta.Update(dt); } } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }