static void Main(string[] args) { decimal Op1 = 2; decimal Op2 = 3; string Op = "+"; string vs = Op1.ToString() + Op + Op2.ToString(); DataTable dt = new DataTable(); decimal val = decimal.Parse(dt.Compute(vs, string.Empty).ToString()); Console.WriteLine(vs + " = " + val.ToString()); Console.WriteLine("2-3 = " + decimal.Parse(dt.Compute("2-3", string.Empty).ToString())); Console.WriteLine("2/3 = " + decimal.Parse(dt.Compute("2/3", string.Empty).ToString())); Console.WriteLine("2*3 = " + decimal.Parse(dt.Compute("2*3", string.Empty).ToString())); Console.WriteLine("2%3 = " + decimal.Parse(dt.Compute("2%3", string.Empty).ToString())); Console.WriteLine("3%2 = " + decimal.Parse(dt.Compute("3%2", string.Empty).ToString())); //Console.WriteLine("Floor(12663216.000000 / 50000000.0) = " + decimal.Parse(dt.Compute("Floor(12663216.000000 / 50000000.0)", string.Empty).ToString())); //Console.ReadLine(); var db = new AttPayrollEntities(); using (db) { db.DeleteAllTables(); DataBuilder d = new DataBuilder(); DataFunction(d); } }
// Example 2 public int ImportFromExcel(string fileName) { // Buat satu Service menggunakan nama ExcelEntryService // yang memiliki Repository, dimana GetContext dapat digunakan // membaca setiap nama sheet dan link dengan nama table di database / domain model // setiap table mengarah ke service terkait, menggunakan fungsi CreateObject // int count = 0; //DbContext conLinq = new DbContext("Data Source=server name;Initial Catalog=Database Name;Integrated Security=true"); using (var conLinq = new AttPayrollEntities()) { try { DataTable dtExcel = new DataTable(); // Note : HDR=Yes indicates that the first row contains column names, not data. HDR=No indicates the opposite. string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + fileName + "';Extended Properties= 'Excel 12.0;HDR=Yes;IMEX=1'"; OleDbConnection conn = new OleDbConnection(SourceConstr); string query = "Select * from [Sheet1$]"; OleDbDataAdapter data = new OleDbDataAdapter(query, conn); conn.Open(); data.Fill(dtExcel); for (int i = 0; i < dtExcel.Rows.Count; i++) { try { count += conLinq.Database.ExecuteSqlCommand("insert into [Sheet1$] values(" + dtExcel.Rows[i][0] + "," + dtExcel.Rows[i][1] + ",'" + dtExcel.Rows[i][2] + "'," + dtExcel.Rows[i][3] + ")"); } catch (Exception ex) { continue; } } if (count == dtExcel.Rows.Count) { //<--Success Message--> } else { //<--Failure Message--> } dtExcel.Dispose(); } catch (Exception ex) { throw ex; } finally { conLinq.Dispose(); } } return(count); }
void before_each() { // something to do before checked var db = new AttPayrollEntities(); using (db) { db.DeleteAllTables(); d = new DataBuilder(); d.PopulateData(); } }
public OtherExpenseDetailRepository() { entities = new AttPayrollEntities(); }
public TitleInfoRepository() { entities = new AttPayrollEntities(); }
public int ImportEmployeeFromExcel(string fileName) { // Buat satu Service menggunakan nama ExcelEntryService // yang memiliki Repository, dimana GetContext dapat digunakan // membaca setiap nama sheet dan link dengan nama table di database / domain model // setiap table mengarah ke service terkait, menggunakan fungsi CreateObject // int count = 0; //DbContext conLinq = new DbContext("Data Source=server name;Initial Catalog=Database Name;Integrated Security=true"); using (var conLinq = new AttPayrollEntities()) { try { DataTable dtExcel = new DataTable(); // Note : HDR=Yes indicates that the first row contains column names, not data. HDR=No indicates the opposite. string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + fileName + "';Extended Properties= 'Excel 12.0;HDR=Yes;IMEX=1'"; OleDbConnection conn = new OleDbConnection(SourceConstr); conn.Open(); // Get Sheets list DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string sheetname = dt.Rows[0]["TABLE_NAME"].ToString(); // string.Format("{0}", "Sheet1$"); string query = string.Format("Select * from [{0}]", sheetname); OleDbDataAdapter data = new OleDbDataAdapter(query, conn); data.Fill(dtExcel); for (int i = 0; i < dtExcel.Rows.Count; i++) { try { //count += conLinq.Database.ExecuteSqlCommand("insert into [Sheet1$] values(" + dtExcel.Rows[i][0] + "," + dtExcel.Rows[i][1] + ",'" + dtExcel.Rows[i][2] + "'," + dtExcel.Rows[i][3] + ")"); // Find Or Create Branch var branchcode = dtExcel.Rows[i][4].ToString(); BranchOffice branchOffice = _branchOfficeService.FindOrCreateObject(branchcode.Replace(" ", String.Empty), branchcode, "-", "-", "-", "-", "-", "-", _companyInfoService); // Find Or Create Department & Division var deptcode = dtExcel.Rows[i][5].ToString(); Department department = _departmentService.FindOrCreateObject(branchOffice.Id, deptcode.Replace(" ", String.Empty), deptcode, "", _branchOfficeService); Division division = _divisionService.FindOrCreateObject(department.Id, deptcode.Replace(" ", String.Empty), deptcode, "", _departmentService); // Find Or Create Title var titlename = dtExcel.Rows[i][3].ToString(); TitleInfo titleInfo = _titleInfoService.FindOrCreateObject(titlename.Replace(" ", String.Empty), titlename, "", false); // Find Or Create Employee Employee employee = new Employee() { DivisionId = division.Id, TitleInfoId = titleInfo.Id, NIK = dtExcel.Rows[i][0].ToString(), StartWorkingDate = DateTime.Parse(dtExcel.Rows[i][1].ToString()), Name = dtExcel.Rows[i][2].ToString(), BankAccount = dtExcel.Rows[i][6].ToString(), Bank = dtExcel.Rows[i][7].ToString(), BirthDate = DateTime.Parse(dtExcel.Rows[i][20].ToString()), PlaceOfBirth = "-", PTKPCode = dtExcel.Rows[i][22].ToString(), NPWP = dtExcel.Rows[i][23].ToString(), Religion = (int)Enum.Parse(typeof(Constant.Religion), dtExcel.Rows[i][26].ToString(), true), Address = dtExcel.Rows[i][28].ToString(), IDNumber = dtExcel.Rows[i][29].ToString(), Sex = dtExcel.Rows[i][27].ToString().Substring(0, 1) == "F" ? 1 : 0, MaritalStatus = dtExcel.Rows[i][22].ToString().Substring(0, 1) == "K" ? 1 : 0, Children = int.Parse(dtExcel.Rows[i][22].ToString().Substring(dtExcel.Rows[i][22].ToString().IndexOf("/"))), PhoneNumber = "-", }; _employeeService.FindOrCreateObject(employee, _divisionService, _titleInfoService); // Find Or Create SalaryStandard // Find Or Create SalaryEmployee } catch (Exception ex) { continue; } } if (count == dtExcel.Rows.Count) { //<--Success Message--> } else { //<--Failure Message--> } dtExcel.Dispose(); } catch (Exception ex) { throw ex; } finally { conLinq.Dispose(); } } return(count); }
public SPKLRepository() { entities = new AttPayrollEntities(); }
public EmployeeLoanDetailRepository() { entities = new AttPayrollEntities(); }
public WorkingDayRepository() { entities = new AttPayrollEntities(); }
//EfRepository(DbContext context) : this(context, false) { } //EfRepository(DbContext context, bool sharedContext) //{ // Context = context; // ShareContext = sharedContext; //} //public static IQueryable<T> Include<T> // (this IQueryable<T> source, string path) //{ // var objectQuery = source as System.Data.Objects.ObjectQuery<T>; // if (objectQuery != null) // { // return objectQuery.Include(path); // } // return source; //} public EfRepository() { Context = new AttPayrollEntities(); }
public UserAccountRepository() { entities = new AttPayrollEntities(); }
public OtherIncomeDetailRepository() { entities = new AttPayrollEntities(); }
public PTKPRepository() { entities = new AttPayrollEntities(); }
public PensionCompensationRepository() { entities = new AttPayrollEntities(); }
public SalaryEmployeeDetailRepository() { entities = new AttPayrollEntities(); }
public FPUserRepository() { entities = new AttPayrollEntities(); //entities.Configuration.ProxyCreationEnabled = false; }
public PPH21SPTRepository() { entities = new AttPayrollEntities(); }
public SalaryStandardDetailRepository() { entities = new AttPayrollEntities(); }
public SlipGajiDetail1Repository() { entities = new AttPayrollEntities(); }
public SlipGajiMiniRepository() { entities = new AttPayrollEntities(); }
public SalarySlipRepository() { entities = new AttPayrollEntities(); }
public FormulaRepository() { entities = new AttPayrollEntities(); }
// Example 1 public int ImporttoSQL(string sPath) { // Note : HDR=Yes indicates that the first row contains column names, not data. HDR=No indicates the opposite. // Connect to Excel 2007 earlier version //string sSourceConstr = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\AgentList.xls; Extended Properties=""Excel 8.0;HDR=YES;"""; // Connect to Excel 2007 (and later) files with the Xlsx file extension string sSourceConstr = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1;""", sPath); //IMEX=1 //string sDestConstr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; // "DBConnection" int count = 0; OleDbConnection sSourceConnection = new OleDbConnection(sSourceConstr); //DbContext db = new DbContext(sDestConstr); using (var db = new AttPayrollEntities()) { using (sSourceConnection) { sSourceConnection.Open(); // Get Sheets list DataTable dt = sSourceConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); //String[] strExcelSheets = new String[dt.Rows.Count]; //int i = 0; // Add the sheet name to the string array. foreach (DataRow dtrow in dt.Rows) { //strExcelSheets[i] = row["TABLE_NAME"].ToString(); //i++; string sheetname = dtrow["TABLE_NAME"].ToString(); // string.Format("{0}", "Sheet1$"); string sql = string.Format("Select [Employee ID],[Employee Name],[Designation],[Posting],[Dept] FROM [{0}]", "Sheet1$"); OleDbCommand command = new OleDbCommand(sql, sSourceConnection); sSourceConnection.Open(); using (OleDbDataReader dr = command.ExecuteReader()) { if (dr.HasRows) { switch (sheetname) { case Constant.SheetName.BranchOffice: count += DoBranchOffice(dr, db); break; case Constant.SheetName.Department: count += DoDepartment(dr, db); break; } //DataTable schemaTable = dr.GetSchemaTable(); // read the whole table/sheet //foreach (DataRow row in schemaTable.Rows) //{ // foreach (DataColumn column in schemaTable.Columns) // { // } //} //using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sDestConstr)) // copy the whole table/sheet //{ // bulkCopy.DestinationTableName = "Employee"; // //You can mannualy set the column mapping by the following way. // //bulkCopy.ColumnMappings.Add("Employee ID", "Employee Code"); // bulkCopy.WriteToServer(dr); //} } if (dr != null) { dr.Close(); dr.Dispose(); } } } if (dt != null) { dt.Dispose(); } //if (sSourceConnection != null) //{ // sSourceConnection.Close(); //} } if (db != null) { db.Dispose(); } } return(count); }
public DepartmentRepository() { entities = new AttPayrollEntities(); }
public int ImportDataFromExcel(string fileName) { // Buat satu Service menggunakan nama ExcelEntryService // yang memiliki Repository, dimana GetContext dapat digunakan // membaca setiap nama sheet dan link dengan nama table di database / domain model // setiap table mengarah ke service terkait, menggunakan fungsi CreateObject // int count = 0; //DbContext conLinq = new DbContext("Data Source=server name;Initial Catalog=Database Name;Integrated Security=true"); using (var conLinq = new AttPayrollEntities()) { //try { DataSet dtExcel = new DataSet(); // Note : HDR=Yes indicates that the first row contains column names, not data. HDR=No indicates the opposite. string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + fileName + "';Extended Properties= 'Excel 12.0;HDR=Yes;IMEX=1'"; OleDbConnection conn = new OleDbConnection(SourceConstr); conn.Open(); // Get Sheets list DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string sheetname = ""; foreach (DataRow dtrow in dt.Rows) { sheetname = dtrow["TABLE_NAME"].ToString(); //.Trim(new[] { '$' }); // string.Format("{0}", "Sheet1$"); string query = string.Format("Select * from [{0}]", sheetname); // Create OleDbCommand object and select data from worksheet Sheet1 OleDbCommand cmd = new OleDbCommand(query, conn); // Create new OleDbDataAdapter OleDbDataAdapter oleda = new OleDbDataAdapter(); oleda.SelectCommand = cmd; // Fill the DataSet from the data extracted from the worksheet. oleda.Fill(dtExcel, sheetname); oleda.Dispose(); cmd.Dispose(); } //sheetname = "Customer$"; //for (int i = 0; i < dtExcel.Tables[sheetname].Rows.Count; i++) //{ // //try // { // //count += conLinq.Database.ExecuteSqlCommand("insert into [Sheet1$] values(" + dtExcel.Rows[i][0] + "," + dtExcel.Rows[i][1] + ",'" + dtExcel.Rows[i][2] + "'," + dtExcel.Rows[i][3] + ")"); // // Find Or Create Object // var row = dtExcel.Tables[sheetname].Rows[i]; // var tmp = row[0].ToString() + row[1].ToString(); // if (tmp == null || tmp.Trim() == "") continue; // skip if the 1st 2 column is empty // DoCustomer(row, i, sheetname); // } // //catch (Exception ex) // //{ // // Console.WriteLine(sheetname + " Row:" + (i + 2) + " Exception:" + ex.Message); // // continue; // //} //} //oleda.Dispose(); //foreach (var x in data) x.Dispose(); //data.Clear(); dtExcel.Dispose(); } //catch (Exception ex) //{ // throw ex; //} //finally { conLinq.Dispose(); } } return(count); }
public EmployeeRepository() { entities = new AttPayrollEntities(); }
public DivisionRepository() { entities = new AttPayrollEntities(); }
public BranchOfficeRepository() { entities = new AttPayrollEntities(); }
public THRDetailRepository() { entities = new AttPayrollEntities(); }
public CompanyInfoRepository() { entities = new AttPayrollEntities(); }