public void InsertData(string currUser, InsuranceCompanyModel oClass)
{
strSql = strSql + "INSERT INTO " + TABLE_NAME + " (" +
COLUMN_CODE + ", " +
COLUMN_COMPANY_NAME + ", " +
COLUMN_CONTACT_PERSON + ", " +
COLUMN_ADDRESS + ", " +
COLUMN_EMAIL + ", " +
COLUMN_PHONE + ", " +
COLUMN_COUNTRY_CODE + ", " +
COLUMN_DATE_ACCREDIT + ", " +
COLUMN_DATE_EXPIRE + ", " +
"created_by, created_date, updated_by, updated_date) ";
strSql = strSql + "values ('" +
oClass.Code + "', '" +
oClass.CompanyName.Replace("'", "") + "', '" +
oClass.ContactPerson.Replace("'", "") + "', '" +
oClass.Address.Replace("'", "") + "', '" +
oClass.Phone + "', '" +
oClass.Email.Replace("'", "") + "', '" +
oClass.CountryCode.Replace("'", "") + "', '" +
oClass.DateAccredit.ToString("yyyy-MM-d HH:MM:ss") + "', '" +
oClass.DateExpire.ToString("yyyy-MM-d HH:MM:ss") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
") ";
SaveData(strSql);
}
private void SaveData()
{
string sUserName = Session["User"].ToString();
oDAL = new InsuranceCompanyDAL();
oClass = new InsuranceCompanyModel();
oClass.Code = Code.Value;
oClass.CompanyName = CompanyName.Value;
oClass.ContactPerson = ContactPerson.Value;
oClass.CountryCode = ddlCountryCode.SelectedValue;
oClass.Address = txtAddress.InnerText;
oClass.Phone = txtContact.Value;
oClass.Email = txtEmail.Value;
string id = ClientID.Value;
if (id == "")
{
oDAL.InsertData(sUserName, oClass);
//lblMsg.Text = "New Record has been saved";
}
else
{
oClass.ID = Convert.ToInt16(id);
oDAL.UpdateData(sUserName, oClass);
// lblMsg.Text = "Record has been updated";
}
}
//获取投保保险公司
public APIResponse GetInsuranceCompany(int userId)
{
var carInsuranceCompanys = (from u in CurrentDb.CarInsuranceCompany
join r in CurrentDb.InsuranceCompany on u.InsuranceCompanyId equals r.Id
where u.Status == Enumeration.CarInsuranceCompanyStatus.Normal
select new { r.Id, r.Name, u.InsuranceCompanyImgUrl, u.Priority }).Distinct().OrderByDescending(m => m.Priority);
InsuranceCompanyResult model = new InsuranceCompanyResult();
model.CanInsureCount = 2;
List <InsuranceCompanyModel> insuranceCompanyModels = new List <InsuranceCompanyModel>();
foreach (var m in carInsuranceCompanys)
{
InsuranceCompanyModel insuranceCompanyModel = new InsuranceCompanyModel();
insuranceCompanyModel.Id = m.Id;
insuranceCompanyModel.Name = m.Name;
insuranceCompanyModel.ImgUrl = m.InsuranceCompanyImgUrl;
insuranceCompanyModels.Add(insuranceCompanyModel);
}
model.InsuranceCompany = insuranceCompanyModels;
APIResult result = new APIResult()
{
Result = ResultType.Success, Code = ResultCode.Success, Message = "", Data = model
};
return(new APIResponse(result));
}
public DataSet SelectByID(InsuranceCompanyModel oClass)
{
strSql = "SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
return(Select(strSql));
}
public DataSet SelectByCountryCode(InsuranceCompanyModel oClass)
{
strSql = "SELECT A.*, B.Name as CountryName " +
"FROM " + TABLE_NAME + " A Left Outer Join Country B On A." + COLUMN_COUNTRY_CODE + " = B.Code " +
"WHERE A." + COLUMN_COUNTRY_CODE + " = '" + oClass.CountryCode + "' ";
return(Select(strSql));
}
public int Update(InsuranceCompanyModel model)
{
string sqlUpdate = "UPDATE InsuranceCompany SET Name = @Name, Email = @Email WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlUpdate, model));
}
}
public int Delete(InsuranceCompanyModel model)
{
string sqlDelete = "DELETE FROM InsuranceCompany WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlDelete, model));
}
}
public int Insert(InsuranceCompanyModel model)
{
string sqlInsert = "INSERT INTO InsuranceCompany (Id, Name, Email) " +
" Values (@Id, @Name, @Email)";
using (_connection)
{
return(_connection.Execute(sqlInsert, model));
}
}
public void DeleteData(string user, InsuranceCompanyModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
" isDeleted = 1, " +
" ReasonDelete = '" + oClass.ReasonDelete.Replace("'", "''") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
private void LoadInsuranceCompany()
{
InsuranceCompanyDAL insuranceCompanyDAL = new InsuranceCompanyDAL();
InsuranceCompanyModel insuranceModel = new InsuranceCompanyModel();
insuranceModel.CountryCode = "PHL";
oDs = new DataSet();
oDs = insuranceCompanyDAL.SelectByCountryCode(insuranceModel);
//var result = oDs.Tables[0].AsEnumerable().Where(myRow => myRow.Field<string>("CountryCode") == "PHL").CopyToDataTable();
ddlInsuranceCompany.DataSource = oDs.Tables[0];
ddlInsuranceCompany.DataTextField = "CompanyName";
ddlInsuranceCompany.DataValueField = "id";
ddlInsuranceCompany.DataBind();
}
protected void Ok_ServerClick(object sender, EventArgs e)
{
string UserName = Session["User"].ToString();
int ID = Convert.ToInt32(HiddenFieldItem.Value);
oDAL = new InsuranceCompanyDAL();
oClass = new InsuranceCompanyModel();
oDs = new DataSet();
oClass.IsDeleted = true;
oClass.ReasonDelete = itemname.InnerText;
string lbl = lblSelectedItem.Text;
oClass.ID = ID;
oDAL.DeleteData(UserName, oClass);
PopulateGrid();
}
public void UpdateData(string user, InsuranceCompanyModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
COLUMN_CODE + " = '" + oClass.Code + "', " +
COLUMN_COMPANY_NAME + " = '" + oClass.CompanyName.Replace("'", "") + "', " +
COLUMN_CONTACT_PERSON + " = '" + oClass.ContactPerson.Replace("'", "") + "', " +
COLUMN_ADDRESS + " = '" + oClass.Address.Replace("'", "") + "', " +
COLUMN_EMAIL + " = '" + oClass.Email.Replace("'", "") + "', " +
COLUMN_PHONE + " = '" + oClass.Phone + "', " +
COLUMN_COUNTRY_CODE + " = '" + oClass.CountryCode + "', " +
COLUMN_DATE_ACCREDIT + " = '" + oClass.DateAccredit.ToString("yyyy-MM-d HH:MM:ss") + "', " +
COLUMN_DATE_EXPIRE + " = '" + oClass.DateExpire.ToString("yyyy-MM-d HH:MM:ss") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
private void PopulateData(int id)
{
oDAL = new InsuranceCompanyDAL();
oClass = new InsuranceCompanyModel();
oDs = new DataSet();
oClass.ID = id;
oDs = oDAL.SelectByID(oClass);
ClientID.Value = oDs.Tables[0].Rows[0][0].ToString();
Code.Value = oDs.Tables[0].Rows[0][1].ToString();
CompanyName.Value = oDs.Tables[0].Rows[0][2].ToString();
ContactPerson.Value = oDs.Tables[0].Rows[0][3].ToString();
ddlCountryCode.SelectedValue = oDs.Tables[0].Rows[0][4].ToString();
txtAddress.Value = oDs.Tables[0].Rows[0][5].ToString();
txtEmail.Value = oDs.Tables[0].Rows[0][6].ToString();
txtContact.Value = oDs.Tables[0].Rows[0][7].ToString();
}
/// <summary>
/// Method whose purpose is to update
/// a new InsuranceCompany record.
/// </summary>
/// <param name="insuranceCompany">
/// Existing InsuranceCompanyModel object.
/// </param>
/// <returns>
/// Returns true if the query is successfully executed
/// otherwise returns false.
/// </returns>
public bool Update(InsuranceCompanyModel insuranceCompany)
{
return(_insuranceCompanyRepository.Update(insuranceCompany) > 0 ? true : false);
}
/// <summary>
/// Method whose purpose is to insert
/// a new InsuranceCompany object.
/// </summary>
/// <param name="insuranceCompany">
/// Existing InsuranceCompanyModel object.
/// </param>
/// <returns>
/// Returns true if the query is successfully executed
/// otherwise returns false.
/// </returns>
public bool Insert(InsuranceCompanyModel insuranceCompany)
{
return(_insuranceCompanyRepository.Insert(insuranceCompany) > 0 ? true : false);
}
