private void InsertCashierData()
{
string EmployeeName = EmployeeNameTextBox.Text;
string EmployeeEmail = EmployeeEmailTextBox.Text.ToLower();
string EmployeePassword = EmployeePasswordTextBox.Text;
string EmployeeHandphone = EmployeeHandphoneTextBox.Text;
string EmployeePosition = EmployeePositionValue.Text.ToLower();
EmployeeRepository EmpRepost = new EmployeeRepository();
List <EmployeeInformation> EmployeeInformation = EmpRepost.GetEmpData();
var CheckId = (from s in EmployeeInformation where s.EmployeePosition == "cashier" select s).Count();
using (RestaurantkuContext Context = new RestaurantkuContext())
{
if (CheckId == 0)
{
#region Inserting Cashier Id if Cashier Data never created before
int CashierId = 1;
string GetCashierId = "CA0" + CashierId;
Context.spMsEmployee_Action(
GetCashierId,
EmployeeName,
EmployeeEmail,
EmployeePassword,
EmployeeHandphone,
EmployeePosition,
"insert");
Context.SaveChanges();
#endregion
}
else
{
#region Inserting Cashier Id if Cashier Data has been created Before
var GetData = (from s in EmployeeInformation where s.EmployeePosition == "cashier" orderby s.EmployeeId descending select s).First();
string GetId = GetData.EmployeeId;
string SubstringId = GetId.Substring(2, 2);
int ConvertId = Convert.ToInt32(SubstringId);
int aic = ConvertId++;
string ConvertToString = ConvertId.ToString();
string FinalId = "CA0" + ConvertToString;
Context.spMsEmployee_Action(FinalId,
EmployeeName,
EmployeeEmail,
EmployeePassword,
EmployeeHandphone,
EmployeePosition,
"insert");
Context.SaveChanges();
#endregion
}
}
}
private void InsertMember()
{
string Name = MemberNameText.Text;
string Email = MemberEmailText.Text;
string Password = MemberPasswordText.Text;
string JoinDates = JoinDateTime.Value.ToString();
string CellNumber = CellNumberText.Text;
string Address = AddressText.Text;
EmployeeRepository Repost = new EmployeeRepository();
List <MemberInformation> MemberInfo = Repost.MemberInfo().ToList();
DateTime JoinMemberTime = JoinDateTime.Value;
//DateTime.Parse(JoinDateTime.Value.ToString("dd/mm/yyyy"))
var getMemberId = (from s in MemberInfo where s.MemberId >= 1 select s).Count();
if (getMemberId >= 1)
{
using (RestaurantkuContext Context = new RestaurantkuContext())
{
var GetLastId = (from s in MemberInfo orderby s.MemberId descending select s).FirstOrDefault();
int MemberId = GetLastId.MemberId + 1;
Context.spMsMember_Action(MemberId, Name, MemberEmailText.Text, CellNumber, JoinMemberTime, Password, null, null, null, Address, null, "insert");
Context.SaveChanges();
}
}
else
{
using (RestaurantkuContext Context = new RestaurantkuContext())
{
int MemberId = 1;
Context.spMsMember_Action(MemberId, Name, MemberEmailText.Text, CellNumber, JoinMemberTime, Password, null, null, null, Address, null, "insert");
}
}
}
private void DeleteMember()
{
using (RestaurantkuContext Context = new RestaurantkuContext())
{
Context.spMsMember_Action(Convert.ToInt32(MemberIdTextBox.Text), null, null, null, null, null, null, null, null, null, null, "delete");
Context.SaveChanges();
}
}
private void UpdateEmpData()
{
using (RestaurantkuContext Context = new RestaurantkuContext())
{
string EmployeeId = EmployeeIdTextBox.Text.Trim();
string EmployeeName = EmployeeNameTextBox.Text;
string EmployeeEmail = EmployeeEmailTextBox.Text.ToLower();
string EmployeePassword = EmployeePasswordTextBox.Text;
string EmployeeHandphone = EmployeeHandphoneTextBox.Text;
string EmployeePosition = EmployeePositionValue.Text.ToLower();
Context.spMsEmployee_Action(EmployeeId, EmployeeName, EmployeeEmail, EmployeePassword, EmployeeHandphone, EmployeePosition, "update");
Context.SaveChanges();
}
}
private void InsertChefData()
{
string EmployeeName = EmployeeNameTextBox.Text;
string EmployeeEmail = EmployeeEmailTextBox.Text.ToLower();
string EmployeePassword = EmployeePasswordTextBox.Text;
string EmployeeHandphone = EmployeeHandphoneTextBox.Text;
string EmployeePosition = EmployeePositionValue.Text.ToLower();
EmployeeRepository empRepost = new EmployeeRepository();
List <EmployeeInformation> GetEmpData = empRepost.GetEmpData();
var getDataifNull = (from s in GetEmpData where s.EmployeePosition == "chef" select s).Count();
#region Create Chef Data if chef data never created before
if (getDataifNull == 0)
{
using (RestaurantkuContext context = new RestaurantkuContext())
{
int ChefId = 0 + 1;
string GetChefId = "CH0" + ChefId++;
string EmployeeId = GetChefId;
context.spMsEmployee_Action(EmployeeId, EmployeeName, EmployeeEmail, EmployeePassword, EmployeeHandphone, EmployeePosition, "insert");
context.SaveChanges();
}
}
#endregion
#region Create chef data if chef data has been created before
else
{
using (RestaurantkuContext Context = new RestaurantkuContext())
{
var getData = (from s in GetEmpData where s.EmployeePosition == "chef" orderby s.EmployeeId descending select s).FirstOrDefault();
string GetIdFromContext = getData.EmployeeId;
string SubstringGetId = GetIdFromContext.Substring(2, 2); // Substring dari index 2 untuk 2 kekanan
int ConvertSubstring = Convert.ToInt32(SubstringGetId);
int AutoIncId = ConvertSubstring++; //AutoIncId = Auto Increment Untuk Id nya
string ConvertString = ConvertSubstring.ToString();
string FinalId = "CH0" + ConvertString; //Id ynag sudah di auto incrementkan atau Id Jadinya
string EmployeeId = FinalId;
Context.spMsEmployee_Action(EmployeeId, EmployeeName, EmployeeEmail, EmployeePassword, EmployeeHandphone, EmployeePosition, "insert");
Context.SaveChanges();
}
}
#endregion
}
private void UpdateMember()
{
DateTime JoinMemberTime = JoinDateTime.Value;
using (RestaurantkuContext Context = new RestaurantkuContext())
{
int Memberid = Convert.ToInt32(MemberIdTextBox.Text);
Context.spMsMember_Action(
Convert.ToInt32(MemberIdTextBox.Text),
Name,
MemberEmailText.Text,
CellNumberText.Text,
JoinMemberTime,
MemberPasswordText.Text,
null, null, null,
AddressText.Text,
null, "insert");
Context.SaveChanges();
}
MessageBox.Show("Data Berhasil Di Perbaharui");
LoadData();
}