public ActionResult DeleteFiles(string Id)
{
DBDataContext db = new DBDataContext();
int IdCur = Convert.ToInt32(Id);
fileContaner fd = db.fileContaner.FirstOrDefault(u => u.Id == IdCur);
int? predmetId = fd.predmetId;
db.ExecuteCommand("DELETE FROM Files WHERE Id=" + fd.docsId.ToString());
db.ExecuteCommand("DELETE FROM Files WHERE Id=" + fd.programId.ToString());
db.ExecuteCommand("DELETE FROM Files WHERE Id=" + fd.scanId.ToString());
db.ExecuteCommand("DELETE FROM fileContaner WHERE Id=" + Id);
return RedirectToAction("Downloads", new { id = predmetId });
}
public static void WriteArchive(String pathProg, String pathScan, String pathDocs)
{
DBDataContext db = new DBDataContext();
db.ExecuteCommand("insert into fileContaner (whoUserId, data, program, scan, docs) VALUES ({0}, {1}, {2}, {3}, {4})", 1);
}
//[AllowAnonymous]
//Create new seeds with person
public ActionResult AddNewEnrollment(WebScanner.Models.EBTS.Person person)
{
string strSQL;
var ViewModelPerson = new WebScanner.ViewModels.Enrollment.NewEnrollmentFormViewModel
{
Person = person
};
if (!ModelState.IsValid)
{
TempData["Error"] = "";
var modelErrors = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
TempData["Error"] = TempData["Error"] + "<li>" + modelError.ErrorMessage + "</li>";
}
}
return(RedirectToAction("Index", "EBTS", ViewModelPerson));
}
var RandomNumber = new Random();
DBDataContext db = new DBDataContext();
//var fld = db.vw_Fileds.Where(f => f.Identifier == person.IdentifierCode).Select(f => new { f.Identifier, f.TotTypeId });
string NewRandomNumber = RandomNumber.Next(10000000, 99999999).ToString();
var vwDistinctLogicalRecordType = db.vw_LogicalRecordTypes.Where(col => col.Identifier == person.IdentifierCode).Select(col => new { col.TransactionTypeId }).Distinct();
foreach (var row in vwDistinctLogicalRecordType)
{
strSQL = @"INSERT INTO [dbo].[tlbTransaction_Master]
([Transaction_ID]
,[Transaction_TypeId]
,[Transaction_Desc])
VALUES
(" + NewRandomNumber + "," + row.TransactionTypeId + ",'')";
try
{
db.ExecuteCommand(strSQL);
}
catch (Exception ex)
{
return(Content("Error saving data!"));
}
}
string DisplayFieldName = "";
int FieldNumber = 0;
var vwLogicalRecordType = db.vw_LogicalRecordTypes.Where(col => col.Identifier == person.IdentifierCode).Select(col => new { col.Identifier, col.TotTypeId });
foreach (var row in vwLogicalRecordType)
{
var vwFields = db.vw_Fileds.Where(col => col.Identifier == person.IdentifierCode && col.TotTypeId == row.TotTypeId && col.IsAutoGenerated == false).Select(col => new { col.TotTypeId, col.FieldId });
FieldNumber = 0;
foreach (var fieldRow in vwFields)
{
DisplayFieldName = "Field[" + FieldNumber.ToString() + "].FieldList";
strSQL = @"INSERT INTO [dbo].[tlbTransaction_Detail]
([Transaction_ID]
,[Transaction_TotTypeId]
,[Transaction_FieldID]
,[Transaction_Value]
,[Transaction_DisplayFieldName])
VALUES
(" + NewRandomNumber + ","
+ fieldRow.TotTypeId + ","
+ fieldRow.FieldId + ",'"
+ "" + "','"
+ DisplayFieldName + "')";
FieldNumber = FieldNumber + 1;
db.ExecuteCommand(strSQL);
}
}
//Aliases FieldID= 33
//Name FieldID= 31
int TOTTyepeID = 0;
var fieldlist = db.vw_Fileds.Where(col => col.Identifier == person.IdentifierCode && col.FieldId == 31).Select(col => new { col.TotTypeId }).SingleOrDefault();
strSQL = @"UPDATE [dbo].[tlbTransaction_Detail]
SET [Transaction_Value]='" + person.FullName + "' "
+ "WHERE [Transaction_ID]=" + NewRandomNumber + " "
+ "AND [Transaction_FieldID]=" + 31 + ""
+ "AND Transaction_TotTypeId=" + fieldlist.TotTypeId;
db.ExecuteCommand(strSQL);
return(RedirectToAction("NewEnrollment/" + person.IdentifierCode, "EBTS", new { transactionid = NewRandomNumber }));
}
//save/Update data
//EBTS/NewEnrollment/CNA?TotType=8&transactionid=48650597
public ActionResult NewEnrollment(string Identifier, PersonViewModel model)
{
int TOTTypeNumber; //= Request.QueryString["TotType"];
int transactionid; // = Request.QueryString["transactionid"];
if (IsNumeric(Request.QueryString["transactionid"]))
{
transactionid = Convert.ToInt32(Request.QueryString["transactionid"]);
}
else
{
return(Content("Error: transactionid"));
}
if (IsNumeric(Request.QueryString["TotType"]))
{
TOTTypeNumber = Convert.ToInt32(Request.QueryString["TotType"]);
}
else
{
return(Content("Error: TOTType"));
}
//return View(ViewModelFieldList);
//return RedirectToAction("Index", "EBTS", ViewModelPerson);
//return RedirectToAction("NewEnrollment", new { TotType = TOTTypeNumber, transactionid = transactionid });
//string forminvalue = string.Join(",", frm.AllKeys);
DBDataContext db = new DBDataContext();
string fldname = "";
//frm.AllKeys.ToList().Contains(fld.FieldName)
//db.ExecuteQuery<Customer>("select * from dbo.Customers where City = {0}", "London");
//int rccount = db.tlbTransaction_Masters.Where(m => m.Transaction_ID == Convert.ToInt32(Session["Transaction_ID"])).Count();
var fldlist = from fld in db.vw_Fileds.Where(f => f.IsAutoGenerated == false).OrderBy(f => f.FieldId) select(fld);
//where fld.TypeNumber == tempInt && fld.Identifier == Identifier ));
//foreach (var row in fldlist.ToList())
//{
// rccount = db.tlbTransaction_Details.Where(fldrow => fldrow.Transaction_ID == Convert.ToInt32(Session["Transaction_ID"]) && fldrow.Transaction_FieldID == row.FieldId).Count();
// fldname = "frm[row.FieldName]";
// string strSQL = @"UPDATE [dbo].[tlbTransaction_Detail]
// SET [Transaction_Value]='" + fldname + "'"
// + "WHERE [Transaction_ID]=" + Session["Transaction_ID"] + " "
// + "AND [Transaction_FieldID]=" + row.FieldId;
// db.ExecuteCommand(strSQL);
//}
string uservalu = "";
//foreach (var value in model.Field)
//{
// uservalu = value.FieldList;
//}
//int TOTTypeNumber; //= Request.QueryString["TotType"];
//int transactionid;// = Request.QueryString["transactionid"];
var fieldview = db.vw_TranactionFileds.Where(f => f.Transaction_ID == transactionid && f.Transaction_TotTypeId == TOTTypeNumber);
string RunningFieldValue = "";
foreach (var row in fieldview.ToList())
{
for (int i = 0; i <= model.Field.Count - 1; i++)
{
//uservalu = model.Field[i].FieldList;
if (row.FieldName == "Field[" + i.ToString() + "].FieldList")
{
RunningFieldValue = model.Field[i].FieldList;
string strSQL = @"UPDATE [dbo].[tlbTransaction_Detail]
SET [Transaction_Value]='" + RunningFieldValue + "'"
+ "WHERE [Transaction_ID]=" + transactionid + " "
+ "AND [Transaction_FieldID]=" + row.FieldId + " "
+ "AND [Transaction_TotTypeId]=" + TOTTypeNumber + "";
db.ExecuteCommand(strSQL);
break;
}
}
}
return(Content("Data saved!"));
//return RedirectToAction("NewEnrollment");
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
// Попытка зарегистрировать пользователя
try
{
WebSecurity.CreateUserAndAccount(model.UserName, model.Password);
WebSecurity.Login(model.UserName, model.Password);
DBDataContext db = new DBDataContext();
UserProfile user = db.UserProfile.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower());
db.ExecuteCommand("insert into webpages_UsersInRoles (UserId, RoleId) VALUES ({0}, {1})", user.UserId, 1);
if (user != null)
{
user.FIOShort = model.FIOUserName;
db.SubmitChanges();
}
return RedirectToAction("Index", "Main");
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
// Появление этого сообщения означает наличие ошибки; повторное отображение формы
return View(model);
}
public ActionResult Remove(int id)
{
try
{
DBDataContext db = new DBDataContext();
int response = db.ExecuteCommand(@"DELETE FROM PredmetForUser WHERE PredmetForUser.Id={0}", id);
if (response == 1)
{
return RedirectToAction("Index");
}
}
catch (Exception)
{
return RedirectToAction("Index");
//return RedirectToAction("Remove", new { id = id, saveChangesError = true });
}
return RedirectToAction("Index");
}