private void TransactionRollBack(DALC.Transaction Transaction)
{
Transaction.SqlTransaction.Rollback();
Transaction.Com.Connection.Close();
Transaction.Com.Connection.Dispose();
Transaction.Com.Dispose();
}
protected void BtnProcessEnds_Click(object sender, EventArgs e)
{
DALC.Transaction Transaction = new DALC.Transaction();
var Dictionary = new Dictionary <string, object>()
{
{ "IsCompleted", true },
{ "WhereID", _EvaluationsID }
};
_Result = DALC.UpdateDatabase(Tools.Table.Evaluations, Dictionary, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
Dictionary.Clear();
Dictionary.Add("ApplicationsPersonsID", _ApplicationsPersonsID);
Dictionary.Add("ServicesID", (int)Tools.Services.Daxili_qiymətləndirmə);
Dictionary.Add("ApplicationsPersonsServicesStatusID", (int)Tools.ApplicationsPersonsServicesStatus.Həll_olunub_təmin_edilib);
Dictionary.Add("IsFirstApplication", false);
Dictionary.Add("IsActive", true);
Dictionary.Add("Add_Dt", DateTime.Now);
Dictionary.Add("Add_Ip", Request.UserHostAddress.IPToInteger());
_Result = DALC.InsertDatabase(Tools.Table.ApplicationsPersonsServices, Dictionary, Transaction, true);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
Config.RedirectURL(string.Format("/tools/evaluations/?i={0}", Config._GetQueryString("i")));
}
private void TarnsactionCommitOrRollback(DALC.Transaction Transaction, bool IsCommit = false)
{
if (IsCommit)
{
Transaction.SqlTransaction.Commit();
}
else
{
Transaction.SqlTransaction.Rollback();
}
Transaction.Com.Connection.Close();
Transaction.Com.Connection.Dispose();
Transaction.Com.Dispose();
}
protected void LnkAddBrotherSister_Click(object sender, EventArgs e)
{
long ParentID = Convert.ToInt64(BtnSave.Attributes["data-parent"]);
Dictionary <string, object> DictUpdateAddingChild = new Dictionary <string, object>()
{
{ "ParentID", ParentID },
{ "IsBrotherSister", true },
{ "WhereID", int.Parse(LnkAddBrotherSister.CommandArgument) }
};
DALC.Transaction Transaction = new DALC.Transaction();
int CheckUpdate = DALC.UpdateDatabase(_TableName, DictUpdateAddingChild, Transaction);
if (CheckUpdate < 1)
{
Config.MsgBoxAjax("Sistemdə xəta baş verdi.", Page);
return;
}
Dictionary <string, object> DictUpdateCurrentChild = new Dictionary <string, object>()
{
{ "IsBrotherSister", true },
{ "WhereID", int.Parse(ChildID) }
};
int CheckUpdate2 = DALC.UpdateDatabase(_TableName, DictUpdateCurrentChild, Transaction, true);
if (CheckUpdate2 < 1)
{
Config.MsgBoxAjax("Sistemdə xəta baş verdi.", Page);
return;
}
BindSisterBrother(ParentID);
PnlSuccess.Visible = true;
LnkAddBrotherSister.Visible = false;
PnlSisterBrotherList.Visible = true;
}
protected void btnSave_Click(object sender, EventArgs e)
{
ConfigL.ClearBorderColor(pnlControls);
if (string.IsNullOrEmpty(txtTitle.Text))
{
ConfigL.BorderColor(txtTitle);
return;
}
if (string.IsNullOrEmpty(txtNameLangs.Text))
{
ConfigL.BorderColor(txtNameLangs);
return;
}
if (dListStatus.SelectedValue == "-1")
{
ConfigL.BorderColor(dListStatus);
return;
}
DALC.Transaction transaction = new DALC.Transaction();
int check;
var dictionaryServices = new Dictionary <string, object>()
{
{ "ExpireDate", DateTime.Now.AddYears(1) },
{ "IsActive", int.Parse(dListStatus.SelectedValue) }
};
DataTable dtServicesLangs = new DataTable();
dtServicesLangs.Columns.Add("ServicesId", typeof(int));
dtServicesLangs.Columns.Add("LangsId", typeof(int));
dtServicesLangs.Columns.Add("Name", typeof(string));
dtServicesLangs.Columns.Add("Description", typeof(string));
dtServicesLangs.Columns.Add("CreatedDate", typeof(DateTime));
if (_operationsType == "add")
{
dictionaryServices.Add("MinMinute", 0);
dictionaryServices.Add("DailyUse", 255);
dictionaryServices.Add("UseBetweenHour", 0);
dictionaryServices.Add("ServicesTypesId", (int)Tools.ServicesTypes.Tədbirlər);
dictionaryServices.Add("Title", txtTitle.Text);
int resultId = DALC.InsertDatabase(Tools.Tables.Services, dictionaryServices, transaction);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
_serviceId = resultId;
DataRow dr;
foreach (Tools.Langs langs in (Tools.Langs[])Enum.GetValues(typeof(Tools.Langs)))
{
dr = dtServicesLangs.NewRow();
dr["ServicesId"] = _serviceId;
dr["LangsId"] = (int)langs;
dr["Name"] = txtNameLangs.Text;
dr["Description"] = txtDescriptionLangs.Text;
dr["CreatedDate"] = DateTime.Now;
dtServicesLangs.Rows.Add(dr);
}
resultId = DALC.InsertBulk(Tools.Tables.ServicesLangs, dtServicesLangs, transaction, true);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
var dictionaryServicesOrganizations = new Dictionary <string, object>()
{
{ "Barcode", Guid.NewGuid() },
{ "OrganizationsId", DALCL._Login.organizationsId },
{ "ServicesId", _serviceId },
{ "IsActive", true },
{ "CreatedDate", DateTime.Now },
};
resultId = DALC.InsertDatabase(Tools.Tables.ServicesOrganizations, dictionaryServicesOrganizations);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
else if (_operationsType == "edit")
{
dictionaryServices.Add("WhereId", _serviceId);
check = DALC.UpdateDatabase(Tools.Tables.Services, dictionaryServices, transaction);
if (check < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
var dictionaryServicesLangs = new Dictionary <string, object>()
{
{ "Name", txtNameLangs.Text },
{ "Description", txtDescriptionLangs.Text },
{ "WhereServicesId", _serviceId },
{ "WhereLangsId", Langs.Id },
};
check = DALC.UpdateDatabase(Tools.Tables.ServicesLangs, dictionaryServicesLangs, transaction, true);
if (check < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
ConfigL.MsgBoxAjax(Config._AlertMessages.Success, $"/{Langs.Name}/modules/conferences/operations/edit/{_serviceId}");
}
protected void BtnSave_Click(object sender, EventArgs e)
{
if (!Validations())
{
return;
}
if (_ApplicationsFamilyID == 0)
{
_ApplicationsFamilyID = int.Parse(BtnSave.CommandArgument);
}
if (_ApplicationsID == 0)
{
_ApplicationsID = int.Parse(BtnSave.CommandName);
}
DALC.Transaction Transaction = new DALC.Transaction();
var Dictionary = new Dictionary <string, object>()
{
{ "ApplicationsID", _ApplicationsID },
{ "ApplicationsFamilyTypesID", int.Parse(DListApplicationsFamilyTypes.SelectedValue) },
{ "Address", TxtAddress.Text },
{ "ApplicationsFamilyStatusID", int.Parse(DListApplicationsFamilyStatus.SelectedValue) },
{ "Tour_Dt", TxtDate.Text.DateTimeFormat() },
{ "Description", TxtDescriptions.Text },
};
//Insert edek
if (_ApplicationsFamilyID == 0)
{
Dictionary.Add("Add_Dt", DateTime.Now);
Dictionary.Add("Add_Ip", Request.UserHostAddress.IPToInteger());
_Result = DALC.InsertDatabase(Tools.Table.ApplicationsFamily, Dictionary, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
_ApplicationsFamilyID = _Result;
DataTable DtUsers = new DataTable();
DtUsers.Columns.Add("ApplicationsFamilyID", typeof(int));
DtUsers.Columns.Add("UsersID", typeof(int));
DtUsers.Columns.Add("IsDeleted", typeof(bool));
for (int i = 0; i < DListUsers.Items.Count; i++)
{
if (DListUsers.Items[i].Selected)
{
DtUsers.Rows.Add(_ApplicationsFamilyID, DListUsers.Items[i].Value, false);
}
}
_Result = DALC.InsertBulk(Tools.Table.ApplicationsFamilyUsers, DtUsers, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
DataTable DtPartners = new DataTable();
DtPartners.Columns.Add("ApplicationsFamilyID", typeof(int));
DtPartners.Columns.Add("ApplicationsFamilyPartnersTypesID", typeof(int));
DtPartners.Columns.Add("PersonsFullname", typeof(string));
DtPartners.Columns.Add("IsDeleted", typeof(bool));
for (int i = 0; i < DListApplicationsFamilyPartnersTypes.Items.Count; i++)
{
if (DListApplicationsFamilyPartnersTypes.Items[i].Selected)
{
DtPartners.Rows.Add(_ApplicationsFamilyID, DListApplicationsFamilyPartnersTypes.Items[i].Value, ((TextBox)PnlPersons.FindControl(string.Format("Txt{0}", DListApplicationsFamilyPartnersTypes.Items[i].Value))).Text, false);
}
}
if (DtPartners.Rows.Count > 0)
{
_Result = DALC.InsertBulk(Tools.Table.ApplicationsFamilyPartners, DtPartners, Transaction, true);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
}
else
{
TarnsactionCommitOrRollback(Transaction, true);
}
}
else
{
Dictionary.Add("WhereID", _ApplicationsFamilyID);
_Result = DALC.UpdateDatabase(Tools.Table.ApplicationsFamily, Dictionary, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
Dictionary.Clear();
//Butun sitifadecileri IsDeleted true edek ki sonra olanlari false, olmayanlari insert edeceyik
Dictionary.Add("ApplicationsFamilyID", _ApplicationsFamilyID);
Dictionary.Add("IsDeleted", true);
Dictionary.Add("WhereApplicationsFamilyID", _ApplicationsFamilyID);
_Result = DALC.UpdateDatabase(Tools.Table.ApplicationsFamilyUsers, Dictionary);
if (_Result < 1)
{
//Eger xeta bash verirse Transactionla emeliyyatlari geri qaytaraq
TarnsactionCommitOrRollback(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
bool IsUpdate = false;
string DataID = DALC.GetSingleValues("CONCAT(CAST(UsersID as varchar),',')", Tools.Table.ApplicationsFamilyUsers, "ApplicationsFamilyID", _ApplicationsFamilyID, "for xml path('')");
if (DataID == "-1")
{
//Eger xeta bash verirse Transactionla emeliyyatlari geri qaytaraq
TarnsactionCommitOrRollback(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
for (int i = 0; i < DListUsers.Items.Count; i++)
{
if (DListUsers.Items[i].Selected)
{
Dictionary.Clear();
IsUpdate = (("," + DataID).IndexOf("," + DListUsers.Items[i].Value + ",") > -1);
Dictionary.Add("ApplicationsFamilyID", _ApplicationsFamilyID);
Dictionary.Add("UsersID", int.Parse(DListUsers.Items[i].Value));
Dictionary.Add("IsDeleted", false);
_Result = DALC.InsertOrUpdateApplicationsFamilyUsersOrPartners(Tools.Table.ApplicationsFamilyUsers, Dictionary, IsUpdate, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
}
}
//Butun ApplicationsFamilyPartners IsDeleted true edek ki sonra olanlari false, olmayanlari insert edeceyik
Dictionary.Clear();
Dictionary.Add("ApplicationsFamilyID", _ApplicationsFamilyID);
Dictionary.Add("IsDeleted", true);
Dictionary.Add("WhereApplicationsFamilyID", _ApplicationsFamilyID);
_Result = DALC.UpdateDatabase(Tools.Table.ApplicationsFamilyPartners, Dictionary);
if (_Result < 1)
{
//Eger xeta bash verirse Transactionla emeliyyatlari geri qaytaraq
TarnsactionCommitOrRollback(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
int ApplicationsFamilyPartnersTypesID = 0;
DataID = DALC.GetSingleValues("CONCAT(CAST(ApplicationsFamilyPartnersTypesID as varchar),',')", Tools.Table.ApplicationsFamilyPartners, "ApplicationsFamilyID", _ApplicationsFamilyID, "for xml path('')");
if (DataID == "-1")
{
//Eger Count alanda xeta bash verirse Transactionla emeliyyatlari geri qaytaraq
Transaction.SqlTransaction.Rollback();
Transaction.Com.Connection.Close();
Transaction.Com.Connection.Dispose();
Transaction.Com.Dispose();
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
for (int i = 0; i < DListApplicationsFamilyPartnersTypes.Items.Count; i++)
{
if (DListApplicationsFamilyPartnersTypes.Items[i].Selected)
{
Dictionary.Clear();
ApplicationsFamilyPartnersTypesID = int.Parse(DListApplicationsFamilyPartnersTypes.Items[i].Value);
IsUpdate = (("," + DataID).IndexOf("," + ApplicationsFamilyPartnersTypesID._ToString() + ",") > -1);
Dictionary.Add("ApplicationsFamilyID", _ApplicationsFamilyID);
Dictionary.Add("ApplicationsFamilyPartnersTypesID", ApplicationsFamilyPartnersTypesID);
Dictionary.Add("IsDeleted", false);
_Result = DALC.InsertOrUpdateApplicationsFamilyUsersOrPartners(Tools.Table.ApplicationsFamilyPartners, Dictionary, IsUpdate, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
if (PnlPersons.FindControl(string.Format("Txt{0}", ApplicationsFamilyPartnersTypesID)) != null)
{
Dictionary.Clear();
Dictionary.Add("PersonsFullname", ((TextBox)PnlPersons.FindControl(string.Format("Txt{0}", ApplicationsFamilyPartnersTypesID))).Text);
Dictionary.Add("WhereApplicationsFamilyID", _ApplicationsFamilyID);
Dictionary.Add("WhereApplicationsFamilyPartnersTypesID", ApplicationsFamilyPartnersTypesID);
_Result = DALC.UpdateDatabase(Tools.Table.ApplicationsFamilyPartners, Dictionary, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
}
}
}
TarnsactionCommitOrRollback(Transaction, true);
}
Config.MsgBoxAjax(Config._DefaultSuccessMessages, Request.RawUrl);
}
protected void btnSaveAnswers_Click(object sender, EventArgs e)
{
ConfigL.ClearBorderColor(pnlAnswers);
if (string.IsNullOrEmpty(txtAnswer.Text))
{
ConfigL.BorderColor(txtAnswer);
return;
}
if (DALCL.CheckSurveysAnswers(_surveysId, txtAnswer.Text))
{
ConfigL.BorderColor(txtAnswer);
ConfigL.MsgBoxAjax("Bu cavab istifadə olunur!");
return;
}
var dictionaryAnswers = new Dictionary <string, object>()
{
{ "Title", txtAnswer.Text },
};
int surveysAnswersId;
int result;
DALC.Transaction transaction = new DALC.Transaction();
if (btnSaveAnswers.CommandArgument == "0")
{
dictionaryAnswers.Add("SurveysId", _surveysId);
dictionaryAnswers.Add("VotesCount", 0);
dictionaryAnswers.Add("IsActive", true);
result = DALC.InsertDatabase(Tools.Tables.SurveysAnswers, dictionaryAnswers, transaction);
if (result < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
surveysAnswersId = result;
DataTable dtAnswersLangs = new DataTable();
dtAnswersLangs.Columns.Add("SurveysAnswersId", typeof(int));
dtAnswersLangs.Columns.Add("LangsId", typeof(int));
dtAnswersLangs.Columns.Add("Answer", typeof(string));
dtAnswersLangs.Columns.Add("CreatedDate", typeof(DateTime));
DataRow dr;
foreach (Tools.Langs langs in (Tools.Langs[])Enum.GetValues(typeof(Tools.Langs)))
{
dr = dtAnswersLangs.NewRow();
dr["SurveysAnswersId"] = surveysAnswersId;
dr["LangsId"] = (int)langs;
dr["Answer"] = txtAnswer.Text;
dr["CreatedDate"] = DateTime.Now;
dtAnswersLangs.Rows.Add(dr);
}
result = DALC.InsertBulk(Tools.Tables.SurveysAnswersLangs, dtAnswersLangs, transaction, true);
if (result < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
else
{
surveysAnswersId = int.Parse(btnSaveAnswers.CommandArgument);
dictionaryAnswers.Add("WhereId", surveysAnswersId);
result = DALC.UpdateDatabase(Tools.Tables.SurveysAnswers, dictionaryAnswers, transaction);
if (result < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
var dictionaryAnswersLangs = new Dictionary <string, object>()
{
{ "Answer", txtAnswer.Text },
{ "CreatedDate", DateTime.Now },
{ "WhereSurveysAnswersId", surveysAnswersId },
{ "WhereLangsId", Langs.Id },
};
result = DALC.UpdateDatabase(Tools.Tables.SurveysAnswersLangs, dictionaryAnswersLangs, transaction, true);
if (result < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
txtAnswer.Text = "";
btnSaveAnswers.CommandArgument = "0";
BindSurveysAnswers();
}
protected void btnSave_Click(object sender, EventArgs e)
{
ConfigL.ClearBorderColor(pnlControls);
if (string.IsNullOrEmpty(txtTitle.Text))
{
ConfigL.BorderColor(txtTitle);
return;
}
if (string.IsNullOrEmpty(txtQuestions.Text))
{
ConfigL.BorderColor(txtQuestions);
return;
}
if (dListStatus.SelectedValue == "-1")
{
ConfigL.BorderColor(dListStatus);
return;
}
if (DALCL.CheckSurveysQuestion(_surveysId, txtQuestions.Text))
{
ConfigL.BorderColor(txtQuestions);
ConfigL.MsgBoxAjax("Bu sual istifadə olunur!");
return;
}
DALC.Transaction transaction = new DALC.Transaction();
int check;
var dictionarySurveys = new Dictionary <string, object>()
{
{ "SurveysStatusId", int.Parse(dListStatus.SelectedValue) }
};
DataTable dtSurveysLangs = new DataTable();
dtSurveysLangs.Columns.Add("SurveysId", typeof(int));
dtSurveysLangs.Columns.Add("LangsId", typeof(int));
dtSurveysLangs.Columns.Add("Question", typeof(string));
dtSurveysLangs.Columns.Add("CreatedDate", typeof(DateTime));
dtSurveysLangs.Columns.Add("UpdatedDate", typeof(DateTime));
if (_operationsType == "add")
{
dictionarySurveys.Add("OrganizationsId", DALCL._Login.organizationsId);
dictionarySurveys.Add("Title", txtTitle.Text);
dictionarySurveys.Add("VotesCount", 0);
int resultId = DALC.InsertDatabase(Tools.Tables.Surveys, dictionarySurveys, transaction);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
_surveysId = resultId;
Dictionary <string, object> dictionarySurveysSubscriptions = new Dictionary <string, object>();
dictionarySurveysSubscriptions.Add("SurveysId", _surveysId);
dictionarySurveysSubscriptions.Add("OrganizationsId", DALCL._Login.organizationsId);
dictionarySurveysSubscriptions.Add("CreatedDate", DateTime.Now);
dictionarySurveysSubscriptions.Add("IsActive", true);
resultId = DALC.InsertDatabase(Tools.Tables.SurveysSubscriptions, dictionarySurveysSubscriptions);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
DataRow dr;
foreach (Tools.Langs langs in (Tools.Langs[])Enum.GetValues(typeof(Tools.Langs)))
{
dr = dtSurveysLangs.NewRow();
dr["SurveysId"] = _surveysId;
dr["LangsId"] = (int)langs;
dr["Question"] = txtQuestions.Text;
dr["CreatedDate"] = DateTime.Now;
dr["UpdatedDate"] = DateTime.Now;
dtSurveysLangs.Rows.Add(dr);
}
resultId = DALC.InsertBulk(Tools.Tables.SurveysLangs, dtSurveysLangs, transaction, true);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
ConfigL.MsgBoxAjax(Config._AlertMessages.Success, $"/{Langs.Name}/modules/surveys/operations/edit/{_surveysId}");
}
else if (_operationsType == "edit")
{
dictionarySurveys.Add("WhereId", _surveysId);
check = DALC.UpdateDatabase(Tools.Tables.Surveys, dictionarySurveys, transaction);
if (check < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
var dictionarySurveysLangs = new Dictionary <string, object>()
{
{ "Question", txtQuestions.Text },
{ "UpdatedDate", DateTime.Now },
{ "WhereSurveysId", _surveysId },
{ "WhereLangsId", Langs.Id },
};
check = DALC.UpdateDatabase(Tools.Tables.SurveysLangs, dictionarySurveysLangs, transaction, true);
if (check < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
ConfigL.MsgBoxAjax(Config._AlertMessages.Success);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
if (!IsValidation())
{
return;
}
DateTime ShowDate;
if (!DateTime.TryParse(TxtShowDate.Text, out ShowDate))
{
ConfigL.MsgBoxAjax("Xəbərin tarixini düzgün daxil edin!");
return;
}
DALC.Transaction transaction = new DALC.Transaction();
int check;
var dictionaryNews = new Dictionary <string, object>()
{
{ "NewsTypesId", int.Parse(DListNewsTypes.SelectedValue) },
{ "Title", TxtTitle.Text.ClearChar13() },
{ "IsActive", 1 },
{ "ShowDate", ShowDate }
};
var dictionaryNewsLangs = new Dictionary <string, object>()
{
{ "NewsLangsStatusId", DListStatus.SelectedValue },
{ "Title", TxtTitle.Text },
{ "SubTitle", TxtTitleSub.Text },
{ "ContentText", txtContent.Text },
{ "UpdatedDate", DateTime.Now },
};
if (_operations == "add")
{
dictionaryNews.Add("OrganizationsId", DALCL._Login.organizationsId);
//dictionaryNews.Add("CreatedDate", DateTime.Now);
int resultId = DALC.InsertDatabase(Tools.Tables.News, dictionaryNews, transaction);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
_newsId = resultId;
dictionaryNewsLangs.Add("NewsId", resultId);
dictionaryNewsLangs.Add("LangsId", Langs.Id);
dictionaryNewsLangs.Add("VisitorCount", 0);
dictionaryNewsLangs.Add("CreatedDate", DateTime.Now);
resultId = DALC.InsertDatabase(Tools.Tables.NewsLangs, dictionaryNewsLangs, transaction, true);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
else if (_operations == "edit")
{
dictionaryNews.Add("WhereId", _newsId);
check = DALC.UpdateDatabase(Tools.Tables.News, dictionaryNews, transaction);
if (check < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
dictionaryNewsLangs.Add("WhereId", int.Parse(BtnSave.CommandArgument));
check = DALC.UpdateDatabase(Tools.Tables.NewsLangs, dictionaryNewsLangs, transaction, true);
if (check < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
string fileName = "";
string path = "/uploads/news";
string fileType = "";
int contentLenght;
HttpFileCollection Files = Request.Files;
DataTable dtFiles = new DataTable();
dtFiles.Columns.Add("NewsFilesTypesId", typeof(int));
dtFiles.Columns.Add("FilesFoldersId", typeof(int));
dtFiles.Columns.Add("FilesTypesId", typeof(int));
dtFiles.Columns.Add("Path", typeof(string));
dtFiles.Columns.Add("Name", typeof(string));
dtFiles.Columns.Add("ContentLength", typeof(int));
DataRow dr;
for (int i = 1; i < Files.Count; i++)
{
if (Files[i].ContentLength > 0)
{
fileType = System.IO.Path.GetExtension(Files[i].FileName).Trim('.').ToLower();
if (_allowTypes.IndexOf($"-{fileType}-") > -1)
{
if (!Files[i].CheckFileContentLength(50))
{
continue;
}
contentLenght = Files[i].ContentLength;
System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(Files[i].InputStream);
string[] folderList = null;
fileName = $"{_newsId}_{(i - 1).ToString()}_{DateTime.Now.ToString("ddMMyyyyHHmmssfff")}.{fileType}";
if (i == 1)
{
//Boyuk original sekil nece var ama azmaz keyfiyyeti ile oynuyaq.
ImageResize.ImgResize($"{path}/main/{fileName}", bmp.Width, bmp.Height, Files[i].InputStream, 90L);
folderList = new string[] { "main" };
}
else
{
ImageResize.ImgResize($"{path}/other/{fileName}", bmp.Width, bmp.Height, Files[i].InputStream, 90L);
folderList = new string[] { "other" };
}
foreach (string item in folderList)
{
dr = dtFiles.NewRow();
switch (item)
{
case "main":
dr["NewsFilesTypesId"] = (int)Tools.NewsFilesTypes.Əsas_şəkil;
break;
case "other":
dr["NewsFilesTypesId"] = (int)Tools.NewsFilesTypes.Digər_şəkillər;
break;
default:
break;
}
dr["FilesFoldersId"] = (int)Tools.FilesFolders.Xəbərlər;
dr["FilesTypesId"] = (int)(Tools.FilesTypes)Enum.Parse(typeof(Tools.FilesTypes), fileType);
dr["Path"] = $"{path}/{item}/{fileName}";
dr["Name"] = fileName;
dr["ContentLength"] = contentLenght;
dtFiles.Rows.Add(dr);
}
}
}
}
DALC.ExecuteProcedure("InsertNewsFiles", "NewsId,ImportTableNewsFiles,CreatedDate", new object[] { _newsId, dtFiles, DateTime.Now });
int NewsPageNum = 1;
if (Session["NewsPageID"] != null)
{
NewsPageNum = int.Parse(Session["NewsPageID"].ToString());
}
ConfigL.RedirectURL(string.Format("/{0}/modules/news/{1}", Langs.Name, NewsPageNum));
}
protected void btnSave_Click(object sender, EventArgs e)
{
ConfigL.ClearBorderColor(pnlControls);
if (string.IsNullOrEmpty(txtTitle.Text))
{
ConfigL.BorderColor(txtTitle);
return;
}
if (string.IsNullOrEmpty(txtNameLangs.Text))
{
ConfigL.BorderColor(txtNameLangs);
return;
}
if (string.IsNullOrEmpty(txtMinMinute.Text))
{
ConfigL.BorderColor(txtMinMinute);
return;
}
if (string.IsNullOrEmpty(txtDailyUse.Text))
{
ConfigL.BorderColor(txtDailyUse);
return;
}
if (string.IsNullOrEmpty(txtUseBetweenHour.Text))
{
ConfigL.BorderColor(txtUseBetweenHour);
return;
}
DateTime dateTime;
if (string.IsNullOrEmpty(txtExpireDate.Text) || !Config.DateFormat(txtExpireDate.Text, out dateTime))
{
ConfigL.BorderColor(txtExpireDate);
return;
}
if (dListStatus.SelectedValue == "-1")
{
ConfigL.BorderColor(dListStatus);
return;
}
if (!Enum.IsDefined(typeof(Tools.ServicesTypes), _servicesTypesId))
{
ConfigL.MsgBoxAjax("Xidmət növü düzgün deyil!");
return;
}
DALC.Transaction transaction = new DALC.Transaction();
int check;
var dictionaryServices = new Dictionary <string, object>()
{
{ "MinMinute", txtMinMinute.Text },
{ "DailyUse", txtDailyUse.Text },
{ "UseBetweenHour", txtUseBetweenHour.Text },
{ "ExpireDate", dateTime },
{ "IsActive", int.Parse(dListStatus.SelectedValue) }
};
DataTable dtServicesLangs = new DataTable();
dtServicesLangs.Columns.Add("ServicesId", typeof(int));
dtServicesLangs.Columns.Add("LangsId", typeof(int));
dtServicesLangs.Columns.Add("Name", typeof(string));
dtServicesLangs.Columns.Add("Description", typeof(string));
dtServicesLangs.Columns.Add("CreatedDate", typeof(DateTime));
if (_operationsType == "add")
{
dictionaryServices.Add("ServicesTypesId", _servicesTypesId);
dictionaryServices.Add("Title", txtTitle.Text);
int resultId = DALC.InsertDatabase(Tools.Tables.Services, dictionaryServices, transaction);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
_serviceId = resultId;
DataRow dr;
foreach (Tools.Langs langs in (Tools.Langs[])Enum.GetValues(typeof(Tools.Langs)))
{
dr = dtServicesLangs.NewRow();
dr["ServicesId"] = _serviceId;
dr["LangsId"] = (int)langs;
dr["Name"] = txtNameLangs.Text;
dr["Description"] = txtDescriptionLangs.Text;
dr["CreatedDate"] = DateTime.Now;
dtServicesLangs.Rows.Add(dr);
}
resultId = DALC.InsertBulk(Tools.Tables.ServicesLangs, dtServicesLangs, transaction, true);
if (resultId < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
else if (_operationsType == "edit")
{
dictionaryServices.Add("WhereId", _serviceId);
check = DALC.UpdateDatabase(Tools.Tables.Services, dictionaryServices, transaction);
if (check < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
var dictionaryServicesLangs = new Dictionary <string, object>()
{
{ "Name", txtNameLangs.Text },
{ "Description", txtDescriptionLangs.Text },
{ "WhereServicesId", _serviceId },
{ "WhereLangsId", Langs.Id },
};
check = DALC.UpdateDatabase(Tools.Tables.ServicesLangs, dictionaryServicesLangs, transaction, true);
if (check < 1)
{
ConfigL.MsgBoxAjax(Config._AlertMessages.Error);
return;
}
}
ConfigL.MsgBoxAjax(Config._AlertMessages.Success, $"/{Langs.Name}/modules/services/{_servicesTypesId}");
}
protected void DListPersonsStatus_SelectedIndexChanged(object sender, EventArgs e)
{
ListBox DList = sender as ListBox;
_Applicant = DList.Items.FindByValue(Tools.ListPersonsStatus.Müraciətçi.ToString("d"));
_Private = DList.Items.FindByValue(Tools.ListPersonsStatus.Məxfi.ToString("d"));
_Primary = DList.Items.FindByValue(Tools.ListPersonsStatus.Əsas_şəxs.ToString("d"));
if (_Primary == null)
{
_Primary = new ListItem("Əsas şəxs", Tools.ListPersonsStatus.Əsas_şəxs.ToString("d"));
DList.Items.Add(_Primary);
}
if (_Private == null)
{
_Private = new ListItem("Məxfi", Tools.ListPersonsStatus.Məxfi.ToString("d"));
DList.Items.Add(_Private);
}
var Dictionary = new Dictionary <string, object>();
for (int i = 0; i < DList.Items.Count; i++)
{
if (DList.Items[i].Selected)
{
//Əgər məxfi seçilibsə əsası, əsas seçilibsə məxfini siyahıdan çıxardaq
if (DList.Items[i].Value == Tools.ListPersonsStatus.Məxfi.ToString("d"))
{
DList.Items.Remove(_Primary);
}
else if (DList.Items[i].Value == Tools.ListPersonsStatus.Əsas_şəxs.ToString("d"))
{
DList.Items.Remove(_Private);
}
}
}
DALC.Transaction Transaction = new DALC.Transaction();
//Əgər vetendasha əsas statusu seçilibsə hamisi false edek...
if (_Primary.Selected)
{
Dictionary.Add("IsPrimary", false);
Dictionary.Add("WhereApplicationsID", _ApplicationsID);
int Check = DALC.UpdateDatabase(Tools.Table.ApplicationsPersons, Dictionary, Transaction);
if (Check < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
}
Dictionary.Clear();
//Her seçimdə bazada update edək
Dictionary.Add("IsApplicant", _Applicant.Selected);
Dictionary.Add("IsPrivate", _Private.Selected);
Dictionary.Add("IsPrimary", _Primary.Selected);
Dictionary.Add("WhereID", DList.Attributes["data-id"]);
int Chek = DALC.UpdateDatabase(Tools.Table.ApplicationsPersons, Dictionary, Transaction, true);
if (Chek < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
}
private void CalculationForFullScale()
{
int Internalized, Asocial, Externalized, General;
int.TryParse(HdnFinalBox1.Value, out Internalized);
int.TryParse(HdnFinalBox2.Value, out Asocial);
int.TryParse(HdnFinalBox3.Value, out Externalized);
int.TryParse(HdnFinalBox4.Value, out General);
int AgeYear, AgeMonth;
int.TryParse(HdnAgeYear.Value, out AgeYear);
int.TryParse(HdnAgeMonth.Value, out AgeMonth);
if (AgeYear >= 19)
{
AgeMonth = AgeYear;
}
if (AgeYear > 81)
{
AgeYear = 81;
AgeMonth = 81;
}
DALC.Transaction Transaction = new DALC.Transaction();
#region InsertSIBRTable
Dictionary <string, object> Dictionary = new Dictionary <string, object>
{
{ "SIBRTypesID", (int)Tools.SIBRTypes.Full_Scale },
{ "ApplicationsPersonsID", _ApplicationsPersonsID },
{ "AgeYear", AgeYear },
{ "AgeMonth", AgeMonth },
{ "Description", TxtDescription.Text },
{ "IsCompleted", true },
{ "IsActive", true },
{ "Create_Dt", Config.DateTimeFormat(string.Format("{0}.{1}.{2}", TxtTestingDateDay.Text, TxtTestingDateMonth.Text, TxtTestingDateYear.Text)) },
{ "SIBRStatusID", (int)Tools.SIBRStatus.Aktiv },
{ "Add_Dt", DateTime.Now },
{ "Add_Ip", Request.UserHostAddress.IPToInteger() }
};
_Result = DALC.InsertDatabase(Tools.Table.SIBR, Dictionary, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
_SIBRID = _Result;
#endregion
DataTable DtSIBRAdaptiveScores = new DataTable();
DtSIBRAdaptiveScores.Columns.Add("SIBRID", typeof(int));
DtSIBRAdaptiveScores.Columns.Add("SIBRScoringTypesID", typeof(int));
DtSIBRAdaptiveScores.Columns.Add("SumA", typeof(int));
DtSIBRAdaptiveScores.Columns.Add("SumB", typeof(int));
DtSIBRAdaptiveScores.Columns.Add("SumC", typeof(int));
DtSIBRAdaptiveScores.Columns.Add("W", typeof(int));
DataTable DtSIBRAdaptiveResult = new DataTable();
DtSIBRAdaptiveResult.Columns.Add("SIBRID", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("SIBRScoringTypesGroupsID", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("SumW", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("REFW", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("SEMSS", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("COLUMNS_DIFF_P", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("COLUMNS_DIFF_N", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("DIFF", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("RMI", typeof(string));
DtSIBRAdaptiveResult.Columns.Add("SS", typeof(decimal));
DtSIBRAdaptiveResult.Columns.Add("SS_SEM_N", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("SS_SEM_P", typeof(int));
DtSIBRAdaptiveResult.Columns.Add("PR", typeof(decimal));
DtSIBRAdaptiveResult.Columns.Add("SIBRAdaptiveSkillLevelsID", typeof(int));
int SumA, SumB, SumC, SIBRScoringTypesID, RawScore, W;
decimal MS = 0, SC = 0, PL = 0, CL = 0, BI = 0;
foreach (RepeaterItem item in RptAdaptive.Items)
{
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)
{
int.TryParse(((TextBox)item.FindControl("TxtSumA")).Text, out SumA);
int.TryParse(((TextBox)item.FindControl("TxtSumB")).Text, out SumB);
int.TryParse(((TextBox)item.FindControl("TxtSumC")).Text, out SumC);
int.TryParse(((HiddenField)item.FindControl("HdnSIBRScoringTypes")).Value, out SIBRScoringTypesID);
int.TryParse(((HiddenField)PnlRawScore.FindControl(string.Format("HdnRawScore{0}", SIBRScoringTypesID))).Value, out RawScore);
DataTable Dt = DALC.GetSIBRScoring(Tools.SIBRTypes.Full_Scale, SIBRScoringTypesID, RawScore);
if (Dt == null)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
if (Dt.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax(string.Format("{0}: RawScore dəyəri {1} uyğun məlumat tapılmadı.", ((Tools.SIBRScoringTypes)Enum.Parse(typeof(Tools.SIBRScoringTypes), SIBRScoringTypesID.ToString())).ToDescriptionString(), RawScore));
return;
}
W = int.Parse(Dt._Rows("W"));
//Burda baxiriqki SIBRScoringTypesID hansi SIBRScoringTypesGroups-a aiddirse ona uygun emeliyyat apaririq
if (Tools.SIBRScoringTypesGroups.Motor_Skills.ToDescriptionString().Contains(string.Format(",{0},", SIBRScoringTypesID)))
{
MS += W;
}
else if (Tools.SIBRScoringTypesGroups.Social_Interaction_Communication_Skills.ToDescriptionString().Contains(string.Format(",{0},", SIBRScoringTypesID)))
{
SC += W;
}
else if (Tools.SIBRScoringTypesGroups.Personal_Living_Skills.ToDescriptionString().Contains(string.Format(",{0},", SIBRScoringTypesID)))
{
PL += W;
}
else if (Tools.SIBRScoringTypesGroups.Community_Living_Skills.ToDescriptionString().Contains(string.Format(",{0},", SIBRScoringTypesID)))
{
CL += W;
}
DtSIBRAdaptiveScores.Rows.Add(_SIBRID, SIBRScoringTypesID, SumA, SumB, SumC, W);
}
}
MS = Math.Round(MS / 2);
SC = Math.Round(SC / 3);
PL = Math.Round(PL / 5);
CL = Math.Round(CL / 4);
BI = Math.Round((MS + SC + PL + CL) / 4);
//Short ve Early Development Form xaric hamisini getirek
DataTable DtNormF = DALC.GetSIBRNormFForFullScale(AgeYear, AgeMonth);
if (DtNormF == null || DtNormF.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Norm F cədvəlindən uyğun məlumat tapılmadı.");
return;
}
decimal SumW = 0, REFW = 0, DIFF = 0;
int SEMSS = 0, COLUMNS_DIFF_P = 0, COLUMNS_DIFF_N = 0;
int SS = 0, SS_SEM_N = 0, SS_SEM_P = 0;
int SIBRAdaptiveSkillLevelsID;
string RMI = "";
decimal PR = 0;
int SIBRScoringTypesGroupsID = 0;
foreach (DataRow Dr in DtNormF.Rows)
{
REFW = Dr["REFW"]._ToInt32();
SEMSS = Dr["SEMSS"]._ToInt32();
COLUMNS_DIFF_P = Dr["DIFF_P"]._ToInt32();
COLUMNS_DIFF_N = Dr["DIFF_N"]._ToInt32();
if (Dr["SIBRNormFTypesID"]._ToInt16() == (int)Tools.SIBRNormFTypes.Motor_Skills)
{
SumW = MS;
DIFF = MS - REFW;
SIBRScoringTypesGroupsID = (int)Tools.SIBRScoringTypesGroups.Motor_Skills;
}
else if (Dr["SIBRNormFTypesID"]._ToInt16() == (int)Tools.SIBRNormFTypes.Social_Interaction_Communication_Skills)
{
SumW = SC;
DIFF = SC - REFW;
SIBRScoringTypesGroupsID = (int)Tools.SIBRScoringTypesGroups.Social_Interaction_Communication_Skills;
}
else if (Dr["SIBRNormFTypesID"]._ToInt16() == (int)Tools.SIBRNormFTypes.Personal_Living_Skills)
{
SumW = PL;
DIFF = PL - REFW;
SIBRScoringTypesGroupsID = (int)Tools.SIBRScoringTypesGroups.Personal_Living_Skills;
}
else if (Dr["SIBRNormFTypesID"]._ToInt16() == (int)Tools.SIBRNormFTypes.Community_Living_Skills)
{
SumW = CL;
DIFF = CL - REFW;
SIBRScoringTypesGroupsID = (int)Tools.SIBRScoringTypesGroups.Community_Living_Skills;
}
else if (Dr["SIBRNormFTypesID"]._ToInt16() == (int)Tools.SIBRNormFTypes.Broad_Independence)
{
SumW = BI;
DIFF = BI - REFW;
SIBRScoringTypesGroupsID = (int)Tools.SIBRScoringTypesGroups.Broad_Independence_Full_Scale;
}
DataTable DtNormG = new DataTable();
if (DIFF >= 0)
{
DtNormG = DALC.GetSIBRNormG(COLUMNS_DIFF_P, DIFF._ToInt32());
}
else
{
DtNormG = DALC.GetSIBRNormG(COLUMNS_DIFF_N, DIFF._ToInt32());
}
if (DtNormG == null || DtNormG.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Norm G cədvəlindən uyğun məlumat tapılmadı.");
return;
}
RMI = DtNormG._Rows("RMI");
SS = DtNormG._RowsObject("SS")._ToInt32();
SS_SEM_N = SS - SEMSS;
SS_SEM_P = SS + SEMSS;
PR = Convert.ToDecimal(DtNormG._RowsObject("PR"));
SIBRAdaptiveSkillLevelsID = DALC.GetSIBRAdaptiveSkillLevels(DIFF._ToInt32());
if (SIBRAdaptiveSkillLevelsID == -1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Adaptive Behavior Skill Levels cədvəlindən məlumat tapılmadı.");
return;
}
DtSIBRAdaptiveResult.Rows.Add(_SIBRID,
SIBRScoringTypesGroupsID,
SumW,
REFW,
SEMSS,
COLUMNS_DIFF_P,
COLUMNS_DIFF_N,
DIFF,
RMI,
SS,
SS_SEM_N,
SS_SEM_P,
PR,
SIBRAdaptiveSkillLevelsID);
}
_Result = DALC.InsertBulk(Tools.Table.SIBRAdaptiveScores, DtSIBRAdaptiveScores, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
_Result = DALC.InsertBulk(Tools.Table.SIBRAdaptiveResult, DtSIBRAdaptiveResult, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
DataTable DtSIBRNormI = DALC.GetSIBRNomrIForBroadIndependence(Tools.SIBRNormITypes.Broad_Independence_W, BI._ToInt32(), General);
if (DtSIBRNormI == null)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
if (DtSIBRNormI.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Norm I cədvəlindən uyğun məlumat tapılmadı.");
return;
}
int SupportScore = DtSIBRNormI._Rows("Value")._ToInt32();
Dictionary <string, object> DicMaladaptive = new Dictionary <string, object>()
{
{ "SIBRID", _SIBRID },
{ "Internalized", Internalized },
{ "Asocial", Asocial },
{ "Externalized", Externalized },
{ "General", General },
{ "SupportScore", SupportScore }
};
_Result = DALC.InsertDatabase(Tools.Table.SIBRMaladaptiveScores, DicMaladaptive, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
DataTable DtDetailsTypes = DALC.GetList(Tools.Table.SIBRMaladaptiveScoresDetailsTypes, "");
if (DtDetailsTypes == null || DtDetailsTypes.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
DataTable DtMaladaptiveScoresDetails = new DataTable();
DtMaladaptiveScoresDetails.Columns.Add("SIBRMaladaptiveScoresID", typeof(int));
DtMaladaptiveScoresDetails.Columns.Add("SIBRMaladaptiveScoresDetailsTypesID", typeof(byte));
DtMaladaptiveScoresDetails.Columns.Add("FrequencyRaiting", typeof(byte));
DtMaladaptiveScoresDetails.Columns.Add("SeverityRaiting", typeof(byte));
int x = 1, y = 2;
byte Frequency, Severity;
foreach (DataRow Dr in DtDetailsTypes.Rows)
{
if (!byte.TryParse(((TextBox)PnlProblemBehavior.FindControl(string.Format("Txt{0}", x))).Text, out Frequency) ||
!byte.TryParse(((TextBox)PnlProblemBehavior.FindControl(string.Format("Txt{0}", y))).Text, out Severity))
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Problem Behavior dəyərlərini düzgün qeyd edin!");
return;
}
DtMaladaptiveScoresDetails.Rows.Add(_Result, Convert.ToByte(Dr["ID"]), Frequency, Severity);
}
_Result = DALC.InsertBulk(Tools.Table.SIBRMaladaptiveScoresDetails, DtMaladaptiveScoresDetails, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
Dictionary <string, object> AddServicesDictionary = new Dictionary <string, object>();
AddServicesDictionary.Add("ApplicationsPersonsID", _ApplicationsPersonsID);
AddServicesDictionary.Add("ServicesID", (int)Tools.Services.SIB_R_tam_miqyaslı_forma);
AddServicesDictionary.Add("ApplicationsPersonsServicesStatusID", (int)Tools.ApplicationsPersonsServicesStatus.Həll_olunub_təmin_edilib);
AddServicesDictionary.Add("IsFirstApplication", false);
AddServicesDictionary.Add("IsActive", true);
AddServicesDictionary.Add("Add_Dt", DateTime.Now);
AddServicesDictionary.Add("Add_Ip", Request.UserHostAddress.IPToInteger());
_Result = DALC.InsertDatabase(Tools.Table.ApplicationsPersonsServices, AddServicesDictionary, Transaction, true);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
Config.RedirectURL(string.Format("/tools/sib-r/result/?i={0}&id={1}", Cryptography.Encrypt(string.Format("{0}-{1}-{2}", _ApplicationsID, _ApplicationsPersonsID, DALC._GetUsersLogin.Key)), Cryptography.Encrypt(_SIBRID._ToString())));
}
//davam etmek lazimdir
private void CalculationByTypes(Tools.SIBRTypes SIBRTypes)
{
Tools.SIBRNormFTypes SIBRNormFTypes = Tools.SIBRNormFTypes.Early_Development_Form;
Tools.SIBRNormITypes SIBRNormITypes = Tools.SIBRNormITypes.Early_Development_Form_W;
if (SIBRTypes == Tools.SIBRTypes.Short_Form)
{
SIBRNormFTypes = Tools.SIBRNormFTypes.Short_Form;
SIBRNormITypes = Tools.SIBRNormITypes.Short_Form_W;
}
int Internalized, Asocial, Externalized, General;
int.TryParse(HdnFinalBox1.Value, out Internalized);
int.TryParse(HdnFinalBox2.Value, out Asocial);
int.TryParse(HdnFinalBox3.Value, out Externalized);
int.TryParse(HdnFinalBox4.Value, out General);
int AgeYear, AgeMonth;
int.TryParse(HdnAgeYear.Value, out AgeYear);
int.TryParse(HdnAgeMonth.Value, out AgeMonth);
if (AgeYear >= 19)
{
AgeMonth = AgeYear;
}
if (AgeYear > 81)
{
AgeYear = 81;
AgeMonth = 81;
}
DALC.Transaction Transaction = new DALC.Transaction();
Dictionary <string, object> DictionarySIBR = new Dictionary <string, object>
{
{ "SIBRTypesID", (int)SIBRTypes },
{ "ApplicationsPersonsID", _ApplicationsPersonsID },
{ "AgeYear", AgeYear },
{ "AgeMonth", AgeMonth },
{ "Description", TxtDescription.Text },
{ "IsCompleted", true },
{ "IsActive", true },
{ "Create_Dt", Config.DateTimeFormat(string.Format("{0}.{1}.{2}", TxtTestingDateDay.Text, TxtTestingDateMonth.Text, TxtTestingDateYear.Text)) },
{ "SIBRStatusID", (int)Tools.SIBRStatus.Aktiv },
{ "Add_Dt", DateTime.Now },
{ "Add_Ip", Request.UserHostAddress.IPToInteger() }
};
_Result = DALC.InsertDatabase(Tools.Table.SIBR, DictionarySIBR, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
_SIBRID = _Result;
int Page2SumA, Page2SumB, Page2SumC, Page3SumA, Page3SumB, Page3SumC, SumA, SumB, SumC, SIBRScoringTypesID, RawScore, W;
decimal BI = 0;
int.TryParse(TxtPage2SumA.Text, out Page2SumA);
int.TryParse(TxtPage2SumB.Text, out Page2SumB);
int.TryParse(TxtPage2SumC.Text, out Page2SumC);
int.TryParse(TxtPage3SumA.Text, out Page3SumA);
int.TryParse(TxtPage3SumB.Text, out Page3SumB);
int.TryParse(TxtPage3SumC.Text, out Page3SumC);
SumA = Page2SumA + Page3SumA;
SumB = Page2SumB + Page3SumB;
SumC = Page2SumC + Page3SumC;
SIBRScoringTypesID = (int)Tools.SIBRScoringTypes.Broad_Independence;
int.TryParse(LblTotalRawScore.Text, out RawScore);
W = DALC.GetSIBRScoring(SIBRTypes, SIBRScoringTypesID, RawScore)._RowsInt("W");
BI = W;
Dictionary <string, object> DicSIBRAdaptiveScores = new Dictionary <string, object>
{
{ "SIBRID", _SIBRID },
{ "SIBRScoringTypesID", SIBRScoringTypesID },
{ "SumA", SumA },
{ "SumB", SumB },
{ "SumC", SumC },
{ "W", W },
};
DataTable DtNormF = DALC.GetSIBRNormFByTypesID(SIBRNormFTypes, AgeYear, AgeMonth);
if (DtNormF == null || DtNormF.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Norm F cədvəlindən uyğun məlumat tapılmadı.");
return;
}
decimal SumW = 0, REFW = 0, DIFF = 0;
int SEMSS = 0, COLUMNS_DIFF_P = 0, COLUMNS_DIFF_N = 0;
int SS = 0, SS_SEM_N = 0, SS_SEM_P = 0;
int SIBRAdaptiveSkillLevelsID;
string RMI = "";
decimal PR = 0;
int SIBRScoringTypesGroupsID = 0;
try
{
SumW = W;
REFW = DtNormF._RowsInt("REFW");
SEMSS = DtNormF._RowsInt("SEMSS");
COLUMNS_DIFF_P = DtNormF._RowsInt("DIFF_P");
COLUMNS_DIFF_N = DtNormF._RowsInt("DIFF_N");
DIFF = W - REFW;
}
catch
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
SIBRScoringTypesGroupsID = (int)Tools.SIBRScoringTypesGroups.Broad_Independence_Full_Scale;
DataTable DtNormG = new DataTable();
if (DIFF >= 0)
{
DtNormG = DALC.GetSIBRNormG(COLUMNS_DIFF_P, DIFF._ToInt32());
}
else
{
DtNormG = DALC.GetSIBRNormG(COLUMNS_DIFF_N, DIFF._ToInt32());
}
if (DtNormG == null || DtNormG.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Norm G cədvəlindən uyğun məlumat tapılmadı.");
return;
}
RMI = DtNormG._Rows("RMI");
SS = DtNormG._RowsObject("SS")._ToInt32();
SS_SEM_N = SS - SEMSS;
SS_SEM_P = SS + SEMSS;
PR = Convert.ToDecimal(DtNormG._RowsObject("PR"));
SIBRAdaptiveSkillLevelsID = DALC.GetSIBRAdaptiveSkillLevels(DIFF._ToInt32());
if (SIBRAdaptiveSkillLevelsID == -1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Adaptive Behavior Skill Levels cədvəlindən məlumat tapılmadı.");
return;
}
Dictionary <string, object> DicSIBRAdaptiveResult = new Dictionary <string, object>
{
{ "SIBRID", _SIBRID },
{ "SIBRScoringTypesGroupsID", SIBRScoringTypesGroupsID },
{ "SumW", SumW },
{ "REFW", REFW },
{ "SEMSS", SEMSS },
{ "COLUMNS_DIFF_P", COLUMNS_DIFF_P },
{ "COLUMNS_DIFF_N", COLUMNS_DIFF_N },
{ "DIFF", DIFF },
{ "RMI", RMI },
{ "SS", SS },
{ "SS_SEM_N", SS_SEM_N },
{ "SS_SEM_P", SS_SEM_P },
{ "PR", PR },
{ "SIBRAdaptiveSkillLevelsID", SIBRAdaptiveSkillLevelsID }
};
_Result = DALC.InsertDatabase(Tools.Table.SIBRAdaptiveScores, DicSIBRAdaptiveScores, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
_Result = DALC.InsertDatabase(Tools.Table.SIBRAdaptiveResult, DicSIBRAdaptiveResult, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
DataTable DtSIBRNormI = DALC.GetSIBRNomrIForBroadIndependence(SIBRNormITypes, W, General);
if (DtSIBRNormI == null)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
if (DtSIBRNormI.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Norm I cədvəlindən uyğun məlumat tapılmadı.");
return;
}
int SupportScore = DtSIBRNormI._Rows("Value")._ToInt32();
Dictionary <string, object> DicMaladaptive = new Dictionary <string, object>()
{
{ "SIBRID", _SIBRID },
{ "Internalized", Internalized },
{ "Asocial", Asocial },
{ "Externalized", Externalized },
{ "General", General },
{ "SupportScore", SupportScore }
};
_Result = DALC.InsertDatabase(Tools.Table.SIBRMaladaptiveScores, DicMaladaptive, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
DataTable DtDetailsTypes = DALC.GetList(Tools.Table.SIBRMaladaptiveScoresDetailsTypes, "");
if (DtDetailsTypes == null || DtDetailsTypes.Rows.Count < 1)
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
DataTable DtMaladaptiveScoresDetails = new DataTable();
DtMaladaptiveScoresDetails.Columns.Add("SIBRMaladaptiveScoresID", typeof(int));
DtMaladaptiveScoresDetails.Columns.Add("SIBRMaladaptiveScoresDetailsTypesID", typeof(byte));
DtMaladaptiveScoresDetails.Columns.Add("FrequencyRaiting", typeof(byte));
DtMaladaptiveScoresDetails.Columns.Add("SeverityRaiting", typeof(byte));
int x = 1, y = 2;
byte Frequency, Severity;
foreach (DataRow Dr in DtDetailsTypes.Rows)
{
if (!byte.TryParse(((TextBox)PnlProblemBehavior.FindControl(string.Format("Txt{0}", x))).Text, out Frequency) ||
!byte.TryParse(((TextBox)PnlProblemBehavior.FindControl(string.Format("Txt{0}", y))).Text, out Severity))
{
TransactionRollBack(Transaction);
Config.MsgBoxAjax("Problem Behavior dəyərlərini düzgün qeyd edin!");
return;
}
DtMaladaptiveScoresDetails.Rows.Add(_Result, Convert.ToByte(Dr["ID"]), Frequency, Severity);
}
_Result = DALC.InsertBulk(Tools.Table.SIBRMaladaptiveScoresDetails, DtMaladaptiveScoresDetails, Transaction);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
Dictionary <string, object> AddServicesDictionary = new Dictionary <string, object>();
AddServicesDictionary.Add("ApplicationsPersonsID", _ApplicationsPersonsID);
AddServicesDictionary.Add("ServicesID", (int)Tools.Services.SIB_R_tam_miqyaslı_forma);
AddServicesDictionary.Add("ApplicationsPersonsServicesStatusID", (int)Tools.ApplicationsPersonsServicesStatus.Həll_olunub_təmin_edilib);
AddServicesDictionary.Add("IsFirstApplication", false);
AddServicesDictionary.Add("IsActive", true);
AddServicesDictionary.Add("Add_Dt", DateTime.Now);
AddServicesDictionary.Add("Add_Ip", Request.UserHostAddress.IPToInteger());
_Result = DALC.InsertDatabase(Tools.Table.ApplicationsPersonsServices, AddServicesDictionary, Transaction, true);
if (_Result < 1)
{
Config.MsgBoxAjax(Config._DefaultErrorMessages);
return;
}
Config.RedirectURL(string.Format("/tools/sib-r/result/?i={0}&id={1}", Cryptography.Encrypt(string.Format("{0}-{1}-{2}", _ApplicationsID, _ApplicationsPersonsID, DALC._GetUsersLogin.Key)), Cryptography.Encrypt(_SIBRID._ToString())));
}
