internal IEnumerable <OwnerDetail> GetAllOwnerDetails()
{
List <OwnerDetail> ownerDetails = new List <OwnerDetail>();
Dictionary <string, SqlParameter> queryParameters = new Dictionary <string, SqlParameter>();
DataSet dataSet = dbutility.ExecuteQuery("QuotationDb", "dbo.GetAllOwnerDetails", queryParameters);
if (dataSet != null)
{
var dataTable = dataSet.Tables[0];
ownerDetails = dataTable.AsEnumerable().Select(row =>
new OwnerDetail
{
Name = row.Field <string>("Name"),
NRIC = row.Field <string>("NRIC"),
DateOfBirth = row.Field <DateTime?>("DateOfBirth"),
Gender = row.Field <string>("Gender"),
MaritalStatus = row.Field <string>("MaritalStatus"),
Occupation = row.Field <string>("Occupation"),
LicenseDate = row.Field <DateTime?>("LicenseDate"),
CreatedBy = row.Field <string>("CreatedBy"),
CreatedDate = row.Field <DateTime?>("CreatedDate"),
LastUpdatedBy = row.Field <string>("LastUpdatedBy"),
LastUpdatedDate = row.Field <DateTime?>("LastUpdatedDate"),
Email = row.Field <string>("Email"),
Address = row.Field <string>("Address"),
RenewalRemindDays = row.Field <short?>("RenewalRemindDays"),
}).ToList();
}
return(ownerDetails);
}
//internal ErrorDetail UpdateGroupFormRights(IEnumerable<GroupFormRight> groupFormRights)
//{
// DataTable dataTable = new DataTable();
// //dataTable.Columns.Add("GroupID", typeof(int));
// dataTable.Columns.Add("FormID", typeof(int));
// dataTable.Columns.Add("Options", typeof(string));
// foreach (var groupFormRight in groupFormRights)
// {
// dataTable.Rows.Add(groupFormRight.GroupID, groupFormRight.FormID, groupFormRight.Options);
// }
// Dictionary<string, SqlParameter> cmdParameters = new Dictionary<string, SqlParameter>();
// cmdParameters["GroupFormRightsDT"] = new SqlParameter("GroupFormRightsDT", dataTable);
// SqlParameter outPutParameter1 = new SqlParameter();
// outPutParameter1.ParameterName = "@ERRORNO";
// outPutParameter1.SqlDbType = System.Data.SqlDbType.Int;
// outPutParameter1.Size = 255;
// outPutParameter1.Direction = System.Data.ParameterDirection.Output;
// cmdParameters["@ERRORNO"] = outPutParameter1;
// SqlParameter outPutParameter2 = new SqlParameter();
// outPutParameter2.ParameterName = "@ERRORDESC";
// outPutParameter2.SqlDbType = System.Data.SqlDbType.VarChar;
// outPutParameter2.Size = 255;
// outPutParameter2.Direction = System.Data.ParameterDirection.Output;
// cmdParameters["@ERRORDESC"] = outPutParameter2;
// ErrorDetail errorDetail = new ErrorDetail();
// dbutility.ExecuteNonQuery("QuotationDb", "dbo.UpdateGroupFormRights", cmdParameters);
// errorDetail.Code = int.Parse(outPutParameter1.Value.ToString());
// errorDetail.Info = outPutParameter2.Value.ToString();
// return errorDetail;
//}
internal DataSet GetGroupDetails(string groupId)
{
Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>();
cmdParameters["GroupID"] = new SqlParameter("GroupID", groupId);
SqlParameter outPutParameter1 = new SqlParameter();
outPutParameter1.ParameterName = "@ERRORNO";
outPutParameter1.SqlDbType = System.Data.SqlDbType.Int;
outPutParameter1.Size = 255;
outPutParameter1.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@ERRORNO"] = outPutParameter1;
SqlParameter outPutParameter2 = new SqlParameter();
outPutParameter2.ParameterName = "@ERRORDESC";
outPutParameter2.SqlDbType = System.Data.SqlDbType.VarChar;
outPutParameter2.Size = 255;
outPutParameter2.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@ERRORDESC"] = outPutParameter2;
DataSet dataSet = dbutility.ExecuteQuery("QuotationDb", "dbo.GetGroupDetails", cmdParameters);
return(dataSet);
}
internal Dictionary <string, string> GetLicenseDetails()
{
Dictionary <string, string> result = null;
Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>();
DataSet dataSet = dbutility.ExecuteQuery("QuotationDb", "dbo.GetLicenseDetails", cmdParameters);
if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
result = CryptographyUtility.DecryptLicense(dataSet.Tables[0]);
}
return(result);
}
public void ExecuteQuery()
{
// add a customer
Dictionary<string, SqlParameter> cmdParameters = new Dictionary<string, SqlParameter>();
cmdParameters["name"] = new SqlParameter("name", "Smith");
cmdParameters["state"] = new SqlParameter("state", "MD");
SqlDatabaseUtility.ExecuteCommand("mssqltips", "dbo.AddCustomer", cmdParameters);
// query the customer table
Dictionary<string, SqlParameter> queryParameters = new Dictionary<string, SqlParameter>();
SqlDataReader reader = SqlDatabaseUtility.ExecuteQuery(
"mssqltips", "dbo.GetCustomerList", queryParameters);
while (reader.Read() == true)
{
Console.WriteLine(string.Format("{0}\t{1}\t{2}",
reader[0].ToString(),
reader[1].ToString(),
reader[2].ToString()));
}
}