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;
}
