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(); } } } }