public MarkerDAL(IInfraDal _dal)
{
dal = _dal;
con = dal.Connect("Server=LAPTOP-6F3MEUHT\\SQLEXPRESS;Database=Images1;" +
"Trusted_Connection=True;");
_paramConverter = new DBParameterConverter(dal);
}
public SharingDAL(IInfraDal _dal)
{
dal = _dal;
con = dal.Connect("Server=(localdb)\\MSSQLLocalDB;Database=Images;" +
"Trusted_Connection=True;");
_paramConverter = new DBParameterConverter(dal);
}
public DocumentDAL(IInfraDal SQLDAL, IDocumentSharingDAL DocumentSharingDAL)
{
_DocumentSharingDAL = DocumentSharingDAL;
_SQLDAL = SQLDAL;
_paramConverter = new DBParameterConverter(_SQLDAL);
con = _SQLDAL.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" + "Trusted_Connection=True;");
}
public MarkerRsponse RemoveMarker(MarkerRequestRemove request)
{
MarkerRsponse response = default;
try
{
var con = _SQLdal.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" + "Trusted_Connection=True;");
var parameters = new DBParameterConverter(_SQLdal).ConvertToParameters(request);
var dataset = _SQLdal.ExecSPQuery("RemoveMarker", con, parameters);
if (dataset != null)
{
response = new MarkerResponseRemoveOk();
}
}
catch (Exception e)
{
response = new MarkerRsponseDontRemove();
throw;
}
return(response);
}
public DocumentSharingDAL(IInfraDal SQLDAL)
{
_SQLDAL = SQLDAL;
_paramConverter = new DBParameterConverter(_SQLDAL);
}
public RegisterUserDAL(IInfraDal SQLDAL)
{
_SQLDAL = SQLDAL;
_DalParametersConverter = new DBParameterConverter(new SQLDAL());
con = _SQLDAL.Connect("Server=LAPTOP-B6F4SVRM;Database=DocumentProject;" + "Trusted_Connection=True;");
}
public MarkersDAL(IInfraDal dal)
{
_SQLdal = dal;
_paramConverter = new DBParameterConverter(_SQLdal);
}