//[ResponseType(typeof(trxNotificationHeader))]
//public IHttpActionResult Post(trxNotificationHeader myData)
//{
// _repository.Post(myData);
// return Ok(myData);
//}
//[ResponseType(typeof(void))]
//public IHttpActionResult Put(int id, trxNotificationHeader myData)
//{
// _repository.Put(id, myData);
// return StatusCode(HttpStatusCode.NoContent);
//}
private string PopulateRecipient(int IdNotification, string ArrRecipient, Guid CreatedUser, bool FlagKirim, bool IsSaluranEmail, bool IsSaluranWhatsapp)
{
string strReturn = "Executed OK";
string strRecipientClean = string.Empty;
DateTime dtmSentDate = new DateTime(1900, 1, 1);
if (ArrRecipient.Length > 5)
{
if (FlagKirim)
{
dtmSentDate = DateTime.Today;
}
strRecipientClean = ArrRecipient.Replace("[\"", "").Replace("\"", "").Replace("\"]", "").Replace("[", "").Replace("]", "");
try
{
using (var context = new DB_SMARTEntities1())
{
var paramIdNotification = new SqlParameter("@IdNotification", IdNotification);
var paramArrRecipient = new SqlParameter("@ArrRecipient", strRecipientClean);
var paramCreatedUser = new SqlParameter("@CreatedUser", CreatedUser);
var paramFlagKirim = new SqlParameter("@FlagKirim", FlagKirim);
var paramSentDate = new SqlParameter("@SentDate", dtmSentDate);
var paramIsSaluranEmail = new SqlParameter("@FlagSaluranEmail", IsSaluranEmail);
var paramIsSaluranWhatsapp = new SqlParameter("@FlagSaluranWhatsapp", IsSaluranWhatsapp);
var result = context.Database.ExecuteSqlCommand("EXEC spPopulateRecipient @IdNotification, @ArrRecipient, @CreatedUser, @FlagKirim, @SentDate, @FlagSaluranEmail, @FlagSaluranWhatsapp"
, paramIdNotification, paramArrRecipient, paramCreatedUser, paramFlagKirim, paramSentDate, paramIsSaluranEmail, paramIsSaluranWhatsapp);
}
}
catch (Exception ex)
{
strReturn = ex.Message;
}
}
return(strReturn);
}
public string TransDataBranch(Guid pGuidHeader)
{
string strReturn = "Executed OK";
try
{
using (var context = new DB_SMARTEntities1())
{
var paramIdHeader = new SqlParameter("@GuidHeader", pGuidHeader);
var result = context.Database.ExecuteSqlCommand("EXEC spTranDataBranch @GuidHeader", paramIdHeader);
}
}
catch (Exception ex)
{
strReturn = ex.Message;
}
return(strReturn);
}
public IEnumerable <trxDetailPekerjaanHeader> DelHeaderByRekanan(Guid idRekanan, Guid PekHeader)
{
IEnumerable <trxDetailPekerjaanHeader> DetailPekByRekanan;
//DELETE HEADER & CHILD
string strReturn = "OKBOSS";
try
{
using (var context = new DB_SMARTEntities1())
{
var paramIdHeader = new SqlParameter("@GuidHeader", PekHeader);
var result = context.Database.ExecuteSqlCommand("EXEC spDelHeaderByRekanan @GuidHeader", paramIdHeader);
}
}
catch (Exception ex)
{
strReturn = ex.Message;
}
DetailPekByRekanan = _repDetailPek.GetByRekanan(idRekanan);
return(DetailPekByRekanan);
}
//public string TransDataTenagaPendukung(Guid pGuidHeader, string pstrIdRekanan, string pstrXLSPointer = "kosong")
public string TransDataTenagaPendukung(Guid pGuidHeader)
{
string strReturn = "Executed OK";
try
{
using (var context = new DB_SMARTEntities1())
{
var paramIdHeader = new SqlParameter("@GuidHeader", pGuidHeader);
//var paramIdRekanan = new SqlParameter("@IdRekanan", pstrIdRekanan);
//var paramXLSPointer = new SqlParameter("@XLSPointer", pstrXLSPointer);
//var result = context.Database.ExecuteSqlCommand("EXEC spTranDataTenagaPendukung @GuidHeader, @IdRekanan, @XLSPointer"
// , paramIdHeader, paramIdRekanan, paramXLSPointer);
var result = context.Database.ExecuteSqlCommand("EXEC spTranDataTenagaPendukung @GuidHeader", paramIdHeader);
}
}
catch (Exception ex)
{
strReturn = ex.Message;
}
return(strReturn);
}
