public static bool Save(Template Template, out string Err) { Err = ""; try { using (var ConX = new MySqlConnection(DBOps.GetConnectionString(Template.Environment))) { ConX.Open(); if (string.IsNullOrWhiteSpace(Template.Environment)) { if (Template.TemplateID <= 0) { return(Template.Create(out Err, ConX)); } else { return(Template.Update(out Err, ConX)); } } else { return(Template.CopySave(out Err, ConX)); } } } catch (Exception ex) { Err = ex.Message; return(false); } }
public bool Save(out string Err) { Err = ""; try { using (var ConX = new MySqlConnection(DBOps.GetConnectionString(Environment))) { ConX.Open(); if (!string.IsNullOrWhiteSpace(Environment)) { GetIDFromDescription(ConX); } if (ID <= 0) { return(Create(out Err, ConX)); } else { return(Update(out Err, ConX)); } } } catch (Exception ex) { Err = ex.Message; return(false); } }
public static bool Save(TSFile File, out string Err, bool ResetOwnerIfNotFound = true) { Err = ""; try { using (var ConX = new MySqlConnection(DBOps.GetConnectionString(File.Environment))) { ConX.Open(); if (!string.IsNullOrWhiteSpace(File.Environment)) { File.GetIDFromDescription(ConX, true, ResetOwnerIfNotFound); } if (File.TeleSoftwareID <= 0) { return(File.Create(out Err, ConX)); } else { return(File.Update(out Err, ConX)); } } } catch (Exception ex) { Err = ex.Message; return(false); } }
public bool IsPageRangeValid() { using (var con = new MySqlConnection(DBOps.GetConnectionString(Environment))) { con.Open(); string sql = @"SELECT COUNT(*) AS cnt FROM `page` WHERE PageID<>@PageID AND FromPageFrameNo<@ToPageFrameNo AND @FromPageFrameNo<ToPageFrameNo;"; var cmd = new MySqlCommand(sql, con); cmd.Parameters.AddWithValue("FromPageFrameNo", NormalisedFromPageFrameNo); cmd.Parameters.AddWithValue("ToPageFrameNo", NormalisedToPageFrameNo); cmd.Parameters.AddWithValue("PageID", PageID); return(cmd.ExecuteScalarInt32() == 0); } }