public void CreateNewCard()
{
editableItem = (DeceasedCard)CreateNewItem();
ClearAllViews();
sqlmgr.Reconnect();
var res = sqlmgr.CreateNewEmptyCard(_currentUser.Id, _shift.CurrentShiftId);
_card_id = res.Key;
_shift_people = res.Value;
DeceasedCard card = new DeceasedCard();
sqlmgr.GetCardAgents(card);
ControlFiller.FillListControl((view_controls[3] as ListBox), card.Agents, null, false);
sqlmgr.Disconnect();
ControlHelper.SetSelectedListControlItem((GetControlByName("DispetcherCB", true) as ComboBox), "Id", res.Value.DispetcherId);
ControlHelper.SetSelectedListControlItem((GetControlByName("SmenaHelperCB", true) as ComboBox), "Id", res.Value.HelperId);
ControlHelper.SetSelectedListControlItem((GetControlByName("DocumentsLinkerCB", true) as ComboBox), "Id", -1);
}
public void UpdateCard(DeceasedCard card, int shift_id)
{
_cmd = CreateCommand("UpdateCard");
_param = CreateParameter("@card_id", DbType.Int32, 4);
_param.Value = card.CardId;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@shift_id", DbType.Int32, 4);
_param.Value = shift_id;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@Address", DbType.String, 1000);
_param.Value = card.Address;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@dead_fio", DbType.String, 75);
_param.Value = card.DeadFIO;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@Avans", DbType.Double, 8);
_param.Value = card.Avans;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@IsAvansPayed", DbType.Boolean, 1);
_param.Value = card.IsAvansPayed;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@Result", DbType.String, 1000);
_param.Value = card.Result;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@Comments", DbType.String, 1000);
_param.Value = card.Comments;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@micro_raion_id", DbType.Int32, 4);
_param.Value = card.MicroraionId;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@funereal_type", DbType.String, 25);
_param.Value = card.FuneralType;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@order_sum", DbType.Double, 8);
_param.Value = card.SumOfOrder;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@kvitancia_num", DbType.Int32, 4);
_param.Value = card.KvitanciyaNum;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@profit_sum", DbType.Double, 8);
_param.Value = card.ProfitSum;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@dispetcher_id", DbType.Int32, 4);
_param.Value = card.DispetcherId;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@helper_id", DbType.Int32, 4);
_param.Value = card.HelperId;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@doc_linker_id", DbType.Int32, 4);
_param.Value = card.DocLinkerId;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@transport_id", DbType.Int32, 4);
_param.Value = card.TransportationId;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@office_id", DbType.Int32, 4);
_param.Value = card.OfficeId;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@passport", DbType.Boolean, 1);
_param.Value = card.Passport;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@has_order", DbType.Boolean, 1);
_param.Value = card.HasOrder;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@debt_sum", DbType.Int32, 8);
_param.Value = card.DebtSum;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@link_date", DbType.DateTime, 0);
_param.Value = card.DocLinkDate;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@link_company_id", DbType.Int32, 4);
_param.Value = card.LinkCompanyId;
_cmd.Parameters.Add(_param);
_param = CreateParameter("@transportation_comment", DbType.String, 30);
if (string.IsNullOrEmpty(card.TransportationComment))
_param.Value = DBNull.Value;
else
_param.Value = card.TransportationComment;
_cmd.Parameters.Add(_param);
ExecuteCommand(_cmd.ExecuteNonQuery);
if (card.DocLinkerVisibility)
AddCardvisbilityForDocLinkers(card.CardId);
}
public DeceasedCard GetCardById(int card_id)
{
DeceasedCard res = new DeceasedCard();
res.Agents = new List<string>();
_cmd = CreateCommand("GetCardById");
_param = CreateParameter("@card_id", DbType.Int32, 4);
_param.Value = card_id;
_cmd.Parameters.Add(_param);
_DR = ExecuteDataReader(_cmd.ExecuteReader);
while (_DR.Read())
{
res.CardId = (int)_DR["card_id"];
res.Address = _DR["Address"].ToString();
res.DeadFIO = _DR["dead_fio"].ToString();
if (_DR["Avans"] != DBNull.Value)
res.Avans = (double)_DR["Avans"];
res.IsAvansPayed = (bool)_DR["IsAvansPayed"];
res.Result = _DR["Result"].ToString();
res.Comments = _DR["Comments"].ToString();
res.MicroraionId = (int)_DR["micro_raion_id"];
if (_DR["order_sum"] != DBNull.Value)
res.SumOfOrder = (double)_DR["order_sum"];
if (_DR["profit_sum"] != DBNull.Value)
res.ProfitSum = (double)_DR["profit_sum"];
if (_DR["kvitancia_num"] != DBNull.Value)
res.KvitanciyaNum = (int)_DR["kvitancia_num"];
if (_DR["funereal_type"] != DBNull.Value)
res.FuneralType = _DR["funereal_type"].ToString();
if (_DR["debt_sum"] != DBNull.Value)
res.DebtSum = (double)_DR["debt_sum"];
if (_DR["transport_id"] == DBNull.Value)
res.TransportationId = 0;
else
res.TransportationId = (int)_DR["transport_id"];
if (_DR["office_id"] == DBNull.Value)
res.OfficeId = 0;
else
res.OfficeId = (int)_DR["office_id"];
if (_DR["link_date"] == DBNull.Value)
res.DocLinkDate = DateTime.Now;
else
res.DocLinkDate = (DateTime)_DR["link_date"];
if (_DR["dispetcher_id"] == DBNull.Value)
res.DispetcherId = -1;
else
res.DispetcherId = (int)_DR["dispetcher_id"];
if (_DR["helper_id"] == DBNull.Value)
res.HelperId = -1;
else
res.HelperId = (int)_DR["helper_id"];
if (_DR["doc_linker_id"] == DBNull.Value)
res.DocLinkerId = -1;
else
res.DocLinkerId = (int)_DR["doc_linker_id"];
if (_DR["shift_id"] == DBNull.Value)
res.ShiftId = -1;
else
res.ShiftId = (int)_DR["shift_id"];
if (_DR["link_company_id"] == DBNull.Value)
res.LinkCompanyId = 0;
else
res.LinkCompanyId = (int)_DR["link_company_id"];
res.CreatedDate = (DateTime)_DR["created_Date"];
res.CreatedUserId = (int)_DR["created_user_id"];
res.Passport = (bool)_DR["passport"];
res.HasOrder = (bool)_DR["has_order"];
if (_DR["doclinkervisibility"] != DBNull.Value)
res.DocLinkerVisibility = true;
else
res.DocLinkerVisibility = false;
if (_DR["transportation_comments"] != DBNull.Value)
res.TransportationComment = _DR["transportation_comments"].ToString();
else
res.TransportationComment = "";
}
_DR.Close();
GetCardAgents(res);
GetCardInformators(res);
GetCardRelatives(res);
res.Relatives.SetRelativesTypes(GetRelativesTypes());
res.Relatives.SetPhoneTypes(GetPhonesTypes());
return res;
}
public void GetCardAgents(DeceasedCard card)
{
_cmd = CreateCommand("GetCardAgents");
_param = CreateParameter("@card_id", DbType.Int32, 4);
_param.Value = card.CardId;
_cmd.Parameters.Add(_param);
_DR = ExecuteDataReader(_cmd.ExecuteReader);
while (_DR.Read())
card.Agents.Add(_DR["agent_name"].ToString());
_DR.Close();
}
private void GetCardRelatives(DeceasedCard card)
{
_cmd = CreateCommand("GetCardRelatives");
_param = CreateParameter("@card_id", DbType.Int32, 4);
_param.Value = card.CardId;
_cmd.Parameters.Add(_param);
_DR = ExecuteDataReader(_cmd.ExecuteReader);
while (_DR.Read())
{
Relative rel = new Relative();
rel.Id = (int)_DR["relative_id"];
rel.Name = _DR["relative_fio"].ToString();
rel.Phone = _DR["phone_number"].ToString();
rel.RelativeType = (int)_DR["rel_type_id"];
rel.PhoneType = (int)_DR["phone_type_id"];
card.Relatives.Add(rel);
}
_DR.Close();
}
private void GetCardInformators(DeceasedCard card)
{
_cmd = CreateCommand("GetCardInformators");
_param = CreateParameter("@card_id", DbType.Int32, 4);
_param.Value = card.CardId;
_cmd.Parameters.Add(_param);
_DR = ExecuteDataReader(_cmd.ExecuteReader);
while (_DR.Read())
{
Informator inf = new Informator();
inf.Id = Convert.ToInt32(_DR["informator_id"]);
inf.InformatorName = _DR["informator"].ToString();
inf.Time = (DateTime)_DR["reg_time"];
inf.Money = (double)_DR["informator_money"];
card.Informators.Add(inf);
}
_DR.Close();
}
