public ActionResult CustomTranslation(CustomTranslation objCustomTranslation)
{
try
{
if (obj.CheckCustomTranslation(objCustomTranslation))
{
if (obj.Save(objCustomTranslation))
{
if (objCustomTranslation.TextID > 0)
{
ModelState.Clear();
TempData["msg"] = "CustomTranslation Update Successfully";
return(RedirectToAction("CustomTranslation", "CustomTranslation"));
}
else
{
ModelState.Clear();
TempData["msg"] = "CustomTranslation Saved Successfully";
return(RedirectToAction("CustomTranslation", "CustomTranslation"));
}
}
}
else
{
TempData["msg"] = "Error";
}
return(RedirectToAction("CustomTranslation", "CustomTranslation"));
}
catch (Exception Ex)
{
TempData["msg"] = Ex.Message;
return(RedirectToAction("CustomTranslation", "CustomTranslation"));
}
}
private void DumpCustomTranslations()
{
var list = new List <CustomTranslation>();
foreach (var type in _module.Types)
{
foreach (var method in type.Methods)
{
if (!method.HasBody)
{
continue;
}
var inst = method.Body.Instructions;
for (var index = 0; index < inst.Count; index++)
{
var ins = inst[index];
if (!ins.OpCode.Equals(OpCodes.Call) ||
!(ins.Operand is IMethod m) ||
!string.Equals(m.Name.ToString(), "CreateTranslation"))
{
continue;
}
if (!(ins = inst[++index]).IsStloc())
{
continue;
}
var custom = new CustomTranslation
{
Key = inst[index - 2].Operand as string,
Namespace = type.Namespace
};
var local = ins.GetLocal(method.Body.Variables);
while (index < inst.Count - 1 && !(ins = inst[++index]).IsLdloc() || ins.GetLocal(method.Body.Variables) != local)
{
}
if (!(ins = inst[++index]).OpCode.Equals(OpCodes.Ldstr))
{
continue;
}
custom.Value = ins.Operand as string;
list.Add(custom);
}
}
}
WriteFiles(list, "Customs");
}
public bool CheckCustomTranslation(CustomTranslation objCustomTranslation)
{
Connect();
string Table;
bool flag;
try
{
SqlCommand cmd = new SqlCommand("CheckCustomTranslation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@TextID", objCustomTranslation.TextID);
cmd.Parameters.AddWithValue("@Text", objCustomTranslation.Text.ToUpper());
cmd.Parameters.Add("@NameExists", SqlDbType.NVarChar, 50);
cmd.Parameters["@NameExists"].Direction = ParameterDirection.Output;
con.Open();
int i = cmd.ExecuteNonQuery();
Table = (string)cmd.Parameters["@NameExists"].Value;
if (Convert.ToInt32(Table) == 1)
{
flag = false;
}
else
{
flag = true;
}
return(flag);
}
catch (Exception)
{
return(false);
}
}
public bool Save(CustomTranslation obj)
{
Connect();
try
{
SqlCommand cmd = new SqlCommand("IUCustomTranslation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.TextID == 0)
{
cmd.Parameters.AddWithValue("@TextID", 0);
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@TextID", obj.TextID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
if (obj.Text == null)
{
cmd.Parameters.AddWithValue("@Text", "");
}
else
{
cmd.Parameters.AddWithValue("@Text", obj.Text);
}
if (obj.Hindi == null)
{
cmd.Parameters.AddWithValue("@Hindi", "");
}
else
{
cmd.Parameters.AddWithValue("@Hindi", obj.Hindi);
}
if (obj.Marathi == null)
{
cmd.Parameters.AddWithValue("@Marathi", "");
}
else
{
cmd.Parameters.AddWithValue("@Marathi", obj.Marathi);
}
if (obj.Tamil == null)
{
cmd.Parameters.AddWithValue("@Tamil", "");
}
else
{
cmd.Parameters.AddWithValue("@Tamil", obj.Tamil);
}
if (obj.Bengali == null)
{
cmd.Parameters.AddWithValue("@Bengali", "");
}
else
{
cmd.Parameters.AddWithValue("@Bengali", obj.Bengali);
}
if (obj.Gujarati == null)
{
cmd.Parameters.AddWithValue("@Gujarati", "");
}
else
{
cmd.Parameters.AddWithValue("@Gujarati", obj.Gujarati);
}
if (obj.Urdu == null)
{
cmd.Parameters.AddWithValue("@Urdu", "");
}
else
{
cmd.Parameters.AddWithValue("@Urdu", obj.Urdu);
}
if (obj.Telugu == null)
{
cmd.Parameters.AddWithValue("@Telugu", "");
}
else
{
cmd.Parameters.AddWithValue("@Telugu", obj.Telugu);
}
if (obj.Kannada == null)
{
cmd.Parameters.AddWithValue("@Kannada", "");
}
else
{
cmd.Parameters.AddWithValue("@Kannada", obj.Kannada);
}
if (obj.Malayalam == null)
{
cmd.Parameters.AddWithValue("@Malayalam", "");
}
else
{
cmd.Parameters.AddWithValue("@Malayalam", obj.Malayalam);
}
if (obj.Arabic == null)
{
cmd.Parameters.AddWithValue("@Arabic", "");
}
else
{
cmd.Parameters.AddWithValue("@Arabic", obj.Arabic);
}
if (obj.Odia == null)
{
cmd.Parameters.AddWithValue("@Odia", "");
}
else
{
cmd.Parameters.AddWithValue("@Odia", obj.Odia);
}
cmd.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
