public void CreateVendorTypeTable() { try { string query = @"SELECT name FROM sqlite_master WHERE type='table' AND name='VendorType';"; DataSet ds = temp.fillComboDataset(query); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { query = @"CREATE TABLE [VendorType]( [VendorTypeId] [int] NOT NULL, [VendorTypeName] [varchar](50) NOT NULL )"; temp.ExecuteQuery(query); } } catch (Exception ex) { throw ex; } }
public void CreateUserTable() { try { string query = @"CREATE TABLE Users( [UserId] [int] NOT NULL, [UserName] [varchar](50) NOT NULL, [UserPassword] [varchar](500) NOT NULL, [UserFullName] [varchar](500) NULL, [ContactNumber] [varchar](50) NULL, [EmailId] [varchar](50) NULL, [RoleId] [int] NOT NULL )" ; temp.ExecuteQuery(query); } catch (Exception ex) { throw ex; } }
public bool SyncVendorType() { try { VendorRepository vendor = new VendorRepository(); vendor.CreateVendorTypeTable(); vendor.CreateVendorTable(); fun.OpenConnection(); if (fun.getConnection().State == ConnectionState.Open) { string query = @"select VendorTypeId, VendorTypeName from VendorType"; DataSet ds = fun.fillComboDataset(query); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { query = "Delete from VendorType"; temp.ExecuteQuery(query); foreach (DataRow dr in ds.Tables[0].Rows) { query = String.Format(@"INSERT INTO VendorType(VendorTypeId, VendorTypeName) VALUES({0},'{1}')", dr["VendorTypeId"].ToString(), dr["VendorTypeName"].ToString()); temp.ExecuteQuery(query); } } } } catch (Exception ex) { throw ex; } return(true); }