private void selectActionType(object sender, EventArgs e)
{
btnUpdate.Enabled = true;
btnAddActionType.Enabled = false;
txtActionType.Enabled = false;
String ActionTypeid = gridView1.GetFocusedDataRow()["Id"].ToString();
ActionTypeService actionType = new ActionTypeService();
actionType.getActionTypeDetailsByID(ActionTypeid);
txtActionType.Text = actionType.ActionType.ToString().Trim();
int intDuration;
intDuration = actionType.Duration;
if (intDuration >= 24)
{
int days = intDuration / 24;
int Hours = intDuration % 24;
txtDurationDays.Text = days.ToString();
txtDurationHours.Text = Hours.ToString();
}
else
{
txtDurationDays.Text = "0";
txtDurationHours.Text = actionType.Duration.ToString();
}
txtFirstReminder.Text = actionType.IntFirstReminder.ToString();
txtEscaltion1.Text = actionType.Intescaltion1.ToString();
txtEscaltion2.Text = actionType.Intescaltion2.ToString();
tabActionType.SelectedTabPage = xtraTabPage2;
xtraTabPage1.PageEnabled = false;
xtraTabPage2.PageEnabled = true;
xtraTabPage3.PageEnabled = false;
}
private void clearAll()
{
ActionTypeService actionType = new ActionTypeService();
txtActionType.Text = "";
txtDurationDays.Text = "";
txtDurationHours.Text = "";
//chkBxDateTimeMan.Checked = false;
txtFirstReminder.Text = "";
txtEscaltion1.Text = "";
txtEscaltion2.Text = "";
//cmbBxActionType.SelectedIndex = -1;
txtActionTypeDesc.Text = "";
//cmbBxCheckList.SelectedIndex = -1;
txtActionTypeDesc.Text = "";
//cmbBxCheckList.SelectedIndex = -1;
txtCheckListDesc.Text = "";
//txtCheckListDurationDays.Text = "";
//txtCheckListDurationHours.Text = "";
txtChecklistSeqNo.Text = "";
txtCheckListEscPer.Text = "";
btnAddActionType.Text = "Add Action Type";
btnAddCheckList.Text = "Add Checklist";
btnUpdate.Enabled = false;
DataTable dt = actionType.getAllActionTypeDetails();
gridActionType.DataSource = dt;
// tblActionTypeCheckList.DataSource = new DatabaseService().executeSelectQuery("SELECT ActionTypeID,ActionType,SubActionType,SeqNo FROM ActionTypeCheckList");
tabActionType.SelectedTabPage = xtraTabPage1;
xtraTabPage1.PageEnabled = true;
xtraTabPage2.PageEnabled = false;
xtraTabPage3.PageEnabled = false;
}
private void btnAddActionType_Click(object sender, EventArgs e)
{
if (InfoPCMS.user.checkFunctionAuthentication("77"))
{
if (btnAddActionType.Text == "Add Action Type")
{
btnAddActionType.Text = "Save";
tabActionType.SelectedTabPage = xtraTabPage2;
xtraTabPage1.PageEnabled = false;
xtraTabPage2.PageEnabled = true;
xtraTabPage3.PageEnabled = false;
}
else if (btnAddActionType.Text == "Save")
{
ActionTypeService actionType = new ActionTypeService();
if (string.IsNullOrEmpty(txtDurationDays.Text.ToString()))
{
txtDurationDays.Text = "0";
}
if (string.IsNullOrEmpty(txtDurationHours.Text.ToString()))
{
txtDurationHours.Text = "0";
}
if (this.ValidationActionType())
{
XtraMessageBox.Show(InfoPCMS.message.GET_EMPTY_FIELDS_ERROR(), "Error");
}
else
{
int intDurations = (Convert.ToInt32(txtDurationDays.Text.ToString()) * 24 + Convert.ToInt32(txtDurationHours.Text.ToString()));
actionType.ActionType = txtActionType.Text.Trim();
actionType.Duration = intDurations;
actionType.IntFirstReminder = Convert.ToInt32(txtFirstReminder.Text.ToString().Trim());
actionType.Intescaltion1 = Convert.ToInt32(txtEscaltion1.Text.ToString().Trim());
actionType.Intescaltion2 = Convert.ToInt32(txtEscaltion2.Text.ToString().Trim());
//actionType.IsDateTimeMandatory = Convert.ToString(chkBxDateTimeMan.Checked);
Boolean result = actionType.addActionType();
if (result)
{
//DataTable dt = InfoPCMS.db.executeSelectQuery(String.Format("select * from ActionType where ActionType='{0}' ", txtActionType.Text));
//if (dt.Rows.Count > 0)
//{
// new DatabaseService().executeUpdateQuery(String.Format("INSERT INTO CustomerLocation VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')", dt.Rows[0]["Id"], dt.Rows[0]["CustomerName"], dt.Rows[0]["NbtChargeble"], dt.Rows[0]["NbtChargeble"], dt.Rows[0]["ContactNumber"], dt.Rows[0]["Address"], dt.Rows[0]["Company"], dt.Rows[0]["Designation"], dt.Rows[0]["Faxno"], dt.Rows[0]["Email"], dt.Rows[0]["ServiceCenter"], dt.Rows[0]["DistancetoServiceCenter"], dt.Rows[0]["DistanceFromColombo"], dt.Rows[0]["HiltopSite"], dt.Rows[0]["NonMotorable"]));
//}
clearAll();
XtraMessageBox.Show(InfoPCMS.message.GET_RECORD_ADDED_INFORMATION(), "Information");
//txtActionTypeDesc.Text ""
// cmbBxCheckList.DataSource = null;
// DataTable dt2 = InfoPCMS.db.executeSelectQuery("select * from ActionType");
// dt.Columns.Add("ConcatenatedField", typeof(string), "CustomerName + ' : ' + Address");
//cmbBxActionType.DataSource = dt2;
//cmbBxActionType.ValueMember = "ActionType";
//cmbBxActionType.DisplayMember = "ActionType";
//cmbBxCheckList.DataSource = dt2;
//cmbBxCheckList.ValueMember = "ActionType";
// cmbBxCheckList.DisplayMember = "ActionType";
}
}
}
}
}
public IEnumerable <ServiceAction> GetActions(Int64 user_id, DateTime dateBegin, DateTime dateEnd)
{
var date1 = new DateTime(dateBegin.Year, dateBegin.Month, dateBegin.Day, 0, 0, 0);
var date2 = new DateTime(dateEnd.Year, dateEnd.Month, dateEnd.Day, 23, 59, 59);
var actions = new List <ServiceAction>();
SqlConnection connection = SqlProvider.CreateConnection();
SqlCommand cmd = null;
SqlDataReader reader = null;
try {
cmd = connection.CreateCommand();
cmd.CommandText = @"
select a.id, a.dt, a.customer, a.service_id, a.type_id, a.user_id, s.org_id, a.customer_type_id
from Actions a
join Services s on s.id = a.service_id
where a.dt between @date1 and @date2
and a.is_deleted = 0 ";
cmd.Parameters.AddWithValue("date1", date1);
cmd.Parameters.AddWithValue("date2", date2);
if (user_id >= 0)
{
cmd.CommandText += " and a.user_id = @user_id";
cmd.Parameters.AddWithValue("user_id", user_id);
}
cmd.CommandText += " order by a.dt desc, a.id desc";
reader = cmd.ExecuteReader();
while (reader.Read())
{
actions.Add(new ServiceAction {
Id = Convert.ToInt64(reader["id"]),
Service = ServiceService.GetServiceById(Convert.ToInt64(reader["service_id"])),
User = UserService.GetUserById(Convert.ToInt64(reader["user_id"])),
Date = Convert.ToDateTime(reader["dt"]),
Type = ActionTypeService.GetTypeById(Convert.ToInt64(reader["type_id"])),
Customer = reader["customer"] != DBNull.Value ? Convert.ToString(reader["customer"]) : string.Empty,
CustomerType = reader["customer_type_id"] != DBNull.Value ? CustomerTypeService.GetTypeById(Convert.ToInt64(reader["customer_type_id"])) : CustomerType.Empty
});
}
}
catch (Exception e) {
Logger.Error(e);
throw;
}
finally {
if (reader != null)
{
reader.Close();
reader.Dispose();
}
if (cmd != null)
{
cmd.Dispose();
}
connection.Close();
}
return(actions);
}
