private static GroupOption FillOption(SqlDataReader rs)
{
int optionid = Convert.ToInt32(rs["optionid"]);
string optionname = rs["optionname"] + "";
string ratetype = rs["ratetype"] + "";
decimal rate = 0;
bool isrequired = (bool)rs["isrequired"];
string optiontype = rs["optiontype"] + "";
string sOptionCode = rs["OptionCode"] + "";
decimal singleRate = Util.parseDec(rs["SingleRate"]);
decimal doubleRate = Util.parseDec(rs["DoubleRate"]);
decimal tripleRate = Util.parseDec(rs["TripleRate"]);
decimal quadRate = Util.parseDec(rs["QuadRate"]);
decimal singleComm = Util.parseDec(rs["SingleComm"]);
decimal doubleComm = Util.parseDec(rs["DoubleComm"]);
decimal tripleComm = Util.parseDec(rs["TripleComm"]);
decimal quadComm = Util.parseDec(rs["QuadComm"]);
int iQuantity = Convert.ToInt32(rs["Quantity"]);
int iAllocated = Convert.ToInt32(rs["Allocated"]);
GroupOption o = new GroupOption(optionid, optionname, ratetype, rate, isrequired, optiontype, sOptionCode,
singleRate, doubleRate, tripleRate, quadRate, singleComm, doubleComm, tripleComm, quadComm, iQuantity, iAllocated);
return(o);
}
public static decimal GetOptionCommission(GroupOption o, int paxCnt)
{
decimal amt = o.doublecommission;
if (paxCnt == 1)
{
amt = o.singlecommission;
}
else if (paxCnt == 3)
{
amt = o.triplecommission;
}
else if (paxCnt == 4)
{
amt = o.quadcommission;
}
return(amt);
}
public static decimal GetOptionRate(GroupOption o, int paxCnt)
{
decimal amt = o.doublerate;
if (paxCnt == 1)
{
amt = o.singlerate;
}
else if (paxCnt == 3)
{
amt = o.triplerate;
}
else if (paxCnt == 4)
{
amt = o.quadrate;
}
return(amt);
}
public static void Update(string groupID, GroupOption c)
{
string SQL_INSERT = @"INSERT INTO dbo.grp_Option(groupid, optionname, optiontype, isrequired,
SingleRate, DoubleRate, TripleRate, QuadRate,
SingleComm, DoubleComm, TripleComm, QuadComm, Quantity, Allocated)
VALUES(@GroupID, @optionname, @optiontype, @isrequired,
@SingleRate, @DoubleRate, @TripleRate, @QuadRate,
@SingleComm, @DoubleComm, @TripleComm, @QuadComm, @Quantity, @Allocated)";
string SQL_UPDATE = @"UPDATE dbo.grp_Option SET optionname=@optionname, optiontype=@optionType, isrequired=@isrequired ,
SingleRate=@SingleRate, DoubleRate=@DoubleRate, TripleRate=@TripleRate, QuadRate=@QuadRate,
SingleComm=@SingleComm, DoubleComm=@DoubleComm, TripleComm=@TripleComm, QuadComm=@QuadComm, Quantity=@Quantity, Allocated=@Allocated
WHERE optionid=@optionid AND groupid=@groupid";
/*
* string SQL_INSERT = @"INSERT INTO dbo.grp_Option(groupid, optionname, optioncode, optiontype, isrequired,
* SingleRate, DoubleRate, TripleRate, QuadRate,
* SingleComm, DoubleComm, TripleComm, QuadComm, Quantity, Allocated)
* VALUES(@GroupID, @optionname, @optioncode, @optiontype, @isrequired,
* @SingleRate, @DoubleRate, @TripleRate, @QuadRate,
* @SingleComm, @DoubleComm, @TripleComm, @QuadComm, @Quantity, @Allocated)";
* string SQL_UPDATE = @"UPDATE dbo.grp_Option SET optionname=@optionname, optioncode=@optioncode, optiontype=@optionType, isrequired=@isrequired ,
* SingleRate=@SingleRate, DoubleRate=@DoubleRate, TripleRate=@TripleRate, QuadRate=@QuadRate,
* SingleComm=@SingleComm, DoubleComm=@DoubleComm, TripleComm=@TripleComm, QuadComm=@QuadComm, Quantity=@Quantity, Allocated=@Allocated
* WHERE optionid=@optionid AND groupid=@groupid";
*/
string sql = "";
if (c.optionID == 0)
{
sql = SQL_INSERT;
}
else
{
sql = SQL_UPDATE;
}
using (SqlConnection cn = new SqlConnection(Config.ConnectionString))
{
cn.Open();
SqlTransaction trn = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand(sql, cn, trn);
cmd.Parameters.Add("@groupid", SqlDbType.VarChar).Value = groupID;
if (c.optionID != 0)
{
cmd.Parameters.Add("@optionid", SqlDbType.Int).Value = c.optionID;
}
cmd.Parameters.Add("@optionname", SqlDbType.VarChar, 100).Value = c.optionName;
cmd.Parameters.Add("@optionType", SqlDbType.VarChar, 100).Value = c.optionType;
cmd.Parameters.Add("@ratetype", SqlDbType.VarChar, 1).Value = c.rateType;
cmd.Parameters.Add("@rate", SqlDbType.Decimal).Value = c.rate;
cmd.Parameters.Add("@isrequired", SqlDbType.Bit).Value = c.isRequired;
//cmd.Parameters.Add("@optioncode", SqlDbType.VarChar).Value = c.optionCode;
cmd.Parameters.Add("@SingleRate", SqlDbType.Decimal).Value = c.singlerate;
cmd.Parameters.Add("@DoubleRate", SqlDbType.Decimal).Value = c.doublerate;
cmd.Parameters.Add("@TripleRate", SqlDbType.Decimal).Value = c.triplerate;
cmd.Parameters.Add("@QuadRate", SqlDbType.Decimal).Value = c.quadrate;
cmd.Parameters.Add("@SingleComm", SqlDbType.Decimal).Value = c.singlecommission;
cmd.Parameters.Add("@DoubleComm", SqlDbType.Decimal).Value = c.doublecommission;
cmd.Parameters.Add("@TripleComm", SqlDbType.Decimal).Value = c.triplecommission;
cmd.Parameters.Add("@QuadComm", SqlDbType.Decimal).Value = c.quadcommission;
cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = c.quantity;
cmd.Parameters.Add("@Allocated", SqlDbType.Int).Value = c.allocated;
cmd.ExecuteNonQuery();
trn.Commit();
}
catch (SqlException ex)
{
string msg = ex.Message;
try { trn.Rollback(); }
catch { }
throw new Exception(msg);
}
}
}
