public response Validare()
{
response toReturn = new response(true, "", null, null, new List <Error>());;
Error err = new Error();
if (this.NR_SENTINTA == null || this.NR_SENTINTA.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyNrSentinta");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (this.DATA_SENTINTA == null || this.DATA_SENTINTA == new DateTime())
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyDataSentinta");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
/*
* if (this.ID_SOLUTIE == null || this.ID_SOLUTIE <= 0)
* {
* toReturn.Status = false;
* err = ErrorParser.ErrorMessage("emptySolutieSentinta");
* toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
* toReturn.InsertedId = null;
* toReturn.Error.Add(err);
* }
*/
return(toReturn);
}
public response Validare()
{
bool succes;
response toReturn = Validator.Validate(authenticatedUserId, connectionString, this, _TABLE_NAME, out succes);
if (!succes) // daca nu s-au putut citi validarile din fisier, sau nu sunt definite in fisier, mergem pe varianta hardcodata
{
toReturn = new response(true, "", null, null, new List <Error>());;
Error err = new Error();
if (this.NAME == null || this.NAME.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyNumeActiune");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (this.ACTION == null || this.ACTION.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyAction");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
}
return(toReturn);
}
public response Validare()
{
bool succes;
response toReturn = Validator.Validate(authenticatedUserId, connectionString, this, _TABLE_NAME, out succes);
if (!succes) // daca nu s-au putut citi validarile din fisier, sau nu sunt definite in fisier, mergem pe varianta hardcodata
{
toReturn = new response(true, "", null, null, new List <Error>());
Error err = new Error();
if (String.IsNullOrWhiteSpace(this.NR_CONTRACT))
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyNrContract");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (this.DATA_CONTRACT == null)
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyDataContract");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
}
return(toReturn);
}
/// <summary>
/// Metoda pentru validarea Utilizatorului curent
/// </summary>
/// <returns>SOCISA.response = new object(bool = status, string = error message, int = id-ul cheie returnat)</returns>
public response Validare()
{
response toReturn = new response(true, "", null, null, new List <Error>());;
Error err = new Error();
if (this.USER_NAME == null || this.USER_NAME.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyUserName");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (this.PASSWORD == null || this.PASSWORD.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyUserPassword");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
return(toReturn);
}
public response Validare()
{
bool succes;
response toReturn = Validator.Validate(authenticatedUserId, connectionString, this, _TABLE_NAME, out succes);
Error err = new Error();
if (!succes) // daca nu s-au putut citi validarile din fisier, sau nu sunt definite in fisier, mergem pe varianta hardcodata
{
toReturn = new response(true, "", null, null, new List <Error>());;
if (this.NR_DOCUMENT == null || this.NR_DOCUMENT.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyNrDocumentPlata");
toReturn.Message = string.Format("{0}{1};", toReturn.Message ?? "", err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (this.DATA_DOCUMENT == null)
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyDataDocumentPlata");
toReturn.Message = string.Format("{0}{1};", toReturn.Message ?? "", err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (this.SUMA == null)
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptySumaPlata");
toReturn.Message = string.Format("{0}{1};", toReturn.Message ?? "", err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (this.ID_DOSAR == null)
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyIdDosarPlata");
toReturn.Message = string.Format("{0}{1};", toReturn.Message ?? "", err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (this.ID_TIP_PLATA == null)
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyIdTipPlata");
toReturn.Message = string.Format("{0}{1};", toReturn.Message ?? "", err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
}
if (this.ID_DOSAR != null && !((Dosar)this.GetDosar().Result).IsAvizat())
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("dosarNeavizat");
toReturn.Message = string.Format("{0}{1};", toReturn.Message ?? "", err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
return(toReturn);
}
/// <summary>
/// Metoda pentru validarea stadiului curent
/// </summary>
/// <returns>SOCISA.response = new object(bool = status, string = error message, int = id-ul cheie returnat)</returns>
public response Validare()
{
response toReturn = new response(true, "", null, null, new List <Error>());;
Error err = new Error();
if (this.DENUMIRE == null || this.DENUMIRE.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyDenumireStadiu");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
return(toReturn);
}
public response Login(string user_name, string password, string ip)
{
try
{
Utilizator u = null;
// singura metoda, impreuna cu Find(email), care nu foloseste DataAccess pt. ca nu avem authenticatedUserId
MD5 md5h = MD5.Create();
string md5p = CommonFunctions.GetMd5Hash(md5h, password);
MySqlConnection con = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "LOGINsp";
cmd.Parameters.Add(new MySqlParameter("_username", user_name));
cmd.Parameters.Add(new MySqlParameter("_password", md5p));
cmd.Parameters.Add(new MySqlParameter("_ip", ip));
con.Open();
MySqlDataReader r = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (r.Read())
{
authenticatedUserId = Convert.ToInt32(r["ID"]);
u = new Utilizator(Convert.ToInt32(authenticatedUserId), connectionString, r);
break;
}
r.Close(); r.Dispose();
if (con != null && con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
}
if (u != null)
{
return(new response(true, JsonConvert.SerializeObject(u), u, null, null));
}
Error err = ErrorParser.ErrorMessage("unauthorisedUser");
return(new response(true, err.ERROR_MESSAGE, null, null, new System.Collections.Generic.List <Error>()
{
err
}));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
public response Validare()
{
response toReturn = new response(true, "", null, null, new List <Error>());;
Error err = new Error();
if (this.ID_SENDER <= 0)
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyMessageSender");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
/*
* if (((Utilizator[])this.GetReceiversByIdDosar().Result).Length == 0)
* {
* toReturn.Status = false;
* err = ErrorParser.ErrorMessage("emptyMessageReceiver");
* toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
* toReturn.InsertedId = null;
* toReturn.Error.Add(err);
* }
*/
if (this.SUBIECT == null || this.SUBIECT.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyMessageSubject");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
/*
* if (this.BODY == null || this.BODY.Trim() == "")
* {
* toReturn.Status = false;
* err = ErrorParser.ErrorMessage("emptyMessageBody");
* toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
* toReturn.InsertedId = null;
* toReturn.Error.Add(err);
* }
*/
return(toReturn);
}
public JsonResult SetPassword(int id_utilizator, string password, string confirmPassword)
{
response r = new response();
if (password != confirmPassword) // alte validari aici !!!
{
r = new response(false, "Parolele nu coincid!", null, null, new List <Error>()
{
ErrorParser.ErrorMessage("passwordsDontMatch")
});
return(Json(r, JsonRequestBehavior.AllowGet));
}
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]);
UtilizatoriRepository ur = new UtilizatoriRepository(_CURENT_USER_ID, conStr);
r = ur.SetPassword(id_utilizator, password);
return(Json(r, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Metoda pentru validarea societatii de asigurare curente
/// </summary>
/// <param name="_validareSimpla">Pt. validari din import</param>
/// <returns>SOCISA.response = new object(bool = status, string = error message, int = id-ul cheie returnat)</returns>
public response Validare(bool _validareSimpla)
{
bool succes;
response toReturn = Validator.Validate(authenticatedUserId, connectionString, this, _TABLE_NAME, out succes);
if (!succes) // daca nu s-au putut citi validarile din fisier, sau nu sunt definite in fisier, mergem pe varianta hardcodata
{
toReturn = new response(true, "", null, null, new List <Error>());;
Error err = new Error();
if (this.DENUMIRE_SCURTA == null || this.DENUMIRE_SCURTA.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyDenumireScurtaSocietate");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
if (!_validareSimpla)
{
if (this.DENUMIRE == null || this.DENUMIRE.Trim() == "")
{
toReturn.Status = false;
err = ErrorParser.ErrorMessage("emptyDenumireSocietate");
toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
toReturn.InsertedId = null;
toReturn.Error.Add(err);
}
/*
* if (this.CUI == null || this.CUI.Trim() == "")
* {
* toReturn.Status = false;
* err = ErrorParser.ErrorMessage("emptyCuiSocietate");
* toReturn.Message = string.Format("{0}{1};", toReturn.Message == null ? "" : toReturn.Message, err.ERROR_MESSAGE);
* toReturn.InsertedId = null;
* toReturn.Error.Add(err);
* }
*/
}
}
return(toReturn);
}
public virtual response ValidareColoane(string fieldValueCollection)
{
response toReturn = new response(true, null, null, null, new List <Error>());
try
{
Dictionary <string, string> changes = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, string> >(fieldValueCollection, CommonFunctions.JsonDeserializerSettings);
foreach (string fieldName in changes.Keys)
{
bool gasit = false;
PropertyInfo[] props = this.GetType().GetProperties();
foreach (PropertyInfo prop in props)
{
if (fieldName.ToUpper() == prop.Name.ToUpper())
{
gasit = true;
break;
}
}
if (!gasit)
{
Error err = ErrorParser.ErrorMessage("campInexistentInTabela");
return(new response(false, err.ERROR_MESSAGE, null, null, new List <Error>()
{
err
}));
}
}
}
catch
{
Error err = ErrorParser.ErrorMessage("cannotConvertStringToTableColumns");
return(new response(false, err.ERROR_MESSAGE, null, null, new List <Error>()
{
err
}));
}
return(toReturn);
}
public response Find(string email)
{
try
{
// singura metoda, impreuna cu Login, care nu foloseste DataAccess pt. ca nu avem authenticatedUserId
Utilizator u = null;
MySqlConnection con = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UTILIZATORIsp_GetByEmail";
cmd.Parameters.Add(new MySqlParameter("_EMAIL", email));
con.Open();
MySqlDataReader r = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (r.Read())
{
authenticatedUserId = Convert.ToInt32(r["ID"]);
u = new Utilizator(Convert.ToInt32(authenticatedUserId), connectionString, r);
break;
}
r.Close(); r.Dispose();
if (u != null)
{
return(new response(true, JsonConvert.SerializeObject(u), u, null, null));
}
Error err = ErrorParser.ErrorMessage("unauthorisedUser");
return(new response(false, err.ERROR_MESSAGE, null, null, new List <Error>()
{
err
}));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new List <Error>()
{
new Error(exp)
})); }
}
public response GetPlatiFromExcel(string sheet, string fileName)
{
try
{
FileInfo fi = new FileInfo(File.Exists(fileName) ? fileName : Path.Combine(CommonFunctions.GetImportsFolder(), fileName));
ExcelPackage ep = new ExcelPackage(fi);
ExcelWorksheet ews = ep.Workbook.Worksheets[sheet];
Dictionary <string, int> columnNames = new Dictionary <string, int>();
int colIndex = 1;
foreach (var firstRowCell in ews.Cells[1, 1, 1, ews.Dimension.End.Column])
{
columnNames.Add(firstRowCell.Text, colIndex);
colIndex++;
}
List <object[]> toReturnList = new List <object[]>();
//TO DO: trebuie stabilita maparea exacta cu coloanele din Excel !!!
Nomenclator TipPlata = new Nomenclator(authenticatedUserId, connectionString, "tip_plata", "DIRECTA");
Dosar dosar = null;
for (var rowNumber = 2; rowNumber <= ews.Dimension.End.Row; rowNumber++)
{
try
{
response toReturn = new response(true, "", null, null, new List <Error>());;
response r = new response();
List <PlataExtended> plati = new List <PlataExtended>();
try
{
dosar = new Dosar(authenticatedUserId, connectionString, ews.Cells[rowNumber, columnNames["DOSAR"]].Text.Trim());
if (dosar == null || dosar.ID == null)
{
Error err = ErrorParser.ErrorMessage("dosarInexistent");
List <Error> errs = new List <Error>();
errs.Add(err);
r = new response(false, err.ERROR_MESSAGE, null, null, errs);
toReturn.AddResponse(r);
}
else
{
if (!dosar.IsAvizat())
{
Error err = ErrorParser.ErrorMessage("dosarNeavizat");
List <Error> errs = new List <Error>();
errs.Add(err);
r = new response(false, err.ERROR_MESSAGE, null, null, errs);
toReturn.AddResponse(r);
}
}
}
catch (Exception exp)
{
LogWriter.Log(exp);
}
for (int i = 1; i < 6; i++) // platile in Excel sunt pe coloane si consideram maxim 5 plati
{
try
{
if (!String.IsNullOrWhiteSpace(ews.Cells[rowNumber, columnNames["DOCUMENT_PLATA" + i.ToString()]].Text.Trim()) && Double.TryParse(ews.Cells[rowNumber, columnNames["SUMA_RECUPERATA" + i.ToString()]].Text.Trim(), out double tmpSuma) && CommonFunctions.SwitchBackFormatedDate(ews.Cells[rowNumber, columnNames["DATA_PLATA" + i.ToString()]].Text.Trim()) != null)
{
Plata plata = new Plata(authenticatedUserId, connectionString);
try { plata.NR_DOCUMENT = ews.Cells[rowNumber, columnNames["DOCUMENT_PLATA" + i.ToString()]].Text.Trim(); }
catch { }
try { plata.DATA_DOCUMENT = CommonFunctions.SwitchBackFormatedDate(ews.Cells[rowNumber, columnNames["DATA_PLATA" + i.ToString()]].Text.Trim()); }
catch { }
try { plata.SUMA = Convert.ToDouble(ews.Cells[rowNumber, columnNames["SUMA_RECUPERATA" + i.ToString()]].Text.Trim()); }
catch { }
try { plata.ID_DOSAR = dosar.ID; }
catch { }
try { plata.ID_TIP_PLATA = TipPlata.ID; }
catch { }
plati.Add(new PlataExtended(plata));
}
}
catch { }
}
foreach (PlataExtended plataExtended in plati)
{
Plata tmpPlata = new Plata(authenticatedUserId, connectionString, plataExtended.Plata);
if (tmpPlata != null && tmpPlata.ID != null)
{
Error err = ErrorParser.ErrorMessage("plataExistenta");
List <Error> errs = new List <Error>();
errs.Add(err);
r = new response(false, err.ERROR_MESSAGE, null, null, errs);
toReturn.AddResponse(r);
}
r = plataExtended.Plata.Validare();
if (!r.Status)
{
toReturn.AddResponse(r);
}
//pt. cazul in care avem duplicate in excel si platile nu sunt inca in baza de date !
for (int i = 0; i < toReturnList.Count; i++)
{
tmpPlata = ((PlataExtended)toReturnList[i][1]).Plata;
if (tmpPlata.NR_DOCUMENT == plataExtended.Plata.NR_DOCUMENT && tmpPlata.DATA_DOCUMENT == plataExtended.Plata.DATA_DOCUMENT && tmpPlata.SUMA == plataExtended.Plata.SUMA && tmpPlata.ID_DOSAR == plataExtended.Plata.ID_DOSAR)
{
Error err = new Error();
response nr = new response(false, null, null, null, new List <Error>());
nr.Status = false;
err = ErrorParser.ErrorMessage("plataExistenta");
nr.Message = string.Format("{0}{1};", nr.Message ?? "", err.ERROR_MESSAGE);
nr.InsertedId = null;
nr.Error.Add(err);
toReturn.AddResponse(nr);
break;
}
}
toReturnList.Add(new object[] { toReturn, plataExtended });
}
}
catch (Exception exp)
{
LogWriter.Log(exp);
}
}
return(new response(true, JsonConvert.SerializeObject(toReturnList.ToArray(), CommonFunctions.JsonSerializerSettings), toReturnList.ToArray(), null, null));
}
catch (Exception exp)
{
LogWriter.Log(exp);
return(new response(false, exp.Message, null, null, new List <Error>()
{
new Error(exp)
}));
}
}
