public static void insertHashToFiles() { FTDataSet ds = new FTDataSet(); FilesforUpdateNameTableAdapter files = new FilesforUpdateNameTableAdapter(); files.Fill(ds.FilesforUpdateName); try { foreach (DataRow dr in ds.FilesforUpdateName.Rows) { MATCFileNameFullExtensoinResult match = RegEx.GetMATCFileNameFullExtensoinResult(dr["name"].ToString()).FirstOrDefault(); string _result = null; if (match != null) { _result = match.UNOM + match.Name + match.Date + "_" + dr["Hash"].ToString() + "." + match.Extension; if (dr["name"].ToString() != _result) { dr["name"] = _result; } } }; } finally { if (ds.FilesforUpdateName.HasErrors) { } else // If no errors, AcceptChanges. if (ds.FilesforUpdateName.GetChanges() != null) { files.Update(ds.FilesforUpdateName); } } }
public static void ActFiles_normalizationName() { MATCFileNameFull q = new MATCFileNameFull(); FTDataSet ds = new FTDataSet(); CommonTableAdapter cta = new CommonTableAdapter(); ActFilesforUpdateNameTableAdapter f4 = new ActFilesforUpdateNameTableAdapter(); f4.Fill(ds.ActFilesforUpdateName); try { /*var rr = ds.ActFilesforUpdateName.Where(selector => { MATCFileNameFullExtensoinResult match1 = RegEx.GetMATCFileNameFullExtensoinResult(selector["name"].ToString()).FirstOrDefault(); if (match1 != null && string.IsNullOrEmpty(match1.Name)) { return true; } else { return false; }; }).ToList();*/ foreach (DataRow dr in ds.ActFilesforUpdateName.Rows) { string _result = null; MATCFileNameFullExtensoinResult match = RegEx.GetMATCFileNameFullExtensoinResult(dr["name"].ToString().Trim()).FirstOrDefault(); if (match != null) { Console.WriteLine(dr["name"].ToString() + " добавляется"); if (string.IsNullOrEmpty(match.Name)) { _result = match.UNOM + "_фото_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + match.Extension; } else { _result = match.UNOM + match.Name + "_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + match.Extension; } if (dr["Name"].ToString() != _result) { //dr.SetField<string>("Name", _result); try { cta.Update_ActFiles_names_Query(_result, dr["path_locator"].ToString()); Console.WriteLine(_result); } catch (Exception e) { Console.WriteLine(_result + e.Message); } }; } else { _result = dr["UNOM"].ToString() + "_фото_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + dr["file_type"].ToString(); Console.WriteLine(dr["name"].ToString() + " добавляется"); cta.Update_ActFiles_names_Query(_result, dr["path_locator"].ToString()); }; } } finally { if (ds.ActFilesforUpdateName.HasErrors) { } else // If no errors, AcceptChanges. if (ds.ActFilesforUpdateName.GetChanges() != null) { //ds.Files4forUpdateName.AcceptChanges(); f4.Update(ds.ActFilesforUpdateName); } } }
public static void mainFileContainer_insertFoto() { MATCFileNameFull q = new MATCFileNameFull(); FTDataSet ds = new FTDataSet(); mainFileContainer_for_updateNameTableAdapter f4 = new mainFileContainer_for_updateNameTableAdapter(); string _name = "_фото"; f4.Fill(ds.mainFileContainer_for_updateName); try { var rr = ds.mainFileContainer_for_updateName.Where(selector => { MATCFileNameFullExtensoinResult match1 = RegEx.GetMATCFileNameFullExtensoinResult(selector["name"].ToString()).FirstOrDefault(); if (match1 != null && string.IsNullOrEmpty(match1.Name)) { return true; } else { return false; }; }); foreach (DataRow dr in ds.mainFileContainer_for_updateName.Rows) { MATCFileNameFullExtensoinResult match = RegEx.GetMATCFileNameFullExtensoinResult(dr["name"].ToString()).FirstOrDefault(); if (match != null && string.IsNullOrEmpty(match.Name)) { string _result = null; _result = match.UNOM + _name + "_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + match.Extension; if (dr["Name"].ToString() != _result) { dr.SetField<string>("Name", _result); }; }; } } finally { if (ds.mainFileContainer_for_updateName.HasErrors) { } else // If no errors, AcceptChanges. if (ds.mainFileContainer_for_updateName.GetChanges() != null) { //ds.Files4forUpdateName.AcceptChanges(); f4.Update(ds.mainFileContainer_for_updateName); } } }
public static void insertHashToFiles4(string fileNamePart) { FTDataSet ds = new FTDataSet(); CommonTableAdapter upA = new CommonTableAdapter(); Files4forUpdateNameTableAdapter f4 = new Files4forUpdateNameTableAdapter(); CommonTableAdapter cta = new CommonTableAdapter(); f4.Fill(ds.Files4forUpdateName, fileNamePart); try { foreach (DataRow dr in ds.Files4forUpdateName.Rows) { MATCFileNameFullExtensoinResult match = RegEx.GetMATCFileNameFullExtensoinResult(dr["name"].ToString()).FirstOrDefault(); if (match != null) { string _result = null; _result = match.UNOM + match.Name + "_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + match.Extension; if (dr["Name"].ToString() != _result) { dr.SetField<string>("Name", _result); }; }; } } finally { if (ds.Files4forUpdateName.HasErrors) { } else // If no errors, AcceptChanges. if (ds.Files4forUpdateName.GetChanges() != null) { //ds.Files4forUpdateName.AcceptChanges(); f4.Update(ds.Files4forUpdateName); } } }
public static void Files4updateName_insertFoto(string fileNamePart) { MATCFileNameFull q = new MATCFileNameFull(); FTDataSet ds = new FTDataSet(); Files4forUpdateNameTableAdapter f4 = new Files4forUpdateNameTableAdapter(); string _name = "_фото"; f4.Fill(ds.Files4forUpdateName, null); try { foreach (DataRow dr in ds.Files4forUpdateName.Rows) { MATCFileNameFullExtensoinResult match = RegEx.GetMATCFileNameFullExtensoinResult(dr["name"].ToString()).FirstOrDefault(); if (match != null && string.IsNullOrEmpty(match.Name)) { string _result = null; _result = match.UNOM + _name + "_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + match.Extension; if (dr["Name"].ToString() != _result) { dr.SetField<string>("Name", _result); }; }; } } finally { if (ds.Files4forUpdateName.HasErrors) { } else // If no errors, AcceptChanges. if (ds.Files4forUpdateName.GetChanges() != null) { //ds.Files4forUpdateName.AcceptChanges(); f4.Update(ds.Files4forUpdateName); } } }
public static void mainFileContainer_normalizationName() { MATCFileNameFull q = new MATCFileNameFull(); FTDataSet ds = new FTDataSet(); CommonTableAdapter cta = new CommonTableAdapter(); mainFileContainer_for_updateNameTableAdapter f4 = new mainFileContainer_for_updateNameTableAdapter(); f4.Connection.ConnectionString = "Data Source=MAKSIMOV;Initial Catalog=GBUMATC;Persist Security Info=True;Connection Timeout=50000000;User ID=Бушмакин;Password=453459"; FTDataSet.mainFileContainer_for_updateNameDataTable wtable = ds.mainFileContainer_for_updateName; f4.Fill(wtable); try { /*var rr = wtable.Where(selector => { MATCFileNameFullExtensoinResult match1 = RegEx.GetMATCFileNameFullExtensoinResult(selector["name"].ToString()).FirstOrDefault(); if (match1 != null && string.IsNullOrEmpty(match1.Name)) { return true; } else { return false; }; }).ToList();*/ foreach (DataRow dr in wtable.Rows) { string _result = null; MATCFileNameFullExtensoinResult match = RegEx.GetMATCFileNameFullExtensoinResult(dr["name"].ToString().Trim()).FirstOrDefault(); if (match != null) { Console.WriteLine(dr["name"].ToString() + " добавляется"); if (string.IsNullOrEmpty(match.Name)) { _result = match.UNOM + "_фото_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + match.Extension; } else { _result = match.UNOM + match.Name + "_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + match.Extension; } if (dr["Name"].ToString() != _result) { dr.SetField<string>("Name", _result); try { //cta.Update_mainFileContainer_Query(_result, dr["path_locator"].ToString()); Console.WriteLine(_result); } catch (Exception e) { Console.WriteLine(_result + e.Message); } }; } else { //_result = dr["UNOM"].ToString() + "_фото_" + dr["fdate"].ToString() + "_" + dr["Hash"].ToString() + "." + dr["file_type"].ToString(); Console.WriteLine(dr["name"].ToString() + " херня-с"); //cta.Update_ActFiles_names_Query(_result, dr["path_locator"].ToString()); //dr.SetField<string>("Name", _result); }; } } finally { if (wtable.HasErrors) { } else // If no errors, AcceptChanges. if (wtable.GetChanges() != null) { //ds.Files4forUpdateName.AcceptChanges(); f4.Update(wtable); } } }