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);
}
