///<summary>Inserts one LanguageForeign into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(LanguageForeign languageForeign, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
languageForeign.LanguageForeignNum = ReplicationServers.GetKey("languageforeign", "LanguageForeignNum");
}
string command = "INSERT INTO languageforeign (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "LanguageForeignNum,";
}
command += "ClassType,English,Culture,Translation,Comments) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(languageForeign.LanguageForeignNum) + ",";
}
command +=
"'" + POut.String(languageForeign.ClassType) + "',"
+ "'" + POut.String(languageForeign.English) + "',"
+ "'" + POut.String(languageForeign.Culture) + "',"
+ "'" + POut.String(languageForeign.Translation) + "',"
+ "'" + POut.String(languageForeign.Comments) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
languageForeign.LanguageForeignNum = Db.NonQ(command, true);
}
return(languageForeign.LanguageForeignNum);
}
///<summary>Inserts one LanguageForeign into the database. Returns the new priKey.</summary>
internal static long Insert(LanguageForeign languageForeign)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
languageForeign.LanguageForeignNum=DbHelper.GetNextOracleKey("languageforeign","LanguageForeignNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(languageForeign,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
languageForeign.LanguageForeignNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(languageForeign,false);
}
}
///<summary>Inserts one LanguageForeign into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(LanguageForeign languageForeign,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
languageForeign.LanguageForeignNum=ReplicationServers.GetKey("languageforeign","LanguageForeignNum");
}
string command="INSERT INTO languageforeign (";
if(useExistingPK || PrefC.RandomKeys) {
command+="LanguageForeignNum,";
}
command+="ClassType,English,Culture,Translation,Comments) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(languageForeign.LanguageForeignNum)+",";
}
command+=
"'"+POut.String(languageForeign.ClassType)+"',"
+"'"+POut.String(languageForeign.English)+"',"
+"'"+POut.String(languageForeign.Culture)+"',"
+"'"+POut.String(languageForeign.Translation)+"',"
+"'"+POut.String(languageForeign.Comments)+"')";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
languageForeign.LanguageForeignNum=Db.NonQ(command,true);
}
return languageForeign.LanguageForeignNum;
}
///<summary>Inserts one LanguageForeign into the database. Returns the new priKey.</summary>
public static long Insert(LanguageForeign languageForeign)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
languageForeign.LanguageForeignNum = DbHelper.GetNextOracleKey("languageforeign", "LanguageForeignNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(languageForeign, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
languageForeign.LanguageForeignNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(languageForeign, false));
}
}
///<summary>lanForeign might be null.</summary>
public FormTranslationEdit(Language lanCur, LanguageForeign lanForeign, string otherTrans)
{
InitializeComponent();
//no need to translate anything here
LanCur = lanCur;
LanForeign = lanForeign;
OtherTrans = otherTrans;
}
///<summary>Inserts one LanguageForeign into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(LanguageForeign languageForeign, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO languageforeign (";
if (!useExistingPK && isRandomKeys)
{
languageForeign.LanguageForeignNum = ReplicationServers.GetKeyNoCache("languageforeign", "LanguageForeignNum");
}
if (isRandomKeys || useExistingPK)
{
command += "LanguageForeignNum,";
}
command += "ClassType,English,Culture,Translation,Comments) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(languageForeign.LanguageForeignNum) + ",";
}
command +=
DbHelper.ParamChar + "paramClassType,"
+ DbHelper.ParamChar + "paramEnglish,"
+ "'" + POut.String(languageForeign.Culture) + "',"
+ DbHelper.ParamChar + "paramTranslation,"
+ DbHelper.ParamChar + "paramComments)";
if (languageForeign.ClassType == null)
{
languageForeign.ClassType = "";
}
OdSqlParameter paramClassType = new OdSqlParameter("paramClassType", OdDbType.Text, POut.StringParam(languageForeign.ClassType));
if (languageForeign.English == null)
{
languageForeign.English = "";
}
OdSqlParameter paramEnglish = new OdSqlParameter("paramEnglish", OdDbType.Text, POut.StringParam(languageForeign.English));
if (languageForeign.Translation == null)
{
languageForeign.Translation = "";
}
OdSqlParameter paramTranslation = new OdSqlParameter("paramTranslation", OdDbType.Text, POut.StringParam(languageForeign.Translation));
if (languageForeign.Comments == null)
{
languageForeign.Comments = "";
}
OdSqlParameter paramComments = new OdSqlParameter("paramComments", OdDbType.Text, POut.StringParam(languageForeign.Comments));
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command, paramClassType, paramEnglish, paramTranslation, paramComments);
}
else
{
languageForeign.LanguageForeignNum = Db.NonQ(command, true, "LanguageForeignNum", "languageForeign", paramClassType, paramEnglish, paramTranslation, paramComments);
}
return(languageForeign.LanguageForeignNum);
}
///<summary></summary>
public static void Delete(LanguageForeign lf)
{
string command = "DELETE from languageforeign "
+ "WHERE ClassType=BINARY '" + POut.PString(lf.ClassType) + "' "
+ "AND English=BINARY '" + POut.PString(lf.English) + "' "
+ "AND Culture='" + CultureInfo.CurrentCulture.Name + "'";
General.NonQ(command);
}
///<summary></summary>
public static void Update(LanguageForeign lf)
{
string command = "UPDATE languageforeign SET "
+ "Translation = '" + POut.PString(lf.Translation) + "'"
+ ",Comments = '" + POut.PString(lf.Comments) + "'"
+ " WHERE ClassType= BINARY '" + POut.PString(lf.ClassType) + "'"
+ " AND English= BINARY '" + POut.PString(lf.English) + "'"
+ " AND Culture= '" + CultureInfo.CurrentCulture.Name + "'";
General.NonQ(command);
}
///<summary>Updates one LanguageForeign in the database.</summary>
internal static void Update(LanguageForeign languageForeign)
{
string command = "UPDATE languageforeign SET "
+ "ClassType = '" + POut.String(languageForeign.ClassType) + "', "
+ "English = '" + POut.String(languageForeign.English) + "', "
+ "Culture = '" + POut.String(languageForeign.Culture) + "', "
+ "Translation = '" + POut.String(languageForeign.Translation) + "', "
+ "Comments = '" + POut.String(languageForeign.Comments) + "' "
+ "WHERE LanguageForeignNum = " + POut.Long(languageForeign.LanguageForeignNum);
Db.NonQ(command);
}
///<summary>Updates one LanguageForeign in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables.</summary>
internal static void Update(LanguageForeign languageForeign, LanguageForeign oldLanguageForeign)
{
string command = "";
if (languageForeign.ClassType != oldLanguageForeign.ClassType)
{
if (command != "")
{
command += ",";
}
command += "ClassType = '" + POut.String(languageForeign.ClassType) + "'";
}
if (languageForeign.English != oldLanguageForeign.English)
{
if (command != "")
{
command += ",";
}
command += "English = '" + POut.String(languageForeign.English) + "'";
}
if (languageForeign.Culture != oldLanguageForeign.Culture)
{
if (command != "")
{
command += ",";
}
command += "Culture = '" + POut.String(languageForeign.Culture) + "'";
}
if (languageForeign.Translation != oldLanguageForeign.Translation)
{
if (command != "")
{
command += ",";
}
command += "Translation = '" + POut.String(languageForeign.Translation) + "'";
}
if (languageForeign.Comments != oldLanguageForeign.Comments)
{
if (command != "")
{
command += ",";
}
command += "Comments = '" + POut.String(languageForeign.Comments) + "'";
}
if (command == "")
{
return;
}
command = "UPDATE languageforeign SET " + command
+ " WHERE LanguageForeignNum = " + POut.Long(languageForeign.LanguageForeignNum);
Db.NonQ(command);
}
///<summary></summary>
public static void Insert(LanguageForeign lf)
{
string command = "INSERT INTO languageforeign(ClassType,English,Culture"
+ ",Translation,Comments) "
+ "VALUES("
+ "'" + POut.PString(lf.ClassType) + "', "
+ "'" + POut.PString(lf.English) + "', "
+ "'" + POut.PString(lf.Culture) + "', "
+ "'" + POut.PString(lf.Translation) + "', "
+ "'" + POut.PString(lf.Comments) + "')";
General.NonQ(command);
}
///<summary>Inserts one LanguageForeign into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(LanguageForeign languageForeign)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(languageForeign, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
languageForeign.LanguageForeignNum = DbHelper.GetNextOracleKey("languageforeign", "LanguageForeignNum"); //Cacheless method
}
return(InsertNoCache(languageForeign, true));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<LanguageForeign> TableToList(DataTable table){
List<LanguageForeign> retVal=new List<LanguageForeign>();
LanguageForeign languageForeign;
for(int i=0;i<table.Rows.Count;i++) {
languageForeign=new LanguageForeign();
languageForeign.LanguageForeignNum= PIn.Long (table.Rows[i]["LanguageForeignNum"].ToString());
languageForeign.ClassType = PIn.String(table.Rows[i]["ClassType"].ToString());
languageForeign.English = PIn.String(table.Rows[i]["English"].ToString());
languageForeign.Culture = PIn.String(table.Rows[i]["Culture"].ToString());
languageForeign.Translation = PIn.String(table.Rows[i]["Translation"].ToString());
languageForeign.Comments = PIn.String(table.Rows[i]["Comments"].ToString());
retVal.Add(languageForeign);
}
return retVal;
}
private void gridLan_CellDoubleClick(object sender, OpenDental.UI.ODGridClickEventArgs e)
{
Language LanCur = LanList[e.Row];
LanguageForeign lanForeign = LanguageForeigns.GetForCulture(ListForType, LanCur.English, CultureInfo.CurrentCulture.Name);
LanguageForeign lanForeignOther = LanguageForeigns.GetOther(ListForType, LanCur.English, CultureInfo.CurrentCulture.Name);
string otherTrans = "";
if (lanForeignOther != null)
{
otherTrans = lanForeignOther.Translation;
}
FormTranslationEdit FormTE = new FormTranslationEdit(LanCur, lanForeign, otherTrans);
FormTE.ShowDialog();
FillGrid();
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <LanguageForeign> TableToList(DataTable table)
{
List <LanguageForeign> retVal = new List <LanguageForeign>();
LanguageForeign languageForeign;
for (int i = 0; i < table.Rows.Count; i++)
{
languageForeign = new LanguageForeign();
languageForeign.LanguageForeignNum = PIn.Long(table.Rows[i]["LanguageForeignNum"].ToString());
languageForeign.ClassType = PIn.String(table.Rows[i]["ClassType"].ToString());
languageForeign.English = PIn.String(table.Rows[i]["English"].ToString());
languageForeign.Culture = PIn.String(table.Rows[i]["Culture"].ToString());
languageForeign.Translation = PIn.String(table.Rows[i]["Translation"].ToString());
languageForeign.Comments = PIn.String(table.Rows[i]["Comments"].ToString());
retVal.Add(languageForeign);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <LanguageForeign> TableToList(DataTable table)
{
List <LanguageForeign> retVal = new List <LanguageForeign>();
LanguageForeign languageForeign;
foreach (DataRow row in table.Rows)
{
languageForeign = new LanguageForeign();
languageForeign.LanguageForeignNum = PIn.Long(row["LanguageForeignNum"].ToString());
languageForeign.ClassType = PIn.String(row["ClassType"].ToString());
languageForeign.English = PIn.String(row["English"].ToString());
languageForeign.Culture = PIn.String(row["Culture"].ToString());
languageForeign.Translation = PIn.String(row["Translation"].ToString());
languageForeign.Comments = PIn.String(row["Comments"].ToString());
retVal.Add(languageForeign);
}
return(retVal);
}
///<summary>Only used during export to get a list of all translations for specified culture only.</summary>
public static LanguageForeign[] GetListForCulture(CultureInfo cultureInfo)
{
string command =
"SELECT * FROM languageforeign "
+ "WHERE Culture='" + CultureInfo.CurrentCulture.Name + "'";
DataTable table = General.GetTable(command);
LanguageForeign[] List = new LanguageForeign[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new LanguageForeign();
List[i].ClassType = PIn.PString(table.Rows[i][0].ToString());
List[i].English = PIn.PString(table.Rows[i][1].ToString());
List[i].Culture = PIn.PString(table.Rows[i][2].ToString());
List[i].Translation = PIn.PString(table.Rows[i][3].ToString());
List[i].Comments = PIn.PString(table.Rows[i][4].ToString());
}
return(List);
}
///<summary>Called once when the program first starts up. Then only if user downloads new translations or adds their own.</summary>
public static void Refresh(CultureInfo cultureInfo)
{
HList = new Hashtable();
if (CultureInfo.CurrentCulture.Name == "en-US")
{
return;
}
//load all translations for the current culture, using other culture of same language if no trans avail.
string command =
"SELECT * FROM languageforeign "
+ "WHERE Culture LIKE '" + cultureInfo.TwoLetterISOLanguageName + "%' "
+ "ORDER BY Culture";
DataTable table = General.GetTable(command);
LanguageForeign lf;
for (int i = 0; i < table.Rows.Count; i++)
{
lf = new LanguageForeign();
lf.ClassType = PIn.PString(table.Rows[i][0].ToString());
lf.English = PIn.PString(table.Rows[i][1].ToString());
lf.Culture = PIn.PString(table.Rows[i][2].ToString());
lf.Translation = PIn.PString(table.Rows[i][3].ToString());
lf.Comments = PIn.PString(table.Rows[i][4].ToString());
if (lf.Culture == cultureInfo.Name) //if exact culture match
{
if (HList.ContainsKey(lf.ClassType + lf.English))
{
HList.Remove(lf.ClassType + lf.English); //remove any existing entry
}
HList.Add(lf.ClassType + lf.English, lf);
}
else //or if any other culture of same language
{
if (!HList.ContainsKey(lf.ClassType + lf.English))
{
//only add if not already in HList
HList.Add(lf.ClassType + lf.English, lf);
}
}
}
}
private void FormTranslationEdit_Load(object sender, System.EventArgs e)
{
textEnglish.Text = LanCur.English;
textOtherTranslation.Text = OtherTrans;
if (LanForeign == null)
{
LanForeign = new LanguageForeign();
LanForeign.ClassType = LanCur.ClassType;
LanForeign.English = LanCur.English;
LanForeign.Culture = CultureInfo.CurrentCulture.Name;
Text = "Add Translation";
IsNew = true;
}
else
{
//LanguageForeigns.Cur=((LanguageForeign)LanguageForeigns.HList[Lan.Cur.ClassType+Lan.Cur.English]);
textTranslation.Text = LanForeign.Translation;
textComments.Text = LanForeign.Comments;
Text = "Edit Translation";
IsNew = false;
}
}
///<summary>Returns true if Update(LanguageForeign,LanguageForeign) would make changes to the database.
///Does not make any changes to the database and can be called before remoting role is checked.</summary>
public static bool UpdateComparison(LanguageForeign languageForeign, LanguageForeign oldLanguageForeign)
{
if (languageForeign.ClassType != oldLanguageForeign.ClassType)
{
return(true);
}
if (languageForeign.English != oldLanguageForeign.English)
{
return(true);
}
if (languageForeign.Culture != oldLanguageForeign.Culture)
{
return(true);
}
if (languageForeign.Translation != oldLanguageForeign.Translation)
{
return(true);
}
if (languageForeign.Comments != oldLanguageForeign.Comments)
{
return(true);
}
return(false);
}
///<summary>Updates one LanguageForeign in the database.</summary>
public static void Update(LanguageForeign languageForeign)
{
string command = "UPDATE languageforeign SET "
+ "ClassType = " + DbHelper.ParamChar + "paramClassType, "
+ "English = " + DbHelper.ParamChar + "paramEnglish, "
+ "Culture = '" + POut.String(languageForeign.Culture) + "', "
+ "Translation = " + DbHelper.ParamChar + "paramTranslation, "
+ "Comments = " + DbHelper.ParamChar + "paramComments "
+ "WHERE LanguageForeignNum = " + POut.Long(languageForeign.LanguageForeignNum);
if (languageForeign.ClassType == null)
{
languageForeign.ClassType = "";
}
OdSqlParameter paramClassType = new OdSqlParameter("paramClassType", OdDbType.Text, POut.StringParam(languageForeign.ClassType));
if (languageForeign.English == null)
{
languageForeign.English = "";
}
OdSqlParameter paramEnglish = new OdSqlParameter("paramEnglish", OdDbType.Text, POut.StringParam(languageForeign.English));
if (languageForeign.Translation == null)
{
languageForeign.Translation = "";
}
OdSqlParameter paramTranslation = new OdSqlParameter("paramTranslation", OdDbType.Text, POut.StringParam(languageForeign.Translation));
if (languageForeign.Comments == null)
{
languageForeign.Comments = "";
}
OdSqlParameter paramComments = new OdSqlParameter("paramComments", OdDbType.Text, POut.StringParam(languageForeign.Comments));
Db.NonQ(command, paramClassType, paramEnglish, paramTranslation, paramComments);
}
///<summary>Inserts one LanguageForeign into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(LanguageForeign languageForeign)
{
return(InsertNoCache(languageForeign, false));
}
///<summary>Updates one LanguageForeign in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables. Returns true if an update occurred.</summary>
public static bool Update(LanguageForeign languageForeign, LanguageForeign oldLanguageForeign)
{
string command = "";
if (languageForeign.ClassType != oldLanguageForeign.ClassType)
{
if (command != "")
{
command += ",";
}
command += "ClassType = " + DbHelper.ParamChar + "paramClassType";
}
if (languageForeign.English != oldLanguageForeign.English)
{
if (command != "")
{
command += ",";
}
command += "English = " + DbHelper.ParamChar + "paramEnglish";
}
if (languageForeign.Culture != oldLanguageForeign.Culture)
{
if (command != "")
{
command += ",";
}
command += "Culture = '" + POut.String(languageForeign.Culture) + "'";
}
if (languageForeign.Translation != oldLanguageForeign.Translation)
{
if (command != "")
{
command += ",";
}
command += "Translation = " + DbHelper.ParamChar + "paramTranslation";
}
if (languageForeign.Comments != oldLanguageForeign.Comments)
{
if (command != "")
{
command += ",";
}
command += "Comments = " + DbHelper.ParamChar + "paramComments";
}
if (command == "")
{
return(false);
}
if (languageForeign.ClassType == null)
{
languageForeign.ClassType = "";
}
OdSqlParameter paramClassType = new OdSqlParameter("paramClassType", OdDbType.Text, POut.StringParam(languageForeign.ClassType));
if (languageForeign.English == null)
{
languageForeign.English = "";
}
OdSqlParameter paramEnglish = new OdSqlParameter("paramEnglish", OdDbType.Text, POut.StringParam(languageForeign.English));
if (languageForeign.Translation == null)
{
languageForeign.Translation = "";
}
OdSqlParameter paramTranslation = new OdSqlParameter("paramTranslation", OdDbType.Text, POut.StringParam(languageForeign.Translation));
if (languageForeign.Comments == null)
{
languageForeign.Comments = "";
}
OdSqlParameter paramComments = new OdSqlParameter("paramComments", OdDbType.Text, POut.StringParam(languageForeign.Comments));
command = "UPDATE languageforeign SET " + command
+ " WHERE LanguageForeignNum = " + POut.Long(languageForeign.LanguageForeignNum);
Db.NonQ(command, paramClassType, paramEnglish, paramTranslation, paramComments);
return(true);
}
///<summary>Updates one LanguageForeign in the database.</summary>
internal static void Update(LanguageForeign languageForeign)
{
string command="UPDATE languageforeign SET "
+"ClassType = '"+POut.String(languageForeign.ClassType)+"', "
+"English = '"+POut.String(languageForeign.English)+"', "
+"Culture = '"+POut.String(languageForeign.Culture)+"', "
+"Translation = '"+POut.String(languageForeign.Translation)+"', "
+"Comments = '"+POut.String(languageForeign.Comments)+"' "
+"WHERE LanguageForeignNum = "+POut.Long(languageForeign.LanguageForeignNum);
Db.NonQ(command);
}
///<summary>Updates one LanguageForeign in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables.</summary>
internal static void Update(LanguageForeign languageForeign,LanguageForeign oldLanguageForeign)
{
string command="";
if(languageForeign.ClassType != oldLanguageForeign.ClassType) {
if(command!=""){ command+=",";}
command+="ClassType = '"+POut.String(languageForeign.ClassType)+"'";
}
if(languageForeign.English != oldLanguageForeign.English) {
if(command!=""){ command+=",";}
command+="English = '"+POut.String(languageForeign.English)+"'";
}
if(languageForeign.Culture != oldLanguageForeign.Culture) {
if(command!=""){ command+=",";}
command+="Culture = '"+POut.String(languageForeign.Culture)+"'";
}
if(languageForeign.Translation != oldLanguageForeign.Translation) {
if(command!=""){ command+=",";}
command+="Translation = '"+POut.String(languageForeign.Translation)+"'";
}
if(languageForeign.Comments != oldLanguageForeign.Comments) {
if(command!=""){ command+=",";}
command+="Comments = '"+POut.String(languageForeign.Comments)+"'";
}
if(command==""){
return;
}
command="UPDATE languageforeign SET "+command
+" WHERE LanguageForeignNum = "+POut.Long(languageForeign.LanguageForeignNum);
Db.NonQ(command);
}
