public void INSERT()
{
int A = GETROOMNO();
if (A == 0)
{
string s = "INSERT INTO ROOMMASTER (ROOM_NO,ROOM_CATEGORY,ROOM_VIEW,MAX_PAX,ACTIVE_DATE,CURRENCY,SINGLERATE_TARRIF,DOUBLERATE_TARRIF,TRIPLERATE_TARRIF,QUADRATE_TARRIF,COMMON_PRICE,EXTRABED_ADULT,EXTRABED_CHILD,STATUS,BACKGROUND_COLOR,INSERT_BY,INSERT_DATE)" + "" +
"VALUES(@ROOM_NO,@ROOM_CATEGORY,@ROOM_VIEW,@MAX_PAX,@ACTIVE_DATE,@CURRENCY,@SINGLERATE_TARRIF,@DOUBLERATE_TARRIF,@TRIPLERATE_TARRIF,@QUADRATE_TARRIF,@COMMON_PRICE,@EXTRABED_ADULT,@EXTRABED_CHILD,@STATUS,@BACKGROUND_COLOR,@INSERT_BY,@INSERT_DATE)";
var listParams = new List <SqlParameter>();
listParams.AddSqlParameter("@ROOM_NO", ROOM_NO);
listParams.AddSqlParameter("@ROOM_CATEGORY", ROOM_CATEGORY);
listParams.AddSqlParameter("@ROOM_VIEW", ROOM_VIEW);
listParams.AddSqlParameter("@MAX_PAX", MAX_PAX);
listParams.AddSqlParameter("@ACTIVE_DATE", ACTIVE_CALENDER);
listParams.AddSqlParameter("@CURRENCY", CURRENCY);
listParams.AddSqlParameter("@SINGLERATE_TARRIF", SINGLERATE_TARRIF);
listParams.AddSqlParameter("@DOUBLERATE_TARRIF", DOUBLERATE_TARRIF);
listParams.AddSqlParameter("@TRIPLERATE_TARRIF", TRIPLERATE_TARRIF);
listParams.AddSqlParameter("@QUADRATE_TARRIF", QUADRATE_TARRIF);
listParams.AddSqlParameter("@COMMON_PRICE", COMMON_PRICE);
listParams.AddSqlParameter("@EXTRABED_ADULT", ADULT_EXTRABADCOST);
listParams.AddSqlParameter("@EXTRABED_CHILD", CHILD_EXTRABEDCOST);
listParams.AddSqlParameter("@STATUS", STATUS);
listParams.AddSqlParameter("@BACKGROUND_COLOR", "Green");
INSERT_BY = login.u;
INSERT_DATE = DateTime.Today;
listParams.AddSqlParameter("@INSERT_BY", INSERT_BY);
listParams.AddSqlParameter("@INSERT_DATE", INSERT_DATE);
DbFunctions.ExecuteCommand <int>(s, listParams);
INSERT_INTO_PLANCODE();
if (AMENITY_NAMES == null)
{
}
else
{
string res = AMENITY_NAMES.ToString();
string[] values = res.Split(' ');
for (int i = 1; i < values.Length; i++)
{
values[i] = values[i].Trim();
String I = "INSERT INTO ROOMMASTER_AMENITY(ROOM_NO,AMENITY,ENABLE,INSERT_BY,INSERT_DATE)VALUES(@ROOM_NO,@AMENITY,@ENABLE,@INSERT_BY,@INSERT_DATE)";
var l = new List <SqlParameter>();
l.AddSqlParameter("@ROOM_NO", ROOM_NO);
l.AddSqlParameter("@AMENITY", values[i]);
l.AddSqlParameter("@INSERT_BY", login.u);
l.AddSqlParameter("@INSERT_DATE", DateTime.Today);
l.AddSqlParameter("@ENABLE", "yes");
DbFunctions.ExecuteCommand <int>(I, l);
}
}
//if (A != 0)
//{
// int B = GETPLANCODE_ROOMNO_MATCH();
// if (B == 0)
// {
// INSERT_INTO_PLANCODE();
// }
//}
}
if (A != 0)
{
int B = GETPLANCODE_ROOMNO_MATCH();
if (B == 0)
{
INSERT_INTO_PLANCODE();
}
}
}
public void UPDATE()
{
int a = GETROOMNO();
if (a == 1)
{
String S = "UPDATE ROOMMASTER SET ROOM_CATEGORY=@ROOM_CATEGORY,ROOM_VIEW=@ROOM_VIEW,MAX_PAX=@MAX_PAX,ACTIVE_DATE=@ACTIVE_DATE,CURRENCY=@CURRENCY,SINGLERATE_TARRIF=@SINGLERATE_TARRIF,DOUBLERATE_TARRIF=@DOUBLERATE_TARRIF,TRIPLERATE_TARRIF=@TRIPLERATE_TARRIF,QUADRATE_TARRIF=@QUADRATE_TARRIF,COMMON_PRICE=@COMMON_PRICE,EXTRABED_ADULT=@EXTRABED_ADULT,EXTRABED_CHILD=@EXTRABED_CHILD,STATUS=@STATUS WHERE ROOM_NO=@ROOM_NO";
var listParams = new List <SqlParameter>();
listParams.AddSqlParameter("@ROOM_NO", ROOM_NO);
listParams.AddSqlParameter("@ROOM_CATEGORY", ROOM_CATEGORY);
listParams.AddSqlParameter("@ROOM_VIEW", ROOM_VIEW);
listParams.AddSqlParameter("@MAX_PAX", MAX_PAX);
listParams.AddSqlParameter("@ACTIVE_DATE", ACTIVE_CALENDER);
listParams.AddSqlParameter("@CURRENCY", CURRENCY);
listParams.AddSqlParameter("@SINGLERATE_TARRIF", SINGLERATE_TARRIF);
listParams.AddSqlParameter("@DOUBLERATE_TARRIF", DOUBLERATE_TARRIF);
listParams.AddSqlParameter("@TRIPLERATE_TARRIF", TRIPLERATE_TARRIF);
listParams.AddSqlParameter("@QUADRATE_TARRIF", QUADRATE_TARRIF);
listParams.AddSqlParameter("@COMMON_PRICE", COMMON_PRICE);
listParams.AddSqlParameter("@EXTRABED_ADULT", ADULT_EXTRABADCOST);
listParams.AddSqlParameter("@EXTRABED_CHILD", CHILD_EXTRABEDCOST);
listParams.AddSqlParameter("@STATUS", STATUS);
//listParams.AddSqlParameter("@USER_NAME", USER_NAME);
listParams.AddSqlParameter("@UPDATE_BY", login.u);
listParams.AddSqlParameter("@UPDATE_DATE", DateTime.Today);
DbFunctions.ExecuteCommand <int>(S, listParams);
UPDATE_PLANCODE();
UPDATE_AMENITY_ENABLE(ROOM_NO);
if (AMENITY_NAMES == null)
{
}
else
{
string res = AMENITY_NAMES.ToString();
string[] values = res.Split(' ');
for (int i = 1; i < values.Length; i++)
{
values[i] = values[i].Trim();
int A = GET_AMENITY_STATUS(values[i]);
if (A == 1)
{
string I = "UPDATE ROOMMASTER_AMENITY SET ENABLE=@ENABLE,UPDATE_BY=@UPDATE_BY,UPDATE_DATE=@UPDATE_DATE WHERE ROOM_NO=@ROOM_NO AND AMENITY=@AMENITY";
var l = new List <SqlParameter>();
l.AddSqlParameter("@ROOM_NO", ROOM_NO);
l.AddSqlParameter("@AMENITY", values[i]);
l.AddSqlParameter("@UPDATE_BY", login.u);
l.AddSqlParameter("@ENABLE", "yes");
l.AddSqlParameter("@UPDATE_DATE", DateTime.Today);
DbFunctions.ExecuteCommand <int>(I, l);
}
else
{
String I = "INSERT INTO ROOMMASTER_AMENITY(ROOM_NO,AMENITY,ENABLE,INSERT_BY,INSERT_DATE)VALUES(@ROOM_NO,@AMENITY,@ENABLE,@INSERT_BY,@INSERT_DATE)";
var l = new List <SqlParameter>();
l.AddSqlParameter("@ROOM_NO", ROOM_NO);
l.AddSqlParameter("@AMENITY", values[i]);
l.AddSqlParameter("@INSERT_BY", login.u);
l.AddSqlParameter("@INSERT_DATE", DateTime.Today);
l.AddSqlParameter("@ENABLE", "yes");
DbFunctions.ExecuteCommand <int>(I, l);
}
}
}
if (a != 0)
{
int B = GETPLANCODE_ROOMNO_MATCH();
if (B == 1)
{
UPDATE_PLANCODE();
}
else
{
INSERT_BY = login.u;
INSERT_DATE = DateTime.Today.Date;
INSERT_INTO_PLANCODE();
}
}
}
}
