public override Image UserPictureImage(MembershipUser user)
{
using (SqlText sql = new SqlText("SELECT gpu.Picture FROM Grid_Persona_Usuario_V gpu WHERE gpu.UserName = @UserName"))
{
sql.AssignParameter("@UserName", user.UserName);
if (sql.Read())
{
byte[] value = (byte[])sql["Picture"];
if (value != null)
{
return(Image.FromStream(new MemoryStream(value)));
}
}
}
return(base.UserPictureImage(user));
}
public void r101Implementation(MemberSendSMSModel instance)
{
// This is the placeholder for method implementation.
string Parameters_SMSBODY = "Send test sms";
using (SqlText memInfo = new SqlText(@"Select PredefineSMS From [dbo].[SMSConfig]"))
{
try
{
#region [Read Data]
if (memInfo.Read())
{
if (memInfo["PredefineSMS"] != DBNull.Value)
{
Parameters_SMSBODY = Convert.ToString(memInfo["PredefineSMS"].ToString());
}
}
#endregion
}
catch
{
}
}
clsGeneralLib oclsGeneralLib = new clsGeneralLib();
// This is the placeholder for method implementation.
//int count = instance.MemberID.Value;
int memid = Convert.ToInt32(instance.MemberID);
clsGeneralLib.Member omem = new clsGeneralLib.Member();
omem = oclsGeneralLib.getMemberByID(memid);
oclsGeneralLib.SendSMSTo(omem.MobileNo, omem.MemberName, Parameters_SMSBODY);
Result.ShowAlert("Successfully send sms to Member");
this.PreventDefault();
}
public void r101Implementation(TournamentRegisterMemberModel instance)
{
// This is the placeholder for method implementation.
int pMemberGroupID = 0, pMemberID = 0;
decimal pMemberFee = 0m, @SpouseFee = 0m, @ChildrenFee = 0m;
int pCaddieID = 0, pBallBoyIDID = 0, pHoleTypeID = 0, pHandiCap = 0;
int pMemberCategoryID = 0, pMemberStatusID = 0;
string pMemberOfType = "";
decimal pCaddieFee = 0m, pChildrenBallBoySubsidy = 0m, pSpouseBallBoySubsidy = 0m;
decimal pBallBoySubsiDy = 0m, pBallBoyFee = 0m, pCildrenCaddieSubsidy = 0m, pSpouseCaddieSubsidy = 0m;
decimal pCaddieSubsidy = 0m, pGreenFee = 0m, pGolfCartFee = 0m;
if (instance.MemberID != null)
{
pMemberID = Convert.ToInt32(instance.MemberID);
}
if (instance.CaddieID != null)
{
pCaddieID = Convert.ToInt32(instance.CaddieID);
}
if (instance.BallBoyID != null)
{
pBallBoyIDID = Convert.ToInt32(instance.BallBoyID);
}
if (instance.HoleTypeID != null)
{
pHoleTypeID = Convert.ToInt32(instance.HoleTypeID);
}
instance.BallBoySubsidy = 0;
instance.BallBoyFee = 0;
instance.CaddieFee = 0;
instance.CaddieSubsidy = 0;
instance.GameFeeAmount = 0;
instance.GolfCartFee = 0;
instance.GreenFee = 0;
instance.GameFeeAmount = 0;
instance.RegDate = DateTime.Now;
string strSelect = "";
if (!String.IsNullOrEmpty(instance.MemberID.ToString()))
{
object total = null;
using (SqlText memInfo = new SqlText(@"select MemberID,MemberCategoryID,MemberStatusID,MemberOfType,HandiCap from MemberInfo where MemberID= @MemberID"))
{
#region [Read Data]
memInfo.AddParameter("@MemberID", instance.MemberID);
if (memInfo.Read())
{
if (memInfo["MemberCategoryID"] != DBNull.Value)
{
pMemberCategoryID = Convert.ToInt32(memInfo["MemberCategoryID"].ToString());
}
if (memInfo["MemberStatusID"] != DBNull.Value)
{
pMemberStatusID = Convert.ToInt32(memInfo["MemberStatusID"].ToString());
}
if (memInfo["MemberOfType"] != DBNull.Value)
{
pMemberOfType = Convert.ToString(memInfo["MemberOfType"].ToString());
}
if (memInfo["HandiCap"] != DBNull.Value)
{
pHandiCap = Convert.ToInt32(memInfo["HandiCap"].ToString());
}
}
#endregion
///UpdateFieldValue("ShipName", findCustomer["ContactName"]);
///
#region [Game Fees]
//object total = null;
using (SqlText Fees = new SqlText(@"select " +
" GreenFee,CaddieFee,CaddieSubsidy,SpouseCaddieSubsidy,CildrenCaddieSubsidy, " +
" BallBoyFee,BallBoySubsiDy,SpouseBallBoySubsidy,ChildrenBallBoySubsidy, " +
" GolfCartFee from dbo.GameFee " +
" where " +
" MemberCategoryID = @MemberCategoryID " +
" And MemberStatusID = @MemberStatusID " +
" And HoleTypeID = @HoleTypeID "
))
{
#region [Read Data]
Fees.AddParameter("@MemberCategoryID", pMemberCategoryID);
Fees.AddParameter("@MemberStatusID", pMemberStatusID);
Fees.AddParameter("@HoleTypeID", pHoleTypeID);
if (Fees.Read())
{
if (Fees["GolfCartFee"] != DBNull.Value)
{
pGolfCartFee = Convert.ToDecimal(Fees["GolfCartFee"].ToString());
}
if (Fees["ChildrenBallBoySubsidy"] != DBNull.Value)
{
pChildrenBallBoySubsidy = Convert.ToDecimal(Fees["ChildrenBallBoySubsidy"].ToString());
}
if (Fees["SpouseBallBoySubsidy"] != DBNull.Value)
{
pSpouseBallBoySubsidy = Convert.ToDecimal(Fees["SpouseBallBoySubsidy"].ToString());
}
if (Fees["BallBoySubsiDy"] != DBNull.Value)
{
pBallBoySubsiDy = Convert.ToDecimal(Fees["BallBoySubsiDy"].ToString());
}
if (Fees["BallBoyFee"] != DBNull.Value)
{
pBallBoyFee = Convert.ToDecimal(Fees["BallBoyFee"].ToString());
instance.BallBoyFee = pBallBoyFee;
}
if (Fees["GreenFee"] != DBNull.Value)
{
pGreenFee = Convert.ToDecimal(Fees["GreenFee"].ToString());
instance.GreenFee = pGreenFee;
}
if (Fees["CaddieFee"] != DBNull.Value)
{
pCaddieFee = Convert.ToDecimal(Fees["CaddieFee"].ToString());
instance.CaddieFee = pCaddieFee;
}
if (Fees["CaddieSubsidy"] != DBNull.Value)
{
pCaddieSubsidy = Convert.ToDecimal(Fees["CaddieSubsidy"].ToString());
instance.CaddieSubsidy = pCaddieSubsidy;
}
if (Fees["SpouseCaddieSubsidy"] != DBNull.Value)
{
pSpouseCaddieSubsidy = Convert.ToDecimal(Fees["SpouseCaddieSubsidy"].ToString());
}
if (Fees["CildrenCaddieSubsidy"] != DBNull.Value)
{
pCildrenCaddieSubsidy = Convert.ToDecimal(Fees["CildrenCaddieSubsidy"].ToString());
}
#region [BallBoy Fee]
if (pBallBoyIDID > 0)
{
instance.BallBoyFee = pBallBoyFee;
if (pMemberOfType == "Full Member")
{
instance.BallBoySubsidy = pBallBoySubsiDy;
}
if (pMemberOfType == "Spouse Of Member")
{
instance.BallBoySubsidy = pSpouseBallBoySubsidy;
}
if (pMemberOfType == "Children Of Member")
{
instance.BallBoySubsidy = pChildrenBallBoySubsidy;
}
}
#endregion
#region [Caddie Fee]
if (pCaddieID > 0)
{
instance.CaddieFee = pCaddieFee;
if (pMemberOfType == "Full Member")
{
instance.CaddieSubsidy = pCaddieSubsidy;
}
if (pMemberOfType == "Spouse Of Member")
{
instance.CaddieSubsidy = pSpouseCaddieSubsidy;
}
if (pMemberOfType == "Children Of Member")
{
instance.CaddieSubsidy = pCildrenCaddieSubsidy;
}
}
if (pMemberOfType == "Full Member")
{
instance.TotalAmount = (pCaddieFee + pGreenFee + pBallBoyFee + pGolfCartFee) - (pCaddieSubsidy + pBallBoySubsiDy);
}
if (pMemberOfType == "Spouse Of Member")
{
instance.TotalAmount = (pCaddieFee + pGreenFee + pBallBoyFee + pGolfCartFee) - (pSpouseCaddieSubsidy + pSpouseBallBoySubsidy);
}
if (pMemberOfType == "Children Of Member")
{
instance.TotalAmount = (pCaddieFee + pGreenFee + pBallBoyFee + pGolfCartFee) - (pCildrenCaddieSubsidy + pChildrenBallBoySubsidy);
}
#endregion
}
#endregion
///UpdateFieldValue("ShipName", findCustomer["ContactName"]);
}
#endregion
}
}
}
public void r101Implementation(MemberCardTransactionDepositModel instance)
{
// This is the placeholder for method implementation.
string pMessage = string.Empty;
int pMemberCardID = Convert.ToInt32(instance.MemberCardID.ToString());
int MemberID = Convert.ToInt32(instance.MemberID.ToString());
int pMemberCardTranID = Convert.ToInt32(instance.MemberCardTranID.ToString());
decimal dDepositedAmount = 0;
dDepositedAmount = Convert.ToInt32(instance.DepositAmount.ToString());
string memMobileNo = "";
string MemberName = "";
string strSelect = "";
if (!String.IsNullOrEmpty(instance.MemberID.ToString()))
{
object total = null;
using (SqlText memInfo = new SqlText(@"select MemberID,NameOfMember from MemberInfo where MemberID= @MemberID"))
{
try
{
#region [Read Data]
memInfo.AddParameter("@MemberID", instance.MemberID);
if (memInfo.Read())
{
if (memInfo["NameOfMember"] != DBNull.Value)
{
MemberName = Convert.ToString(memInfo["NameOfMember"].ToString());
}
}
#endregion
}
catch (Exception ex)
{
}
}
using (SqlText memInfo = new SqlText(@"select MemberID,MobileNo from Membercard where MemberID= @MemberID and MemberCardID=@MemberCardID"))
{
try
{
#region [Read Data]
memInfo.AddParameter("@MemberID", MemberID);
memInfo.AddParameter("@MemberCardID", pMemberCardID);
if (memInfo.Read())
{
if (memInfo["MobileNo"] != DBNull.Value)
{
memMobileNo = Convert.ToString(memInfo["MobileNo"].ToString());
}
}
#endregion
}
catch (Exception ex)
{
}
}
}
string[] strmobile;
if (memMobileNo.Length <= 11)
{
}
strmobile = FormatMobileNo(memMobileNo);
if (strmobile[0] == "0")
{
memMobileNo = strmobile[1].ToString();
pMessage = "Please dodnot disclose these pin number.";
//int iRet = SendSMSTo(MemberCardID, memMobileNo, MemberName, pMessage);
}
pMessage = " Received with Thanks. " + dDepositedAmount.ToString() + " Taka";
SendSMSTo(pMemberCardTranID, memMobileNo, MemberName, pMessage, pMemberCardID, dDepositedAmount);
}