public bool HasConflictUserPrivateNumberDateTime(Common.UserPrivateNumber userPrivateNumber)
{
DataTable dataTableNumber = base.FetchSPDataTable("CheckDateTimeForPrivateNumber", "@RootGuid", userPrivateNumber.UserPrivateNumberGuid,
"@StartDate", userPrivateNumber.StartDate,
"@EndDate", userPrivateNumber.EndDate);
return(dataTableNumber.Rows.Count > 0);
}
public bool UpdateUserNumberUseType(Common.UserPrivateNumber userPrivateNumber)
{
bool isUpdateCompleted = false;
isUpdateCompleted = base.ExecuteSPCommand("UpdateUserNumberUseType", "@Guid", userPrivateNumber.UserPrivateNumberGuid,
"@UseType", userPrivateNumber.UseType);
if (isUpdateCompleted)
{
OnUserPrivateNumberChange(userPrivateNumber, null);
}
return(isUpdateCompleted);
}
public bool UpdateUserPrivateNumber(Common.UserPrivateNumber userPrivateNumber)
{
bool isUpdateCompleted = false;
isUpdateCompleted = base.ExecuteSPCommand("UpdateUserPrivateNumber", "@Guid", userPrivateNumber.UserPrivateNumberGuid,
"@StartDate", userPrivateNumber.StartDate,
"@EndDate", userPrivateNumber.EndDate,
"@IsActive", userPrivateNumber.IsActive,
"@UseForChildren", userPrivateNumber.UseForChildren,
"@DecreaseFromPanel", userPrivateNumber.DecreaseFromPanel,
"@UseType", userPrivateNumber.UseType,
"@Price", userPrivateNumber.Price,
"@ActivationUserGuid", userPrivateNumber.ActivationUserGuid
);
if (isUpdateCompleted)
{
OnUserPrivateNumberChange(userPrivateNumber, null);
}
return(isUpdateCompleted);
}
public DataTable GetPagedUserPrivateNumber(Common.UserPrivateNumber userPrivateNumber,
Guid smsSenderAgentGuid,
string number,
int activeStatus,
int expired,
int useForChildren,
int useType,
int priceRange,
DateTime fromStartDate,
DateTime toStartDate,
DateTime fromEndDate,
DateTime toEndDate,
string sortField,
int pageNo,
int pageSize,
ref int resultCount)
{
DataSet userNumbersInfo = base.FetchSPDataSet("GetPagedUserPrivateNumber", "@UserGuid", userPrivateNumber.UserGuid,
"@SmsSenderAgentGuid", smsSenderAgentGuid,
"@Number", number,
"@Type", userPrivateNumber.Type,
"@IsActive", (activeStatus == 2 ? DBNull.Value : (object)activeStatus),
"@UseType", (useType == -1 ? DBNull.Value : (object)useType),
"@Expired", (expired == 2 ? DBNull.Value : (object)expired),
"@UseForChildren", (useForChildren == 2 ? DBNull.Value : (object)useForChildren),
"@FromStartDate", fromStartDate,
"@ToStartDate", toStartDate,
"@FromEndDate", fromEndDate,
"@ToEndDate", toEndDate,
"@Price", userPrivateNumber.Price,
"@PriceRange", (priceRange == 2 ? DBNull.Value : (object)priceRange),
"@PageNo", pageNo,
"@PageSize", pageSize,
"@SortField", sortField);
resultCount = Helper.GetInt(userNumbersInfo.Tables[0].Rows[0]["RowCount"]);
return(userNumbersInfo.Tables[1]);
}
