internal static CareReceiverModel GetCareReceiver(int Id, int accountId)
{
CareReceiverModel model = new CareReceiverModel();
using (DBConnector connector = new DBConnector("get_CareReceiver", CommandType.StoredProcedure))
{
connector.Cmd.Parameters.AddWithValue("@UserID", Id);
connector.Cmd.Parameters.AddWithValue("@AccountID", accountId);
connector.Execute(DBOperation.GetReader);
if (connector.Rdr.HasRows)
{
model.UserId = Convert.ToInt32(connector.Rdr["IDUser"]);
model.UserRowId = (Guid)connector.Rdr["UserRowid"];
model.AccountId = Convert.ToInt32(connector.Rdr["AccountID"]);
model.AccountRowId = (Guid)connector.Rdr["AccountRowid"];
model.Name = connector.Rdr["Name"].ToString();
model.Address = connector.Rdr["Address"].ToString();
model.Manager = (bool)connector.Rdr["Manager"];
model.Avatar = connector.Rdr["Avatar"].ToString();
model.Username = connector.Rdr["Username"].ToString();
model.Password = connector.Rdr["Password"].ToString();
model.LastMovementDateTime = (DateTime)connector.Rdr["LastMovementDateTime"];
}
}
return(model);
}
public int SaveCareReceiver([FromBody] CareReceiverModel model)
{
try
{
return(DBOperations.SaveCareReceiver(model, AccountContextHelper.GetContext().AccountId));
}
catch (Exception ex)
{
return(0);
}
}
internal static int SaveCareReceiver(CareReceiverModel model, int accountId)
{
using (DBConnector connector = new DBConnector("save_CareReceiver", CommandType.StoredProcedure))
{
SqlParameter IDParam = new SqlParameter("@UserID", SqlDbType.Int);
IDParam.Direction = ParameterDirection.InputOutput;
IDParam.Value = model.UserId;
connector.Cmd.Parameters.Add(IDParam);
connector.Cmd.Parameters.AddWithValue("@AccountID", accountId);
connector.Cmd.Parameters.AddWithValue("@Name", model.Name);
connector.Cmd.Parameters.AddWithValue("@Address", model.Address);
connector.Cmd.Parameters.AddWithValue("@Email", model.Email);
connector.Cmd.Parameters.AddWithValue("@Note", model.Note);
connector.Cmd.Parameters.AddWithValue("@Username", model.Username);
connector.Cmd.Parameters.AddWithValue("@Password", model.Password);
connector.Execute(DBOperation.SaveWithOutput);
return(Convert.ToInt32(connector.Cmd.Parameters["@UserID"].Value));
}
}