public void DeleteFromBranch(BranchModel branchModel)
{
MDBHelper = new MainDatabaseHelper();
BranchModel branch = new BranchModel();
SqlCommand cmd = new SqlCommand("Delete from Branches where BranchID = " + branchModel.BranchID);
//SqlCommand cmd = new SqlCommand("GetBranchInfo");
//cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandType = CommandType.Text;
MDBHelper.Delete(cmd, branch);
}
public BranchModel SelectAllFromBranch(BranchModel branchModel, UserModel currentUser)
{
MDBHelper = new MainDatabaseHelper();
BranchModel branch = new BranchModel();
SqlCommand cmd = new SqlCommand("Select * from Branches where BranchID = " + branchModel.BranchID);
//SqlCommand cmd = new SqlCommand("GetBranchInfo");
//cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandType = CommandType.Text;
//cmd.Parameters.AddWithValue("@branchID", branchModel.BranchID);
//cmd.Parameters.Add("@BranchName",SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@Address", SqlDbType.VarChar,100).Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@Contact", SqlDbType.VarChar,50).Direction = ParameterDirection.Output;
branch = MDBHelper.GetDataFromBranch(cmd, branch);
return(branch);
}
public int InsertIntoDepartment(DepartmentModel dept, UserModel currentUser)
{
MDBHelper = new MainDatabaseHelper();
SqlCommand cmd = new SqlCommand("InsertDepartment");
cmd.Parameters.AddWithValue("@DepartmentName", dept.DepartmentName);
cmd.Parameters.AddWithValue("@CreatedBy", currentUser.UserID);
cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@ModifiedBy", currentUser.UserID);
cmd.Parameters.AddWithValue("@Modifiedate", DateTime.Now);
cmd.Parameters.AddWithValue("@DeptBranch", dept.DeptBranch);
cmd.Parameters.Add("@DepartmentID", SqlDbType.Int).Direction = ParameterDirection.Output;
int departmentID = MDBHelper.RunQueryInDepartment(cmd);
return(departmentID);
}
public int InsertInBranch(BranchModel branchModel, UserModel currentUser)
{
MDBHelper = new MainDatabaseHelper();
SqlCommand cmd = new SqlCommand("InsertBranch");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchName", branchModel.BranchName);
cmd.Parameters.AddWithValue("@Address", branchModel.Address);
cmd.Parameters.AddWithValue("@Contact", branchModel.Contact);
//cmd.Parameters.AddWithValue("@DepartmentID", branchModel.DepartmentID);
cmd.Parameters.AddWithValue("@CreatedBy", currentUser.UserID);
cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@ModifiedBy", currentUser.UserID);
cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now);
cmd.Parameters.Add("@BranchID", SqlDbType.Int).Direction = ParameterDirection.Output;
int BranchID = MDBHelper.RunQuerryInBranch(cmd);
//int BranchID = int.Parse(cmd.Parameters["@BranchID"].Value.ToString());
return(BranchID);
}
public int InsertIntoUser(UserModel user, UserModel currentUser)
{
MDBHelper = new MainDatabaseHelper();
SqlCommand cmd = new SqlCommand("InsertUsers");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmployeeID", user.EmployeeID);
cmd.Parameters.AddWithValue("@IsSuperAdmin", user.IsSuperAdmin);
cmd.Parameters.AddWithValue("@Password", user.Password);
cmd.Parameters.AddWithValue("@PreviousPasswords", user.PreviousPassword);
cmd.Parameters.AddWithValue("@IsActive", user.IsActive);
cmd.Parameters.AddWithValue("@CreatedBy", currentUser.UserID);
cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@ModifiedBy", currentUser.UserID); //needs to be discussed
cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now); //needs to know what to implement
cmd.Parameters.AddWithValue("@IsAdmin", user.IsActive);
cmd.Parameters.AddWithValue("@UserName", user.UserName);
cmd.Parameters.Add("@UserID", SqlDbType.Int).Direction = ParameterDirection.Output;
int ID = MDBHelper.RunQueryInUser(cmd);
return(ID);
}
public int InsertInEmployee(EmployeeModel _employee, UserModel _currentUser)
{
DateTime rngMin = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
//DateTime.MinValue = rngMin;
MDBHelper = new MainDatabaseHelper();
DateTime datetimeNow = DateTime.Now;
//MessageBox.Show("" + datetimeNow);
SqlCommand cmd = new SqlCommand("InsertEmployee");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmployeeName", _employee.EmployeeName);
cmd.Parameters.AddWithValue("@RankID", _employee.RankID);
cmd.Parameters.AddWithValue("@DepartmentID", _employee.DepartmentID);
cmd.Parameters.AddWithValue("@BranchID", _employee.BranchID);
cmd.Parameters.AddWithValue("@IssuedCardID", _employee.IssuedCardID);
cmd.Parameters.AddWithValue("@Height", _employee.Height);
cmd.Parameters.AddWithValue("@BloodGroup", _employee.BloodGroup);
cmd.Parameters.AddWithValue("@IdentificationMark", _employee.IdentificationMark);
cmd.Parameters.AddWithValue("@EmployeeSignatureFilePath", _employee.EmployeeSignatureFilePath);
//cmd.Parameters.AddWithValue("@AuthoritySignatureFilePath", _employee.AuthoritySignatureFilePath);
cmd.Parameters.AddWithValue("@AuthorizedBy", _currentUser.UserID);
cmd.Parameters.Add("@AuthorizedDate", SqlDbType.DateTime).Value = _employee.AuthorizedDate;
cmd.Parameters.Add("@DateOfIssue", SqlDbType.DateTime).Value = _employee.DateOfIssue;
cmd.Parameters.AddWithValue("@EmployersCategory", _employee.EmployersCatagory);
cmd.Parameters.AddWithValue("@DateOfRetirement", _employee.DateOfRetirement);
cmd.Parameters.AddWithValue("@DateOfJoining", _employee.DateOfJoining);
cmd.Parameters.AddWithValue("@MaritalStatus", _employee.MaritalStatus);
cmd.Parameters.AddWithValue("@PresentAddress", _employee.PresentAdress);
cmd.Parameters.AddWithValue("@PermanentAddress", _employee.PermanentAddress);
cmd.Parameters.AddWithValue("@EmailAddress", _employee.EmailAddress);
cmd.Parameters.AddWithValue("@ContactNumber", _employee.ContactNumber);
cmd.Parameters.AddWithValue("@PoliceStation", _employee.PoliceStation);
cmd.Parameters.AddWithValue("@PoliceStationContactNumber", _employee.PoliceStationContactNumber);
cmd.Parameters.AddWithValue("@FamilyPersonName", _employee.FamilyPersonName);
cmd.Parameters.AddWithValue("@FamilyPersonNID", _employee.FamilyPersonNID);
cmd.Parameters.AddWithValue("@FamilyPersonContactNumber", _employee.FamilyPersonContactNumber);
cmd.Parameters.AddWithValue("@FamilyPersonPoliceStation", _employee.FamilyPersonPoliceStation);
cmd.Parameters.AddWithValue("@OfficeID", _employee.OfficeID);
cmd.Parameters.AddWithValue("@PreviousOfficeIds", _employee.PreviousOfficeID);
cmd.Parameters.AddWithValue("@CreatedBy", _currentUser.UserID);
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = _employee.CreatedDate;
cmd.Parameters.AddWithValue("@ModifiedBy", _currentUser.UserID);
cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@PersonalNo", _employee.PersonalNo);
cmd.Parameters.AddWithValue("@DateOfBirth", _employee.DateOfBirth);
cmd.Parameters.AddWithValue("@imagePath", _employee.EmployeeImagePath);
cmd.Parameters.AddWithValue("@CardID", _employee.Rfid);
cmd.Parameters.AddWithValue("@NationalID", _employee.NationalID);
cmd.Parameters.AddWithValue("@FingerPrintPath", _employee.FingerPrintPath);
cmd.Parameters.AddWithValue("@RfID", _employee.Rfid);
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int).Direction = ParameterDirection.Output;
int EmployeeID = MDBHelper.RunQuerryInEmployee(cmd);
return(_employee.EmployeeID);
//cmd.Parameters["@AuthorizedDate"].Value = datetimeNow;
//cmd.Parameters["@DateOfIssue"].Value = datetimeNow;
//cmd.Parameters["@CreatedDate"].Value = datetimeNow;
// cmd.Parameters.AddWithValue("@CreatedDate", datetimeNow);
}