public DataSet Compare(prop objValue)
{
SqlParameter[] Para = new SqlParameter[1];
Para[0] = new SqlParameter("@Mode", "Compare");
ds = di.GetDataPara("SP_Admin_Login", Para);
return(ds);
}
/// <inheritdoc />
public async Task <IWebDavResult> RefreshLockAsync(string path, IfHeader ifHeader, TimeoutHeader timeoutHeader, CancellationToken cancellationToken)
{
if (_lockManager == null)
{
throw new NotSupportedException();
}
if (ifHeader.Lists.Any(x => x.Path.IsAbsoluteUri))
{
throw new InvalidOperationException("A Resource-Tag pointing to a different server or application isn't supported.");
}
var timeout = _timeoutPolicy?.SelectTimeout(
timeoutHeader?.Values ?? new[] { TimeoutHeader.Infinite })
?? TimeoutHeader.Infinite;
var result = await _lockManager.RefreshLockAsync(_rootFileSystem, ifHeader, timeout, cancellationToken);
if (result.ErrorResponse != null)
{
return(new WebDavResult <error>(WebDavStatusCode.PreconditionFailed, result.ErrorResponse.error));
}
Debug.Assert(result.RefreshedLocks != null, "result.RefreshedLocks != null");
var prop = new prop()
{
Any = result.RefreshedLocks.Select(x => new XElement(WebDavXml.Dav + "lockdiscovery", x.ToXElement())).ToArray(),
};
return(new WebDavResult <prop>(WebDavStatusCode.OK, prop));
}
private async Task <IWebDavResult> HandlePropAsync([NotNull] prop prop, [NotNull][ItemNotNull] IReadOnlyCollection <IEntry> entries, CancellationToken cancellationToken)
{
var responses = new List <response>();
foreach (var entry in entries)
{
var entryPath = entry.Path.OriginalString;
var href = _context.PublicControllerUrl.Append(entryPath, true);
if (!_options.UseAbsoluteHref)
{
href = new Uri("/" + _context.PublicRootUrl.MakeRelativeUri(href).OriginalString, UriKind.Relative);
}
var collector = new PropertyCollector(this, _context, new ReadableFilter(), new PropFilter(prop));
var propStats = await collector.GetPropertiesAsync(entry, int.MaxValue, cancellationToken).ConfigureAwait(false);
var response = new response()
{
href = href.OriginalString,
ItemsElementName = propStats.Select(x => ItemsChoiceType2.propstat).ToArray(),
Items = propStats.Cast <object>().ToArray(),
};
responses.Add(response);
}
var result = new multistatus()
{
response = responses.ToArray(),
};
return(new WebDavResult <multistatus>(WebDavStatusCode.MultiStatus, result));
}
public DataSet CountrySelectById(prop objValue)
{
SqlParameter[] Para = new SqlParameter[2];
Para[0] = new SqlParameter("@Mode", "selectById");
Para[1] = new SqlParameter("@CountryId", objValue.CountryId);
ds = di.GetDataPara("SP_Country", Para);
return(ds);
}
public DataSet StateSelectById(prop objValue)
{
SqlParameter[] Para = new SqlParameter[2];
Para[0] = new SqlParameter("@Mode", "selectById");
Para[1] = new SqlParameter("@StateId", objValue.StateId);
ds = di.GetDataPara("SP_State", Para);
return(ds);
}
public void RentTypeInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[4];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@RentTitle", objValue.RentTitle);
Para[2] = new SqlParameter("@Flag", objValue.Flag);
Para[3] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Rent_Type", Para);
}
public DataSet AgentLogin(prop objValue)
{
SqlParameter[] Para = new SqlParameter[3];
Para[0] = new SqlParameter("@Mode", "Login");
Para[1] = new SqlParameter("@Email", objValue.Email);
Para[2] = new SqlParameter("@Password", objValue.Password);
ds = di.GetDataPara("SP_Agent_Registration", Para);
return(ds);
}
public void StateUpdate(prop objValue)
{
SqlParameter[] Para = new SqlParameter[4];
Para[0] = new SqlParameter("@Mode", "update");
Para[1] = new SqlParameter("@StateName", objValue.StateName);
Para[2] = new SqlParameter("@StateId", objValue.StateId);
Para[3] = new SqlParameter("@UpdateDate", objValue.UpdateDate);
di.ExecQryPara("SP_State", Para);
}
public void ChangePassword(prop objValue)
{
SqlParameter[] Para = new SqlParameter[3];
Para[0] = new SqlParameter("@Mode", "ChangePassword");
Para[1] = new SqlParameter("@Password", objValue.NewPassword);
Para[2] = new SqlParameter("@Flag", objValue.Flag);
//Para[3] = new SqlParameter("@UpdateDate", objValue.UpdateDate);
di.ExecQryPara("SP_Admin_Login", Para);
}
public void CityDelete(prop objValue)
{
SqlParameter[] Para = new SqlParameter[4];
Para[0] = new SqlParameter("@Mode", "Delete");
Para[1] = new SqlParameter("@CityId", objValue.CityId);
Para[2] = new SqlParameter("@Flag", objValue.Flag);
Para[3] = new SqlParameter("@UpdateDate", objValue.UpdateDate);
di.ExecQryPara("SP_City", Para);
}
public void PropSpecificationInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[4];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@Specification", objValue.PropSpecification);
Para[2] = new SqlParameter("@Flag", objValue.Flag);
Para[3] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Prop_Specification", Para);
}
public void CountryUpdate(prop objValue)
{
SqlParameter[] Para = new SqlParameter[4];
Para[0] = new SqlParameter("@Mode", "update");
Para[1] = new SqlParameter("@CountryName", objValue.CountryName);
Para[2] = new SqlParameter("@CountryId", objValue.CountryId);
Para[3] = new SqlParameter("@UpdateDate", objValue.UpdateDate);
di.ExecQryPara("SP_Country", Para);
}
public String CountryInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[4];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@CountryName", objValue.CountryName);
Para[2] = new SqlParameter("@Flag", objValue.Flag);
Para[3] = new SqlParameter("@CreateDate", objValue.CreateDate);
Count = di.ExecQryPara("SP_Country", Para);
return(Count);
}
public void LoginInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[5];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@Email", objValue.Email);
Para[2] = new SqlParameter("@Password", objValue.Password);
Para[3] = new SqlParameter("@Flag", objValue.Flag);
Para[4] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Admin_Login", Para);
}
public void StateInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[5];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@CountryId", objValue.CountryId);
Para[2] = new SqlParameter("@StateName", objValue.StateName);
Para[3] = new SqlParameter("@Flag", objValue.Flag);
Para[4] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_State", Para);
}
public void SliderInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[6];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@Title", objValue.Title);
Para[2] = new SqlParameter("@SliderImage", objValue.SliderImage);
Para[3] = new SqlParameter("@Description", objValue.Description);
Para[4] = new SqlParameter("@Flag", objValue.Flag);
Para[5] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Slider", Para);
}
private static void ModalRodoviarioOs(Documento documento, rodoOS modalRodo)
{
if (documento.RodoviarioOS.Veiculo != null)
{
var veiculo = new veicOs();
modalRodo.veic = veiculo;
veiculo.placa = documento.RodoviarioOS.Veiculo.Placa;
veiculo.RENAVAM = documento.RodoviarioOS.Veiculo.Renavam;
if (documento.RodoviarioOS.Veiculo.Proprietario != null)
{
var docProprietario = documento.RodoviarioOS.Veiculo.Proprietario;
var proprietario = new prop();
modalRodo.veic.prop = proprietario;
if (docProprietario.DocumentoUnico.Length == 11)
{
proprietario.CPF = docProprietario.DocumentoUnico;
}
if (docProprietario.DocumentoUnico.Length == 14)
{
proprietario.CNPJ = docProprietario.DocumentoUnico;
}
proprietario.TAF = docProprietario.Taf;
proprietario.NroRegEstadual = docProprietario.NumeroRegistroEstadual;
proprietario.xNome = docProprietario.NomeOuRazaoSocial;
proprietario.IE = docProprietario.InscricaoEstadual;
proprietario.UF = proprietario.UF.SiglaParaEstado(docProprietario.EstadoUf.Sigla);
switch (docProprietario.TipoProprietario)
{
case TipoProprietario.TacAgregado:
proprietario.tpProp = tpPropProp.TACAgregado;
break;
case TipoProprietario.TacIndependente:
proprietario.tpProp = tpPropProp.TACIndependente;
break;
case TipoProprietario.Outros:
proprietario.tpProp = tpPropProp.Outros;
break;
default:
throw new ArgumentOutOfRangeException();
}
veiculo.UF = veiculo.UF.SiglaParaEstado(documento.RodoviarioOS.Veiculo.EstadoUf.Sigla);
}
}
}
public void AreaInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[6];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@AreaTitle", objValue.AreaTitle);
Para[2] = new SqlParameter("@CityId", objValue.CityId);
Para[3] = new SqlParameter("@PinCode", objValue.PinCode);
Para[4] = new SqlParameter("@Flag", objValue.Flag);
Para[5] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Area", Para);
}
public void PropDetailInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[6];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@Rate_sqft", objValue.rtsqft);
Para[2] = new SqlParameter("@Total_sqft", objValue.totsqft);
Para[3] = new SqlParameter("@Total_Rate", objValue.totrate);
Para[4] = new SqlParameter("@Flag", objValue.Flag);
Para[5] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Prop_Detail", Para);
}
public void agentregisterInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[7];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@Name", objValue.Name);
Para[2] = new SqlParameter("@Mobile_Number", objValue.MobileNumber);
Para[3] = new SqlParameter("@Email", objValue.EmailId);
Para[4] = new SqlParameter("@Password", objValue.Password);
Para[5] = new SqlParameter("@Flag", objValue.Flag);
Para[6] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Agent_Registration", Para);
}
public void TestimonialInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[7];
Para[0] = new SqlParameter("@mode", "insert");
Para[1] = new SqlParameter("@Name", objValue.Name);
Para[2] = new SqlParameter("@Image", objValue.Image);
Para[3] = new SqlParameter("@Comment", objValue.Comment);
Para[4] = new SqlParameter("@Flag", objValue.Flag);
Para[5] = new SqlParameter("@CreateDate", objValue.CreateDate);
Para[6] = new SqlParameter("@CreateUser", objValue.CreateUser);
di.ExecQryPara("SP_Testimonial", Para);
}
public void synch(prop p)
{
this.KeyBox.SelectedIndex = state.prop_images.IndexOf(p.image);
this.pictureBox1.Image = p.image;
this.listBox1.SelectedIndex = p.type;
this.selected = p;
this.specBox.Text = p.x.ToString() + ";" + p.y.ToString() + ";" + p.w.ToString() + ";" + p.h.ToString() + ";" + p.r.ToString();
//if (this.selected.type == 0) radioButton1.Checked = true;
//if (this.selected.type == 1) radioButton2.Checked = true;
//if (this.selected.type == 2) radioButton3.Checked = true;
}
public void ContactInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[9];
Para[0] = new SqlParameter("@mode", "insert");
Para[1] = new SqlParameter("@Name", objValue.Name);
Para[2] = new SqlParameter("@Phone_Number", objValue.PhoneNumber);
Para[3] = new SqlParameter("@Mobile_Number", objValue.MobileNumber);
Para[4] = new SqlParameter("@Fax", objValue.Fax);
Para[5] = new SqlParameter("@Email", objValue.Email);
Para[6] = new SqlParameter("@Flag", objValue.Flag);
Para[7] = new SqlParameter("@CreateDate", objValue.CreateDate);
Para[8] = new SqlParameter("@CreateUser", objValue.CreateUser);
di.ExecQryPara("SP_Contact", Para);
}
public void PropMasterInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[10];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@PropertyId", objValue.PropertyId);
Para[2] = new SqlParameter("@AddressLine1", objValue.AddressLine1);
Para[3] = new SqlParameter("@AddressLine2", objValue.AddressLine2);
Para[4] = new SqlParameter("@Area", objValue.Area);
Para[5] = new SqlParameter("@City", objValue.City);
Para[6] = new SqlParameter("@State", objValue.State);
Para[7] = new SqlParameter("@Country", objValue.Country);
Para[8] = new SqlParameter("@Flag", objValue.Flag);
Para[9] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Prop_Mst", Para);
}
public void PropertyDetailInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[11];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@Price", objValue.Price);
Para[2] = new SqlParameter("@PropertyName", objValue.PropertyName);
Para[3] = new SqlParameter("@Address", objValue.Address);
Para[4] = new SqlParameter("@Details", objValue.Details);
Para[5] = new SqlParameter("@PropertyArea", objValue.PropertyArea);
Para[6] = new SqlParameter("@Bedroom", objValue.Bedroom);
Para[7] = new SqlParameter("@Bathroom", objValue.Bathroom);
Para[8] = new SqlParameter("@Image", objValue.Image);
Para[9] = new SqlParameter("@Flag", objValue.Flag);
Para[10] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Add_Property", Para);
}
public void CompanyProfileInsert(prop objValue)
{
SqlParameter[] Para = new SqlParameter[15];
Para[0] = new SqlParameter("@Mode", "insert");
Para[1] = new SqlParameter("@CompanyName", objValue.CompanyName);
Para[2] = new SqlParameter("@CompanyLogo", objValue.CompanyLogo);
Para[3] = new SqlParameter("@AddressLine1", objValue.AddressLine1);
Para[4] = new SqlParameter("@AddressLine2", objValue.AddressLine2);
Para[5] = new SqlParameter("@City", objValue.City);
Para[6] = new SqlParameter("@State", objValue.State);
Para[7] = new SqlParameter("@Country", objValue.Country);
Para[8] = new SqlParameter("@EmailId", objValue.EmailId);
Para[9] = new SqlParameter("@MobileNumber", objValue.MobileNumber);
Para[10] = new SqlParameter("@PhoneNumber", objValue.PhoneNumber);
Para[11] = new SqlParameter("@Website", objValue.Website);
Para[12] = new SqlParameter("@MapLink", objValue.MapLink);
Para[13] = new SqlParameter("@Flag", objValue.Flag);
Para[14] = new SqlParameter("@CreateDate", objValue.CreateDate);
di.ExecQryPara("SP_Company_Profile", Para);
}
void Set(int realIndex, float r, float g, float b, int tileIndex)
{
prop realProp = props[realIndex];
if (props[realIndex].minimapObj != null)
{
if (!realProp.isRandomColor)
{
transform.parent.GetComponent <RoomProps>().setMinimap(props[realIndex].minimapObj, 1, 1, 1);
}
else
{
transform.parent.GetComponent <RoomProps>().setMinimap(props[realIndex].minimapObj, r, g, b);
}
}
if (tiles.Length != 0)
{
Instantiate(tiles[tileIndex], transform.position, quaternion.identity);
}
if (isRoof)
{
spr.sprite = realProp.roofSprite;
if (realProp.isRandomColor)
{
Color c = GetComponent <SpriteRenderer>().color;
c.r = r;
c.g = g;
c.b = b;
GetComponent <SpriteRenderer>().color = c;
}
}
transform.parent.GetComponent <TemSpawner>().Set(temIndexes, percentCounts, minCount, maxCount);
Destroy(transform.parent.GetComponent <PhotonView>());
}
WriteProperty(prop, output);
/// <summary>
/// Initializes a new instance of the <see cref="PropFilter"/> class.
/// </summary>
/// <param name="prop">The <see cref="prop"/> element containing the property names</param>
public PropFilter(prop prop)
{
_requestedProperties = new HashSet <XName>(prop.Any.Select(x => x.Name));
_selectedProperties = new HashSet <XName>();
}
/// <inheritdoc />
public async Task <IWebDavResult> LockAsync(string path, lockinfo info, CancellationToken cancellationToken)
{
if (_lockManager == null)
{
throw new NotSupportedException();
}
var owner = info.owner;
var recursive = (_context.RequestHeaders.Depth ?? DepthHeader.Infinity) == DepthHeader.Infinity;
var accessType = LockAccessType.Write;
var shareType = info.lockscope.ItemElementName == ItemChoiceType.exclusive
? LockShareMode.Exclusive
: LockShareMode.Shared;
var timeout = _timeoutPolicy?.SelectTimeout(
_context.RequestHeaders.Timeout?.Values ?? new[] { TimeoutHeader.Infinite })
?? TimeoutHeader.Infinite;
var href = GetHref(path);
var l = new Lock(
path,
href,
recursive,
owner,
accessType,
shareType,
timeout);
Debug.Assert(_lockManager != null, "_lockManager != null");
var lockResult = await _lockManager.LockAsync(l, cancellationToken);
if (lockResult.ConflictingLocks != null)
{
// Lock cannot be acquired
if (lockResult.ConflictingLocks.ChildLocks.Count == 0)
{
return(new WebDavResult <error>(WebDavStatusCode.Locked, CreateError(lockResult.ConflictingLocks.GetLocks())));
}
var errorResponses = new List <response>();
if (lockResult.ConflictingLocks.ChildLocks.Count != 0 ||
lockResult.ConflictingLocks.ReferenceLocks.Count != 0)
{
errorResponses.Add(CreateErrorResponse(
WebDavStatusCode.Forbidden,
lockResult.ConflictingLocks.ChildLocks.Concat(lockResult.ConflictingLocks.ReferenceLocks)));
}
if (lockResult.ConflictingLocks.ParentLocks.Count != 0)
{
var errorResponse = CreateErrorResponse(
WebDavStatusCode.Forbidden,
lockResult.ConflictingLocks.ChildLocks);
errorResponse.error = CreateError(new IActiveLock[0]);
errorResponses.Add(errorResponse);
}
errorResponses.Add(new response()
{
href = GetHref(l.Path),
ItemsElementName = new[] { ItemsChoiceType2.status, },
Items = new object[]
{
new Status(_context.RequestProtocol, WebDavStatusCode.FailedDependency).ToString(),
},
});
var multistatus = new multistatus()
{
response = errorResponses.ToArray(),
};
return(new WebDavResult <multistatus>(WebDavStatusCode.MultiStatus, multistatus));
}
var activeLock = lockResult.Lock;
Debug.Assert(activeLock != null, "activeLock != null");
try
{
var selectionResult = await _rootFileSystem.SelectAsync(path, cancellationToken);
WebDavStatusCode statusCode;
if (selectionResult.IsMissing)
{
if (_context.RequestHeaders.IfNoneMatch != null)
{
throw new WebDavException(WebDavStatusCode.PreconditionFailed);
}
if (selectionResult.MissingNames.Count > 1)
{
return(new WebDavResult(WebDavStatusCode.Conflict));
}
var current = selectionResult.Collection;
var docName = selectionResult.MissingNames.Single();
await current.CreateDocumentAsync(docName, cancellationToken);
statusCode = WebDavStatusCode.Created;
}
else
{
await _context
.RequestHeaders.ValidateAsync(selectionResult.TargetEntry, cancellationToken)
;
statusCode = WebDavStatusCode.OK;
}
var activeLockXml = activeLock.ToXElement();
var result = new prop()
{
Any = new[] { new XElement(WebDavXml.Dav + "lockdiscovery", activeLockXml) },
};
var webDavResult = new WebDavResult <prop>(statusCode, result);
webDavResult.Headers["Lock-Token"] = new[] { new LockTokenHeader(new Uri(activeLock.StateToken)).ToString() };
return(webDavResult);
}
catch
{
await _lockManager
.ReleaseAsync(activeLock.Path, new Uri(activeLock.StateToken, UriKind.RelativeOrAbsolute), cancellationToken)
;
throw;
}
}
internal static Texture getPropTexture(prop p)
{
return textures[(int)p];
}