public ActionResult InsertExec(string StrPosition, int IntMemberID, int IntDateID, int IntClubID)
{
Exec newExec = new Exec
{
StrPosition = StrPosition,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID),
IntDateID = IntDateID,
Date = DatesDAL.GetDate(IntDateID),
IntClubID = IntClubID,
Club = ClubsDAL.GetClub(IntClubID)
};
bool success = ExecDAL.InsertExec(newExec);
ExecVM model = new ExecVM()
{
LstExec = ExecDAL.GetAllExec(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllClubs = ClubsDAL.GetAllClubs(),
LstAllDates = DatesDAL.GetAllDates()
};
return(PartialView("CRUDPartials/_Exec", model));
}
protected void gvMembers_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteMembers")
{
MembersDAL membersDAL = new MembersDAL();
membersDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' });
string pin = commandArgs[0];
string empid = commandArgs[1];
string compname = commandArgs[2];
if (pin != null)
{
membersDAL.DeleteMembers(pin, null, null);
GetMembers(null, null, null);
}
else if (empid != null)
{
membersDAL.DeleteMembers(null, empid, null);
GetMembers(null, null, null);
}
else if (pin != null && empid != null)
{
membersDAL.DeleteMembers(null, null, compname);
GetMembers(null, null, null);
}
}
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{//ButtonSearch_Click
MembersDAL membersDAL = new MembersDAL();
membersDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
if (CompanyDDL.SelectedValue != "")
{
comp = CompanyDDL.SelectedValue;
GetMembers(null, comp, null);
}
else if (tbSearchEmpID.Text != "")
{
string empid = tbSearchEmpID.Text;
GetMembers(empid, comp, null);
}
else if (tbSearchName.Text != "")
{
string name = tbSearchName.Text;
GetMembers(null, comp, name);
}
else
{
GetMembers(null, null, null);
}
}
private void ReadWriteCSVFile()
{
string date = System.DateTime.Now.ToString("ddMMyyhhmmss");
if (File.Exists(Server.MapPath(uppath)))
{
StreamReader sr = new StreamReader(Server.MapPath(uppath));
StreamWriter write = new StreamWriter(Server.MapPath(output));
CsvReader csvread = new CsvReader(sr);
csvread.Configuration.PrepareHeaderForMatch = header => header.Replace(" ", "").Replace("/", string.Empty).Replace("#", string.Empty).Replace(".", string.Empty);
//csvread.Configuration.TypeConverterOptionsCache.GetOptions<DateTime?>().NullValues.Add("NULL");
CsvWriter csw = new CsvWriter(write);
IEnumerable <Members> record = csvread.GetRecords <Members>();
foreach (var rec in record) // Each record will be fetched and printed on the screen
{
//csvread.Configuration.TypeConverterOptionsCache.GetOptions<DateTime?>().NullValues.Add("NULL");
csw.WriteRecord <Members>(rec);
csw.NextRecord();
MembersDAL membersDAL = new MembersDAL();
membersDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
membersDAL.InsertMembers(rec);
}
sr.Close();
write.Close();//close file streams
if (File.Exists(Server.MapPath(uppath)))
{
File.Delete(Server.MapPath(uppath));
}
}
}
public static List <MemberAddonProductsModel> SelectMembarAddonProductBypkiMemberProductID(Guid PkInoteID)
{
// return MembersDAL.SelectMembarAddonProductBypkiMemberProductID(PkInoteID);
DataTable dr = MembersDAL.SelectMembarAddonProductBypkiMemberProductIDdt(PkInoteID);
return(FuneralHelper.DataTableMapToList <MemberAddonProductsModel>(dr));
}
public static MembersModel GetMemberByID(int ID, Guid ParlourId)
{
//SqlDataReader dr = MembersDAL.GetMemberByID(ID, ParlourId);
//return FuneralHelper.DataReaderMapToList<MembersModel>(dr).FirstOrDefault();
DataTable dr = MembersDAL.GetMemberByIDdt(ID, ParlourId);
return(FuneralHelper.DataTableMapToList <MembersModel>(dr).FirstOrDefault());
}
protected void gvMembers_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
MembersDAL membersDAL = new MembersDAL();
membersDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
Members Mem = new Members();
Mem.Pin = (gvMembers.Rows[e.RowIndex].FindControl("lblPinEdit") as Label).Text;
Mem.EmployeeNumber = (gvMembers.Rows[e.RowIndex].FindControl("lblEmployeeNumberEdit") as Label).Text;
Mem.FirstName = (gvMembers.Rows[e.RowIndex].FindControl("tbFirstName") as TextBox).Text;
Mem.LastName = (gvMembers.Rows[e.RowIndex].FindControl("tbLastName") as TextBox).Text;
Mem.Email = (gvMembers.Rows[e.RowIndex].FindControl("tbEmail") as TextBox).Text;
Mem.JobTitle = (gvMembers.Rows[e.RowIndex].FindControl("tbJobTitle") as TextBox).Text;
DateTime?HireDate = ((gvMembers.Rows[e.RowIndex].FindControl("tbHireDate") as TextBox).Text == "") ? (DateTime?)null : Convert.ToDateTime((gvMembers.Rows[e.RowIndex].FindControl("tbHireDate") as TextBox).Text);
Mem.HireDate = HireDate;
DateTime?BirthDate = ((gvMembers.Rows[e.RowIndex].FindControl("tbBirthDate") as TextBox).Text == "") ? (DateTime?)null : Convert.ToDateTime((gvMembers.Rows[e.RowIndex].FindControl("tbBirthDate") as TextBox).Text);
Mem.BirthDate = BirthDate;
Mem.Address1 = (gvMembers.Rows[e.RowIndex].FindControl("tbAddress1") as TextBox).Text;
Mem.Address2 = (gvMembers.Rows[e.RowIndex].FindControl("tbAddress2") as TextBox).Text;
Mem.City = (gvMembers.Rows[e.RowIndex].FindControl("tbCity") as TextBox).Text;
Mem.ProvinceState = (gvMembers.Rows[e.RowIndex].FindControl("tbProvinceState") as TextBox).Text;
Mem.Country = (gvMembers.Rows[e.RowIndex].FindControl("tbCountry") as TextBox).Text;
Mem.PostalCode = (gvMembers.Rows[e.RowIndex].FindControl("tbPostalCode") as TextBox).Text;
Mem.TelephoneAreaCode = (gvMembers.Rows[e.RowIndex].FindControl("tbTelephoneAreaCode") as TextBox).Text;
Mem.TelephoneNumber = (gvMembers.Rows[e.RowIndex].FindControl("tbTelephoneNumber") as TextBox).Text;
Mem.TelephoneCountryCode = (gvMembers.Rows[e.RowIndex].FindControl("tbTelephoneCountryCode") as TextBox).Text;
Mem.LanguageCode = (gvMembers.Rows[e.RowIndex].FindControl("tbLanguageCode") as TextBox).Text;
Mem.DepartmentCode = (gvMembers.Rows[e.RowIndex].FindControl("tbDepartmentCode") as TextBox).Text;
Mem.DepartmentName = (gvMembers.Rows[e.RowIndex].FindControl("tbDepartmentName") as TextBox).Text;
Mem.AccessGroups = (gvMembers.Rows[e.RowIndex].FindControl("tbAccessGroups") as TextBox).Text;
Mem.EmployeeType = (gvMembers.Rows[e.RowIndex].FindControl("tbEmployeeType") as TextBox).Text;
DateTime?DeletionDate = ((gvMembers.Rows[e.RowIndex].FindControl("tbDeletionDate") as TextBox).Text == "") ? (DateTime?)null : Convert.ToDateTime((gvMembers.Rows[e.RowIndex].FindControl("tbDeletionDate") as TextBox).Text);
Mem.DeletionDate = DeletionDate;
Mem.Password = (gvMembers.Rows[e.RowIndex].FindControl("tbPassword") as TextBox).Text;
Mem.DisableLogin = (gvMembers.Rows[e.RowIndex].FindControl("tbDisableLogin") as TextBox).Text;
Mem.DisableEarn = (gvMembers.Rows[e.RowIndex].FindControl("tbDisableEarn") as TextBox).Text;
Mem.Username = (gvMembers.Rows[e.RowIndex].FindControl("tbUsername") as TextBox).Text;
Mem.FnameAR = (gvMembers.Rows[e.RowIndex].FindControl("tbFnameAR") as TextBox).Text;
Mem.LnameAR = (gvMembers.Rows[e.RowIndex].FindControl("tbLnameAR") as TextBox).Text;
Mem.PositionAr = (gvMembers.Rows[e.RowIndex].FindControl("tbPositionAr") as TextBox).Text;
Mem.MNA = (gvMembers.Rows[e.RowIndex].FindControl("tbMNA") as TextBox).Text;
Mem.MNE = (gvMembers.Rows[e.RowIndex].FindControl("tbMNE") as TextBox).Text;
Mem.META = (gvMembers.Rows[e.RowIndex].FindControl("tbMETA") as TextBox).Text;
Mem.Child = (gvMembers.Rows[e.RowIndex].FindControl("tbChild") as TextBox).Text;
DateTime?MrgDate = ((gvMembers.Rows[e.RowIndex].FindControl("tbMrgDate") as TextBox).Text == "") ? (DateTime?)null : Convert.ToDateTime((gvMembers.Rows[e.RowIndex].FindControl("tbMrgDate") as TextBox).Text);
Mem.MrgDate = MrgDate;
Mem.CompanyName = (gvMembers.Rows[e.RowIndex].FindControl("tbCompName") as TextBox).Text;
Mem.DepartmentName = (gvMembers.Rows[e.RowIndex].FindControl("tbDepartmentName") as TextBox).Text;
membersDAL.InsertMembers(Mem);
gvMembers.EditIndex = -1;
GetMembers(null, null, null);
}
private void GetMembers(string emp, string comp, string name)
{
MembersDAL memberDAL = new MembersDAL();
memberDAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
List <Members> MembersList = memberDAL.GetMembers(emp, comp, name);
gvMembers.DataSource = MembersList;
gvMembers.DataBind();
}
public static MembersViewModel GetAllDebitOrderMembers(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder)
{
DataSet ds = MembersDAL.GetAllDebitMembersdt(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder);
DataTable dr = ds.Tables[0];
MembersViewModel objViewModel = new MembersViewModel();
objViewModel.MemberList = FuneralHelper.DataTableMapToList <MembersModel>(dr, true);
objViewModel.TotalRecord = Convert.ToInt64(ds.Tables[1].Rows[0]["TotalRecord"].ToString());
return(objViewModel);
}
public static int GetWaitingPeriodByPlanId(int pkiPlanID)
{
SqlDataReader dr = MembersDAL.GetWaitingPeriodByPlanId(pkiPlanID);
if (dr != null && dr.HasRows)
{
dr.Read();
return(Convert.ToInt32(dr["WaitingPeriod"].ToString()));
}
else
{
return(0);
}
}
public static string GetMemberNumber(Guid ParlourId)
{
SqlDataReader dr = MembersDAL.GetMemberNumber(ParlourId);
if (dr != null && dr.HasRows)
{
dr.Read();
return(dr["MemberNo"].ToString());
}
else
{
return(string.Empty);
}
}
public static string GetPlanUnderwriterByPlanId(int pkiPlanID)
{
SqlDataReader dr = MembersDAL.GetPlanUnderwriterByPlanId(pkiPlanID);
if (dr != null && dr.HasRows)
{
dr.Read();
return(dr["PlanUnderWriter"].ToString());
}
else
{
return(string.Empty);
}
}
public ActionResult InsertMember(string StrName)
{
Member newMember = new Member
{
StrName = StrName
};
bool success = MembersDAL.InsertMember(newMember);
MembersVM model = new MembersVM()
{
LstMembers = MembersDAL.GetAllMembers()
};
return(PartialView("CRUDPartials/_Members", model));
}
public ActionResult DeleteMember(int IntMemberID)
{
Member remMember = new Member
{
IntMemberID = IntMemberID
};
bool success = MembersDAL.DeleteMember(remMember);
MembersVM model = new MembersVM()
{
LstMembers = MembersDAL.GetAllMembers()
};
return(PartialView("CRUDPartials/_Members", model));
}
public ActionResult UpdateMember(int IntMemberID, string StrName)
{
Member upMember = new Member
{
IntMemberID = IntMemberID,
StrName = StrName
};
bool success = MembersDAL.UpdateMember(upMember);
MembersVM model = new MembersVM()
{
LstMembers = MembersDAL.GetAllMembers()
};
return(PartialView("CRUDPartials/_Members", model));
}
public ActionResult DeleteCast(int IntCastID)
{
Cast remCast = new Cast
{
IntCastID = IntCastID
};
bool success = CastsDAL.DeleteCast(remCast);
CastsVM model = new CastsVM()
{
LstCasts = CastsDAL.GetAllCasts(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Casts", model));
}
public ActionResult DeleteStaff(int IntStaffID)
{
Staff remStaff = new Staff
{
IntStaffID = IntStaffID
};
bool success = StaffDAL.DeleteStaff(remStaff);
StaffVM model = new StaffVM()
{
LstStaff = StaffDAL.GetAllStaff(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Staff", model));
}
public ActionResult DeletePit(int IntPitID)
{
Pit remPit = new Pit
{
IntPitID = IntPitID
};
bool success = PitsDAL.DeletePit(remPit);
PitsVM model = new PitsVM()
{
LstPits = PitsDAL.GetAllPits(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Pits", model));
}
public ActionResult DeleteExec(int IntExecID)
{
Exec remExec = new Exec
{
IntExecID = IntExecID
};
bool success = ExecDAL.DeleteExec(remExec);
ExecVM model = new ExecVM()
{
LstExec = ExecDAL.GetAllExec(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllClubs = ClubsDAL.GetAllClubs(),
LstAllDates = DatesDAL.GetAllDates()
};
return(PartialView("CRUDPartials/_Exec", model));
}
public ActionResult Crud()
{
ViewBag.Message = "Create, Read, Update, and Delete table info here";
CRUDVM model = new CRUDVM();
IEnumerable <Cast> allCasts = CastsDAL.GetAllCasts();
IEnumerable <Club> allClubs = ClubsDAL.GetAllClubs();
IEnumerable <Date> allDates = DatesDAL.GetAllDates();
IEnumerable <Exec> allExec = ExecDAL.GetAllExec();
IEnumerable <Member> allMembers = MembersDAL.GetAllMembers();
IEnumerable <Pit> allPits = PitsDAL.GetAllPits();
IEnumerable <Show> allShows = ShowsDAL.GetAllShows();
IEnumerable <Staff> allStaff = StaffDAL.GetAllStaff();
model._shows_vm.LstShows = allShows;
model._shows_vm.LstAllClubs = allClubs;
model._shows_vm.LstAllDates = allDates;
model._casts_vm.LstCasts = allCasts;
model._casts_vm.LstAllMembers = allMembers;
model._casts_vm.LstAllShows = allShows;
model._exec_vm.LstExec = allExec;
model._exec_vm.LstAllMembers = allMembers;
model._exec_vm.LstAllClubs = allClubs;
model._exec_vm.LstAllDates = allDates;
model._members_vm.LstMembers = allMembers;
model._pits_vm.LstPits = allPits;
model._pits_vm.LstAllMembers = allMembers;
model._pits_vm.LstAllShows = allShows;
model._staff_vm.LstStaff = allStaff;
model._staff_vm.LstAllMembers = allMembers;
model._staff_vm.LstAllShows = allShows;
return(View(model));
}
public ActionResult UpdateCast(int IntCastID, int IntMemberID)
{
Cast updCast = new Cast
{
IntCastID = IntCastID,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID)
};
bool success = CastsDAL.UpdateCast(updCast);
CastsVM model = new CastsVM()
{
LstCasts = CastsDAL.GetAllCasts(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Casts", model));
}
public ActionResult UpdatePit(int IntPitID, int IntSeat, int IntMemberID)
{
Pit upPit = new Pit
{
IntPitID = IntPitID,
IntSeat = IntSeat,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID)
};
bool success = PitsDAL.UpdatePit(upPit);
PitsVM model = new PitsVM()
{
LstPits = PitsDAL.GetAllPits(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Pits", model));
}
public ActionResult UpdateExec(int IntExecID, int IntMemberID)
{
Exec updExec = new Exec
{
IntExecID = IntExecID,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID)
};
bool success = ExecDAL.UpdateExec(updExec);
ExecVM model = new ExecVM()
{
LstExec = ExecDAL.GetAllExec(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllClubs = ClubsDAL.GetAllClubs(),
LstAllDates = DatesDAL.GetAllDates()
};
return(PartialView("CRUDPartials/_Exec", model));
}
public ActionResult InsertStaff(string StrPosition, int IntMemberID, int IntShowID)
{
Staff newStaff = new Staff
{
StrPosition = StrPosition,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID),
IntShowID = IntShowID,
Show = ShowsDAL.GetShow(IntShowID)
};
bool success = StaffDAL.InsertStaff(newStaff);
StaffVM model = new StaffVM()
{
LstStaff = StaffDAL.GetAllStaff(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Staff", model));
}
public ActionResult InsertPit(string StrInstrument, int IntSeat, int IntMemberID, int IntShowID)
{
Pit newPit = new Pit
{
StrInstrument = StrInstrument,
IntSeat = IntSeat,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID),
IntShowID = IntShowID,
Show = ShowsDAL.GetShow(IntShowID)
};
bool success = PitsDAL.InsertPit(newPit);
PitsVM model = new PitsVM()
{
LstPits = PitsDAL.GetAllPits(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Pits", model));
}
public ActionResult InsertCast(string StrVoicePart, string StrRole, int IntMemberID, int IntShowID)
{
Cast newCast = new Cast
{
StrVoicePart = StrVoicePart,
StrRole = StrRole,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID),
IntShowID = IntShowID,
Show = ShowsDAL.GetShow(IntShowID)
};
bool success = CastsDAL.InsertCast(newCast);
CastsVM model = new CastsVM()
{
LstCasts = CastsDAL.GetAllCasts(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Casts", model));
}
public static List <string> GetDistinctPolicyStatusList()
{
DataTable dr = MembersDAL.GetDistinctPolicyStatusListdt();
return(FuneralHelper.DataTableMapToList <string>(dr));
}
public static VehiclesModel GetVehicleByVinNo(string VinNo, Guid ParlourId, int MemberID)
{
DataTable dr = MembersDAL.GetVehicleByVinNodt(VinNo, ParlourId, MemberID);
return(FuneralHelper.DataTableMapToList <VehiclesModel>(dr).FirstOrDefault());
}
public static MembersModel GetMemberByIDNum(string ID, Guid ParlourId)
{
DataTable dr = MembersDAL.GetMemberByIDNumdt(ID, ParlourId);
return(FuneralHelper.DataTableMapToList <MembersModel>(dr).FirstOrDefault());
}
public static FamilyDependencyModel GetDependencByIDNum(string ID, Guid ParlourId, int MemberID)
{
DataTable dr = MembersDAL.GetDependencByIDNumdt(ID, ParlourId, MemberID);
return(FuneralHelper.DataTableMapToList <FamilyDependencyModel>(dr).FirstOrDefault());
}
