public bool Restore(TemplateBackup tbk, int cid) { TZ.CompExtention.Builder.Data.ComponentBuilder db = new Builder.Data.ComponentBuilder(Connection); if (tbk.BackupType == 1) { try { db.ClearTemplate(cid); PushTemplate(tbk); } catch (Exception ex) { throw ex; } } else { db.ClearComponent(); try { PushComponent(tbk); } catch (Exception ex) { throw ex; } try { PushComponentAttribute(tbk); } catch (Exception ex) { throw ex; } try { PushView(tbk); } catch (Exception ex) { throw ex; } try { PushTemplate(tbk); } catch (Exception ex) { throw ex; } } return(true); }
private bool PushTemplate(TemplateBackup tb) { // dm = new DataManager(); // dm.tableName(TZ.CompExtention.Builder.Schema.TalentozTemplate.Table); // List<string> fileContent = new List<string>(); // List<string> cols = new List<string>(); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.TemplateID.Name.ToString() + "\""); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.ClientID.Name.ToString() + "\""); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.ViewID.Name.ToString() + "\""); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.TemplateCode.Name.ToString() + "\""); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.Name.Name.ToString() + "\""); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.Category.Name.ToString() + "\""); //// cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.PivotColumn.Name.ToString() + "\""); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.TemplateType.Name.ToString() + "\""); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozTemplate.ViewFields.Name.ToString() + "\""); // fileContent.Add(string.Join(",", cols.ToArray())); foreach (Template c in tb.Templates) { c.ClientID = ClientID; try { c.Import(Connection); } catch (Exception ex) { } // List<string> rows = new List<string>(); // rows.Add("\"" + c.TemplateID + "\""); // rows.Add("\"" + ClientID + "\""); // rows.Add("\"" + c.ViewID + "\""); // rows.Add("\"" + c.Code + "\""); // rows.Add("\"" + c.Name + "\""); // rows.Add("\"" + c.Category + "\""); //// rows.Add("\"" + c.pivo + "\""); // rows.Add("'" + Newtonsoft.Json.JsonConvert.SerializeObject( c.TemplateFields).Trim() + "'"); // fileContent.Add(string.Join(",", rows.ToArray())); } //dm.Data(fileContent.ToArray()); //try //{ // dm.ExecuteNonQuery(Connection); //} //catch (Exception ex) //{ // throw new Exception(ex.Message); //} return(true); }
private bool PushView(TemplateBackup tb) { dm = new DataManager(); dm.tableName(TZ.CompExtention.Builder.Schema.TalentozView.Table); List <string> fileContent = new List <string>(); List <string> cols = new List <string>(); List <string> fileContent_vr = new List <string>(); List <string> cols_vr = new List <string>(); List <string> fileContent_vr_item = new List <string>(); List <string> cols_vr_item = new List <string>(); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozView.ViewID.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozView.CoreComponent.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozView.Name.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozView.Catgory.Name.ToString() + "\""); fileContent.Add(string.Join(",", cols.ToArray())); cols_vr.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchema.ViewID.Name.ToString() + "\""); cols_vr.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchema.ComponentID.Name.ToString() + "\""); cols_vr.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchema.ChildComponentID.Name.ToString() + "\""); cols_vr.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchema.ComponentAlias.Name.ToString() + "\""); fileContent_vr.Add(string.Join(",", cols_vr.ToArray())); cols_vr_item.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.ViewID.Name.ToString() + "\""); cols_vr_item.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.ViewSchemaRelation.Name.ToString() + "\""); cols_vr_item.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.ParentField.Name.ToString() + "\""); cols_vr_item.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.RelatedField.Name.ToString() + "\""); cols_vr_item.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.Parent.Name.ToString() + "\""); cols_vr_item.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.Child.Name.ToString() + "\""); fileContent_vr_item.Add(string.Join(",", cols_vr_item.ToArray())); foreach (ComponentView v in tb.Views) { List <string> rows = new List <string>(); rows.Add("\"" + v.ID + "\""); rows.Add("\"" + v.CoreComponent + "\""); rows.Add("\"" + v.Name + "\""); rows.Add("\"" + v.Category + "\""); fileContent.Add(string.Join(",", rows.ToArray())); foreach (ComponentRelation vr in v.ComponentRelations) { vr.ViewID = v.ID; rows = new List <string>(); rows.Add("\"" + vr.ViewID + "\""); rows.Add("\"" + vr.ComponentID + "\""); rows.Add("\"" + vr.ChildComponentID + "\""); rows.Add("\"" + vr.ComponentAlias + "\""); fileContent_vr.Add(string.Join(",", rows.ToArray())); foreach (ViewRelation vritem in vr.Relationship) { rows = new List <string>(); rows.Add("\"" + vr.ViewID + "\""); rows.Add("\"" + vritem.ID + "\""); rows.Add("\"" + vritem.LeftField + "\""); rows.Add("\"" + vritem.RightField + "\""); rows.Add("\"" + vritem.Left + "\""); rows.Add("\"" + vritem.Right + "\""); fileContent_vr_item.Add(string.Join(",", rows.ToArray())); } } } dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozView.ViewID.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozView.CoreComponent.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozView.Name.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozView.Catgory.Name.ToString(), FieldType._string); dm.Data(fileContent.ToArray()); try { dm.ExecuteNonQuery(Connection); } catch (Exception ex) { throw new Exception(ex.Message); } if (fileContent_vr.Count > 1) { var dm1 = new DataManager(); dm1.tableName(TZ.CompExtention.Builder.Schema.TalentozViewSchema.Table); dm1.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchema.ViewID.Name.ToString(), FieldType._string); dm1.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchema.ComponentID.Name.ToString(), FieldType._string); dm1.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchema.ChildComponentID.Name.ToString(), FieldType._string); dm1.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchema.ComponentAlias.Name.ToString(), FieldType._string); dm1.Data(fileContent_vr.ToArray()); try { dm1.ExecuteNonQuery(Connection); } catch (Exception ex) { throw new Exception(ex.Message); } } if (fileContent_vr_item.Count > 1) { var dm2 = new DataManager(); dm2.tableName(TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.Table); dm2.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.ViewID.Name.ToString(), FieldType._string); dm2.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.ViewSchemaRelation.Name.ToString(), FieldType._string); dm2.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.ParentField.Name.ToString(), FieldType._string); dm2.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.RelatedField.Name.ToString(), FieldType._string); dm2.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.Parent.Name.ToString(), FieldType._string); dm2.InsertInto(TZ.CompExtention.Builder.Schema.TalentozViewSchemaRelation.Child.Name.ToString(), FieldType._string); dm2.Data(fileContent_vr_item.ToArray()); try { dm2.ExecuteNonQuery(Connection); } catch (Exception ex) { throw new Exception(ex.Message); } } return(true); }
private bool PushComponent(TemplateBackup tb) { //dm = new DataManager(); //dm.tableName(TZ.CompExtention.Builder.Schema.TalentozSchema.Table); //List<string> fileContent = new List<string>(); //List<string> cols = new List<string>(); //foreach (var col in tb.Components ) //{ // cols.Add(("\"" + col.ToString() + "\"")); //} //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.ComponentID.Name.ToString() + "\""); //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.ComponentName.Name.ToString() + "\""); //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.Category.Name.ToString() + "\""); //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.ComponentType.Name.ToString() + "\""); //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.Title.Name.ToString() + "\""); //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.PrimaryKeys.Name.ToString() + "\""); //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.TableName.Name.ToString() + "\""); ////cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.IsGlobal.Name.ToString() + "\""); ////cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.ComponentState.Name.ToString() + "\""); //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.EntityKey.Name.ToString() + "\""); ////cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchema.ComponentID.Name.ToString() + "\""); //fileContent.Add(string.Join(",", cols.ToArray())); TZ.CompExtention.DataAccess.ComponentDataHandler d = new DataAccess.ComponentDataHandler(Connection); foreach (Component c in tb.Components) { try { d.ImportComponent(c); } catch (Exception ex) { } //List<string> rows = new List<string>(); ////foreach (var column in dr.ItemArray) ////{ // rows.Add("\"" + c.ID + "\""); //rows.Add("\"" + c.Name + "\""); //rows.Add("\"" + c.Category + "\""); //rows.Add("\"" + Convert.ToInt32( c.Type )+ "\""); //rows.Add("\"" + c.Title + "\""); //rows.Add("\"" + c.Keys + "\""); //rows.Add("\"" + c.TableName + "\""); //rows.Add("\"" + c.EntityKey + "\""); ////rows.Add("\"" + c.ID + "\""); ////rows.Add("\"" + c.ID + "\""); ////rows.Add("\"" + c.ID + "\""); ////rows.Add("\"" + c.ID + "\""); /////} //fileContent.Add(string.Join(",", rows.ToArray())); } //dm.Data(fileContent.ToArray()); //try //{ // dm.ExecuteNonQuery(Connection); //} //catch (Exception ex) { // throw new Exception(ex.Message); //} return(true); }
private bool PushComponentAttribute(TemplateBackup tb) { dm = new DataManager(); dm.tableName(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.Table); List <string> fileContent = new List <string>(); List <string> cols = new List <string>(); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.AttributeName.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.DisplayName.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.ComponentID.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.FieldID.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsRequired.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsUnique.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsCore.Name.ToString() + "\""); //cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsReadOnly.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsSecured.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.LookUpID.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.AttributeType.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.Length.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.DefaultValue.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.FileExtension.Name.ToString() + "\""); // cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.RegExp.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsNullable.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.ISPrimaryKey.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.LookupComponent.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.ComponentLookupDisplayName.Name.ToString() + "\""); cols.Add("\"" + TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsAuto.Name.ToString() + "\""); fileContent.Add(string.Join(",", cols.ToArray())); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.AttributeName.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.DisplayName.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.ComponentID.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.FieldID.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsRequired.Name.ToString(), FieldType._bool); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsUnique.Name.ToString(), FieldType._bool); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsCore.Name.ToString(), FieldType._bool); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsSecured.Name.ToString(), FieldType._bool); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.LookUpID.Name.ToString(), FieldType._bool); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.AttributeType.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.Length.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.DefaultValue.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.FileExtension.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsNullable.Name.ToString(), FieldType._bool); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.ISPrimaryKey.Name.ToString(), FieldType._bool); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.LookupComponent.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.ComponentLookupDisplayName.Name.ToString(), FieldType._string); dm.InsertInto(TZ.CompExtention.Builder.Schema.TalentozSchemaInfo.IsAuto.Name.ToString(), FieldType._bool); foreach (Attribute c in tb.Attributes) { List <string> rows = new List <string>(); rows.Add("\"" + c.Name + "\""); rows.Add("\"" + c.DisplayName + "\""); rows.Add("\"" + c.ComponentID + "\""); rows.Add("\"" + c.ID + "\""); rows.Add("\"" + c.IsRequired + "\""); rows.Add("\"" + c.IsUnique + "\""); rows.Add("\"" + c.IsCore + "\""); rows.Add("\"" + c.IsSecured + "\""); rows.Add("\"" + c.LookupInstanceID + "\""); rows.Add("\"" + Convert.ToInt32(c.Type) + "\""); rows.Add("\"" + c.Length + "\""); rows.Add("\"" + c.DefaultValue + "\""); rows.Add("\"" + c.FileExtension + "\""); rows.Add("\"" + c.IsNullable + "\""); rows.Add("\"" + c.IsKey + "\""); rows.Add("\"" + c.ComponentLookup + "\""); rows.Add("\"" + c.ComponentLookupDisplayField + "\""); rows.Add("\"" + c.IsAuto + "\""); fileContent.Add(string.Join(",", rows.ToArray())); } dm.Data(fileContent.ToArray()); try { dm.ExecuteNonQuery(Connection); } catch (Exception ex) { throw new Exception(ex.Message); } return(true); }