public void Save(CLayer.BankingCode data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPayType", DataPlug.DataType._Int, data.PayType)); param.Add(Connection.GetParameter("pPaymentGatewayId", DataPlug.DataType._Char, data.PaymentGatewayId)); param.Add(Connection.GetParameter("pBankingTitle", DataPlug.DataType._Varchar, data.BankingTitle)); param.Add(Connection.GetParameter("pCode", DataPlug.DataType._Varchar, data.Code)); Connection.ExecuteQuery("bankingcode_Save", param); }
public CLayer.BankingCode GetBankingCode(string code) { CLayer.BankingCode result = null; string sql = "Select * From Bankingcodes Where code='" + code + "'"; DataTable dt = Connection.GetSQLTable(sql); if (dt.Rows.Count > 0) { result = new CLayer.BankingCode(); result.BankingTitle = Connection.ToString(dt.Rows[0]["BankingTitle"]); result.PaymentGatewayId = Connection.ToString(dt.Rows[0]["PaymentGatewayId"]); result.PayType = (CLayer.ObjectStatus.PaymentMethod)Connection.ToInteger(dt.Rows[0]["PayType"]); result.Code = code; } return(result); }