Ejemplo n.º 1
0
 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");
        }
Ejemplo n.º 3
0
 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);
        }
Ejemplo n.º 6
0
        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);
            }
        }
Ejemplo n.º 7
0
        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;
                }
            }
        }
Ejemplo n.º 8
0
        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);
        }
Ejemplo n.º 9
0
 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
         });
     }
 }
Ejemplo n.º 10
0
 public FacultyWorkInfoRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory)
 {
     this._Logger = _Logger;
     this._dbContextFactory = _DbContextFactory;
 }
Ejemplo n.º 11
0
 public Alumini.Core.db_NewsRooms UpdateNewRooms(Alumini.Core.db_NewsRooms obj)
 {
     return _NewsRoomRepo.UpdateNewRooms(obj);
 }
Ejemplo n.º 12
0
 public FacultyWorkInfoService(Alumini.Logger.ILogger _logger, IFacultyWorkInfoRepository _facultyWorkInfoRepo)
 {
     this._logger = _logger;
     this._facultyWorkInfoRepo = _facultyWorkInfoRepo;
     objSubscriberClasses = new SubscriberClasses();
 }
Ejemplo n.º 13
0
 public EditAluminiFragment(Alumini alumini)
 {
     thisAlunini = alumini;
 }
Ejemplo n.º 14
0
 public Alumini.Core.db_NewsRooms Create(Alumini.Core.db_NewsRooms obj)
 {
     return _NewsRoomRepo.Create(obj);
 }
Ejemplo n.º 15
0
 public StateDistrictCityRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory)
 {
     this._Logger = _Logger;
     this._dbContextFactory = _DbContextFactory;
 }
Ejemplo n.º 16
0
 public EventTicketTypesRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory)
 {
     this._Logger = _Logger;
     this._dbContextFactory = _DbContextFactory;
 }
Ejemplo n.º 17
0
 public CoursesRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory)
 {
     this._Logger = _Logger;
     this._dbContextFactory = _DbContextFactory;
 }
Ejemplo n.º 18
0
 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));
 }
Ejemplo n.º 20
0
 public MemoriesServices(Alumini.Logger.ILogger _logger, IMemoriesRepository _genericMethodsRepo)
 {
     this._logger = _logger;
     this._genericMethodsRepo = _genericMethodsRepo;
 }
Ejemplo n.º 21
0
 public CoursesService(Alumini.Logger.ILogger _logger, ICoursesRepository _coursesRepo)
 {
     this._logger = _logger;
     this._coursesRepo = _coursesRepo;
 }
Ejemplo n.º 22
0
 public int DeleteAlumini(Alumini theAlumini)
 {
     return(AluminiIntegration.DeleteAlumini(theAlumini));
 }
Ejemplo n.º 23
0
 public int UpdateAlumini(Alumini theAlumini)
 {
     return(AluminiIntegration.UpdateAlumini(theAlumini));
 }
Ejemplo n.º 24
0
 public int InsertAlumini(Alumini theAlumini)
 {
     return(AluminiIntegration.InsertAlumini(theAlumini));
 }
Ejemplo n.º 25
0
 public UserDetailsViewRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory)
 {
     this._Logger = _Logger;
     this._dbContextFactory = _DbContextFactory;
 }
Ejemplo n.º 26
0
 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));
 }
Ejemplo n.º 28
0
 public UserSelectionEventsRepository(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory)
 {
     this._Logger = _Logger;
     this._dbContextFactory = _DbContextFactory;
 }
Ejemplo n.º 29
0
 public NewsRoomRepositroy(Alumini.Logger.ILogger _Logger, IDbConnectionFactory _DbContextFactory)
 {
     this._Logger = _Logger;
     this._dbContextFactory = _DbContextFactory;
 }