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 DeleteDataButton_Click(object sender, EventArgs e)
{
try {
using (RestaurantkuContext Context = new RestaurantkuContext())
{
Context.spMsEmployee_Action(EmployeeIdTextBox.Text, null, null, null, null, null, "delete");
}
MessageBox.Show("Data sukses Di Hapus");
LoadDataGrid();
}
catch { MessageBox.Show("Id Tidak Dapat Di temukan"); }
}
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
}