public RestaurantEmployeeModel RestaurantEmpData(RestaurantEmployeeModel model)
{
using (IDbConnection koneksi = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("Restaurant")))
{
var k = new DynamicParameters();
k.Add("@EmployeeId", model.EmployeeId);
k.Add("@EmployeeName", model.EmployeeName);
k.Add("@EmployeeEmail", model.EmployeeEmail);
k.Add("@EmployeePassword", model.EmployeePassword);
k.Add("@EmployeeHandphone", model.EmployeeHandPhoneNumber);
k.Add("@EmployeePosition", model.EmployeePosition);
koneksi.Execute("dbo.spMsEmployee_Insert", k, commandType: CommandType.StoredProcedure);
return(model);
}
}
public RestaurantEmployeeModel RestaurantEmpData(RestaurantEmployeeModel model)
{
List <RestaurantEmployeeModel> employee = EmployeeFile.FullFilePath().LoadFile().ConvertToEmployeeModels();
int currentId = 1;
RestaurantEmployeeModel e = new RestaurantEmployeeModel();
if (employee.Count > 0)
{
string getid = e.EmployeeId;
//currentId = employee.OrderByDescending(e => e.EmployeeId).First().EmployeeId + 1;
}
//Employee.Add(model);
return(model);
}
private void InsertCashierData()
{
using (RestaurantDBEntities db = new RestaurantDBEntities())
{
RestaurantEmployeeModel EmpModel = new RestaurantEmployeeModel();
var GetEmpData = (from b in db.msemployees orderby b.employeeid descending select b).FirstOrDefault();
string GetEmployeeId = EmpModel.EmployeeId;
if (GetEmployeeId == null)
{
int CashierId = 0 + 1;
string GetCashierId = "CA" + CashierId++;
RestaurantEmployeeModel SendToEmployeeModel = new RestaurantEmployeeModel(
GetCashierId,
EmployeeNameTextBox.Text,
EmployeeEmailTextBox.Text,
EmployeePasswordTextBox.Text,
EmployeeHandphoneTextBox.Text,
EmployeePositionValue.Text);
GlobalConfig.Connection.RestaurantEmpData(EmpModel);
}
else
{
var GetData = (from b in db.msemployees
where b.position == "cashier"
orderby b.employeeid descending
select b).First();
string GetlastId = EmpModel.EmployeeId;
string SubstringCashierId = GetData.employeeid.Substring(2, 2);
int ConvertAIC = Convert.ToInt32(SubstringCashierId) + 1;
string CombineCashierId = SubstringCashierId + "" + ConvertAIC;
RestaurantEmployeeModel SendToEmployeeModel = new RestaurantEmployeeModel(
GetlastId,
EmployeeNameTextBox.Text,
EmployeeEmailTextBox.Text,
EmployeePasswordTextBox.Text,
EmployeeHandphoneTextBox.Text,
EmployeePositionValue.Text);
GlobalConfig.Connection.RestaurantEmpData(EmpModel);
}
MessageBox.Show("Data Berhasil Di Input !!");
}
}
public static List <RestaurantEmployeeModel> ConvertToEmployeeModels(this List <string> lines)
{
List <RestaurantEmployeeModel> output = new List <RestaurantEmployeeModel>();
foreach (string line in lines)
{
string[] cols = line.Split(',');
RestaurantEmployeeModel e = new RestaurantEmployeeModel();
e.EmployeeId = cols[0];
e.EmployeeName = cols[1];
e.EmployeeEmail = cols[2];
e.EmployeePassword = cols[3];
e.EmployeeHandPhoneNumber = cols[4];
e.EmployeePosition = cols[5];
output.Add(e);
}
return(output);
}
