public EducationalDetailService(Alumini.Logger.ILogger _logger, IEducationalDetailRepository _educationalDetailRepo, IUserInfoRepository _userDetailsRepo) { this._logger = _logger; this._educationalDetailRepo = _educationalDetailRepo; this._userDetailsRepo = _userDetailsRepo; objSubscriberClasses = new SubscriberClasses(); }
private void Adapter_ItemLongClick(object sender, AluminiAdapterClickEventArgs e) { Alumini thisAlumini = AluminiList[e.Position]; EditAluminiFragment editAluminiFragment = new EditAluminiFragment(thisAlumini); var trans = SupportFragmentManager.BeginTransaction(); editAluminiFragment.Show(trans, "edit"); }
public Alumini.Core.db_NewsRooms Create(Alumini.Core.db_NewsRooms obj) { using (var context = _dbContextFactory.CreateConnection()) { context.db_NewsRooms.Add(obj); context.SaveChanges(); return obj; } }
public static List <Alumini> GetAluminiList() { List <Alumini> AluminiList = new List <Alumini>(); DataTable AluminiTable = AluminiDataAccess.GetInstance.GetAluminiList(); foreach (DataRow dr in AluminiTable.Rows) { Alumini TheAlumini = DataRowToObject(dr); AluminiList.Add(TheAlumini); } return(AluminiList); }
public static Alumini DataRowToObject(DataRow dr) { Alumini TheAlumini = new Alumini(); TheAlumini.AluminiID = int.Parse(dr["AluminiID"].ToString()); TheAlumini.AluminiCode = dr["AluminiCode"].ToString(); TheAlumini.Salutation = dr["Salutation"].ToString(); TheAlumini.AluminiName = dr["AluminiName"].ToString(); TheAlumini.FatherName = dr["FatherName"].ToString(); TheAlumini.MotherName = dr["MotherName"].ToString(); TheAlumini.Gender = dr["Gender"].ToString(); TheAlumini.Caste = dr["Caste"].ToString(); TheAlumini.Status = dr["Status"].ToString(); TheAlumini.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString()).ToString(MicroConstants.DateFormat); TheAlumini.DateOfAdmission = DateTime.Parse(dr["DateOfAdmission"].ToString()).ToString(MicroConstants.DateFormat); TheAlumini.DateOfLeaving = DateTime.Parse(dr["DateOfLeaving"].ToString()).ToString(MicroConstants.DateFormat); TheAlumini.Age = int.Parse(dr["Age"].ToString()); TheAlumini.Address_Present_TownOrCity = dr["Address_Present_TownOrCity"].ToString(); TheAlumini.Address_Present_Landmark = dr["Address_Present_Landmark"].ToString(); TheAlumini.Address_Present_PinCode = dr["Address_Present_PinCode"].ToString(); TheAlumini.Address_Present_DistrictID = int.Parse(dr["Address_Present_DistrictID"].ToString()); if (dr["Address_Present_DistrictID"].ToString() != "") { TheAlumini.Address_Present_DistrictID = int.Parse(dr["Address_Present_DistrictID"].ToString()); TheAlumini.Address_Present_DistrictName = dr["Address_Present_DistrictName"].ToString(); } TheAlumini.Address_Present_StateName = dr["Address_Present_StateName"].ToString(); TheAlumini.Address_Present_CountryName = dr["Address_Present_CountryName"].ToString(); TheAlumini.Address_Permanent_TownOrCity = dr["Address_Permanent_TownOrCity"].ToString(); TheAlumini.Address_Permanent_Landmark = dr["Address_Permanent_Landmark"].ToString(); TheAlumini.Address_Permanent_PinCode = dr["Address_Permanent_PinCode"].ToString(); TheAlumini.Address_Permanent_DistrictID = int.Parse(dr["Address_Permanent_DistrictID"].ToString()); if (dr["Address_Permanent_DistrictID"].ToString() != "") { TheAlumini.Address_Permanent_DistrictID = int.Parse(dr["Address_Permanent_DistrictID"].ToString()); TheAlumini.Address_Permanent_DistrictName = dr["Address_Permanent_DistrictName"].ToString(); } TheAlumini.Address_Permanent_StateName = dr["Address_Permanent_StateName"].ToString(); TheAlumini.Address_Permanent_CountryName = dr["Address_Permanent_CountryName"].ToString(); TheAlumini.PhoneNumber = dr["PhoneNumber"].ToString(); TheAlumini.Mobile = dr["Mobile"].ToString(); TheAlumini.EMailID = dr["EmailID"].ToString(); TheAlumini.OfficeID = int.Parse(dr["OfficeID"].ToString()); return(TheAlumini); }
public int DeleteAlumini(Alumini theAlumini) { int ReturnValue = 0; using (SqlCommand DeleteCommand = new SqlCommand()) { DeleteCommand.CommandType = CommandType.StoredProcedure; DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; DeleteCommand.Parameters.Add(GetParameter("@AluminiID", SqlDbType.Int, theAlumini.AluminiID)); DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, 1)); DeleteCommand.CommandText = "pICAS_Alumini_Delete"; ExecuteStoredProcedure(DeleteCommand); ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public Alumini.Core.Event_UserSelections Create(Alumini.Core.Event_UserSelections obj) { using (var context = _dbContextFactory.CreateConnection()) { try { obj = context.Event_UserSelections.Add(obj); context.SaveChanges(); return obj; } catch (Exception ex) { _Logger.Error(ex.Message, ex); throw ex; } } }
public int UpdateAlumini(Alumini theAlumini) { int ReturnValue = 0; using (SqlCommand UpdateCommand = new SqlCommand()) { UpdateCommand.CommandType = CommandType.StoredProcedure; UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; UpdateCommand.Parameters.Add(GetParameter("@AluminiID", SqlDbType.Int, theAlumini.AluminiID)); UpdateCommand.Parameters.Add(GetParameter("@AluminiCode", SqlDbType.VarChar, theAlumini.AluminiCode)); UpdateCommand.Parameters.Add(GetParameter("@Salutation", SqlDbType.VarChar, theAlumini.Salutation)); UpdateCommand.Parameters.Add(GetParameter("@AluminiName", SqlDbType.VarChar, theAlumini.AluminiName)); UpdateCommand.Parameters.Add(GetParameter("@FatherName", SqlDbType.VarChar, theAlumini.FatherName)); UpdateCommand.Parameters.Add(GetParameter("@MotherName", SqlDbType.VarChar, theAlumini.MotherName)); UpdateCommand.Parameters.Add(GetParameter("@Gender", SqlDbType.VarChar, theAlumini.Gender)); UpdateCommand.Parameters.Add(GetParameter("@Caste", SqlDbType.VarChar, theAlumini.Caste)); UpdateCommand.Parameters.Add(GetParameter("@Status", SqlDbType.VarChar, theAlumini.Status)); UpdateCommand.Parameters.Add(GetParameter("@DateOfBirth", SqlDbType.DateTime, theAlumini.@DateOfBirth)); UpdateCommand.Parameters.Add(GetParameter("@DateOfAdmission", SqlDbType.DateTime, theAlumini.DateOfAdmission)); UpdateCommand.Parameters.Add(GetParameter("@DateOfLeaving", SqlDbType.DateTime, theAlumini.DateOfLeaving)); UpdateCommand.Parameters.Add(GetParameter("@Age", SqlDbType.Int, theAlumini.Age)); UpdateCommand.Parameters.Add(GetParameter("@Address_Present_TownOrCity", SqlDbType.VarChar, theAlumini.Address_Present_TownOrCity)); UpdateCommand.Parameters.Add(GetParameter("@Address_Present_Landmark", SqlDbType.VarChar, theAlumini.Address_Present_Landmark)); UpdateCommand.Parameters.Add(GetParameter("@Address_Present_PinCode", SqlDbType.VarChar, theAlumini.Address_Present_PinCode)); UpdateCommand.Parameters.Add(GetParameter("@Address_Present_DistrictID", SqlDbType.Int, theAlumini.Address_Present_DistrictID)); UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_TownOrCity", SqlDbType.VarChar, theAlumini.Address_Permanent_TownOrCity)); UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_Landmark", SqlDbType.VarChar, theAlumini.Address_Permanent_Landmark)); UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_PinCode", SqlDbType.VarChar, theAlumini.Address_Permanent_PinCode)); UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_DistrictID", SqlDbType.Int, theAlumini.Address_Permanent_DistrictID)); UpdateCommand.Parameters.Add(GetParameter("@PhoneNumber", SqlDbType.VarChar, theAlumini.PhoneNumber)); UpdateCommand.Parameters.Add(GetParameter("@Mobile", SqlDbType.VarChar, theAlumini.Mobile)); UpdateCommand.Parameters.Add(GetParameter("@EmailID", SqlDbType.VarChar, theAlumini.EMailID)); UpdateCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, 44)); UpdateCommand.Parameters.Add(GetParameter("@CompanyID", SqlDbType.Int, 21)); UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, 11)); UpdateCommand.CommandText = "pICAS_Alumini_Update"; ExecuteStoredProcedure(UpdateCommand); ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString()); } return(ReturnValue); }
public void OnDataChange(DataSnapshot snapshot) { if (snapshot.Value != null) { var child = snapshot.Children.ToEnumerable <DataSnapshot>(); aluminiList.Clear(); foreach (DataSnapshot aluminiData in child) { Alumini alumini = new Alumini(); alumini.ID = aluminiData.Key; alumini.FullName = aluminiData.Child("fullname").Value.ToString(); alumini.Department = aluminiData.Child("department").Value.ToString(); alumini.Status = aluminiData.Child("status").Value.ToString(); alumini.Set = aluminiData.Child("set").Value.ToString(); aluminiList.Add(alumini); } AluminRetrived.Invoke(this, new AluminDataEventArgs { Alumini = aluminiList }); } }
public FacultyWorkInfoRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory) { this._Logger = _Logger; this._dbContextFactory = _DbContextFactory; }
public Alumini.Core.db_NewsRooms UpdateNewRooms(Alumini.Core.db_NewsRooms obj) { return _NewsRoomRepo.UpdateNewRooms(obj); }
public FacultyWorkInfoService(Alumini.Logger.ILogger _logger, IFacultyWorkInfoRepository _facultyWorkInfoRepo) { this._logger = _logger; this._facultyWorkInfoRepo = _facultyWorkInfoRepo; objSubscriberClasses = new SubscriberClasses(); }
public EditAluminiFragment(Alumini alumini) { thisAlunini = alumini; }
public Alumini.Core.db_NewsRooms Create(Alumini.Core.db_NewsRooms obj) { return _NewsRoomRepo.Create(obj); }
public StateDistrictCityRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory) { this._Logger = _Logger; this._dbContextFactory = _DbContextFactory; }
public EventTicketTypesRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory) { this._Logger = _Logger; this._dbContextFactory = _DbContextFactory; }
public CoursesRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory) { this._Logger = _Logger; this._dbContextFactory = _DbContextFactory; }
public Alumini.Core.db_NewsRooms UpdateNewRooms(Alumini.Core.db_NewsRooms obj) { using (var context = _dbContextFactory.CreateConnection()) { db_NewsRooms News = context.db_NewsRooms.Where(x => x.NewRoomId == obj.NewRoomId && x.Status == true).FirstOrDefault(); News.Title = obj.Title; if (obj.Image != "") { News.Image = obj.Image; } News.Description = obj.Description; News.UpdatedOn = DateTime.Now; context.SaveChanges(); return obj; } }
public static int DeleteAlumini(Alumini theAlumini) { return(AluminiDataAccess.GetInstance.DeleteAlumini(theAlumini)); }
public MemoriesServices(Alumini.Logger.ILogger _logger, IMemoriesRepository _genericMethodsRepo) { this._logger = _logger; this._genericMethodsRepo = _genericMethodsRepo; }
public CoursesService(Alumini.Logger.ILogger _logger, ICoursesRepository _coursesRepo) { this._logger = _logger; this._coursesRepo = _coursesRepo; }
public int DeleteAlumini(Alumini theAlumini) { return(AluminiIntegration.DeleteAlumini(theAlumini)); }
public int UpdateAlumini(Alumini theAlumini) { return(AluminiIntegration.UpdateAlumini(theAlumini)); }
public int InsertAlumini(Alumini theAlumini) { return(AluminiIntegration.InsertAlumini(theAlumini)); }
public UserDetailsViewRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory) { this._Logger = _Logger; this._dbContextFactory = _DbContextFactory; }
public Alumini.Core.db_Memories_Info Create(Alumini.Core.db_Memories_Info obj) { return _genericMethodsRepo.Create(obj); }
public static int InsertAlumini(Alumini theAlumini) { return(AluminiDataAccess.GetInstance.InsertAlumini(theAlumini)); }
public UserSelectionEventsRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory) { this._Logger = _Logger; this._dbContextFactory = _DbContextFactory; }
public NewsRoomRepositroy(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory) { this._Logger = _Logger; this._dbContextFactory = _DbContextFactory; }