public void r105Implementation(OrdersWaitingForPriceChangeModel instance)
{
// This is the placeholder for method implementation.
int ordStatus = 5; // sent for approval lv1
if (UserIsInRole("SalesClerk"))
{
SqlText.ExecuteNonQuery("Update OrderHed Set OrderStatusID=@OrderStatusID Where OrderHedID=@OrderHedID ",
new { @OrderHedID = instance.OrderHedID, @OrderStatusID = ordStatus });
SqlText.ExecuteNonQuery(
"Insert into OrderStatusLog (OrderHedID,UserID,[Comment],[RejectReason],[OtherRemarks],[TranDate]) Values " +
"(@OrderHedID,@UserID,@Comment,@RejectReason,@OtherRemarks,@TranDate) "
, new
{
@OrderHedID = instance.OrderHedID,
@UserID = UserId,
@Comment = "Price Change Request Accepted.",
@RejectReason = "",
@OtherRemarks = "",
@TranDate = DateTime.Now
});
//Result.ShowAlert("OrderNo : {0} Price Change Request Accepted.",instance.OrderHedID);
}
}
private void PrepareUpdateSql()
{
SqlText.AppendFormat("Update {0} set ", TableName);
Separator = null;
for (var index = 0; index < SqlColumns.Length; index++)
{
var columnInfo = SqlColumns[index];
if (columnInfo.IsInPrimaryKey || columnInfo.IsDatabaseGenerated)
{
continue;
}
AddSeparator(", ");
SqlText.Append(Encode(columnInfo.ColumnName) + "=@p" + ParameterValues.Count);
ParameterValues.Add(columnInfo.ValueReader.ReadPropertyValue(Entity));
}
SqlText.Append(" where ");
Separator = null;
foreach (var i in SqlColumns)
{
if (!i.IsInPrimaryKey)
{
continue;
}
AddSeparator(" AND ");
SqlText.Append(Encode(i.ColumnName) + "=@p" + ParameterValues.Count);
ParameterValues.Add(i.ValueReader.ReadPropertyValue(Entity));
}
}
private void Update(DbContext context)
{
// _sb.AppendLine("SET NOCOUNT ON;");
PrepareUpdateSql();
var sql = SqlText.ToString();
var tmp = context.Database.ExecuteSqlCommand(sql, ParameterValues.ToArray());
}
/// <summary>
/// Get any manually submitted jobs. These are on the BatchJobQueue table.
/// They are deleted from the table once they have been selected for processing.
/// </summary>
/// <returns></returns>
private static List <JobRequest> AnyManualJobsRequired()
{
List <JobRequest> jobs = new List <JobRequest>();
// safely get jobs that have been manually submitted (exclude jobs prefixed with ABLE these are processed by the ABLE Commerce site.
using (Redi.Utility.SqlText select = new SqlText(
"Select DBID, RequestName, RequestedDateTimeUtc, Submitted, RequestData " +
"From ALL_BatchJobQueue " +
"Where Submitted = 0 AND DueDateTimeUtc <= @DueDateTimeUtc AND RequestName Like'ABLE%' "))
{
select.AddParameter("@DueDateTimeUtc", DateTime.UtcNow);
DbDataReader myReader = select.ExecuteReader();
while (myReader.Read())
{
JobRequest job = new JobRequest();
job.RequestDBID = myReader.GetInt64(0);
job.Name = myReader.GetString(1);
job.RequestedAt = myReader.GetDateTime(2);
job.Submitted = myReader.GetBoolean(3);
job.RequestData = myReader.GetString(4).Trim('?');
jobs.Add(job);
}
}
return(jobs);
}
private List <ColumnInfo> PrepareSelectSql()
{
var returned = SqlColumns.Where(a => a.IsDatabaseGenerated).ToList();
if (!returned.Any())
{
return(null);
}
Separator = " AND ";
SqlText.Append("select " + string.Join(",", returned.Select(q => Encode(q.ColumnName))));
SqlText.Append(" from " + TableName + " WHERE @@ROWCOUNT=1");
if (IdentityColumn != null)
{
AddSeparator(Separator);
SqlText.Append(Encode(IdentityColumn.ColumnName) + "=scope_identity();");
}
else
{
for (var index = 0; index < SqlColumns.Length; index++)
{
var col = SqlColumns[index];
if (!col.IsInPrimaryKey)
{
continue;
}
var pn = AddPropertyValue(index);
AddSeparator(Separator);
SqlText.Append(Encode(col.ColumnName) + "=" + pn);
}
}
return(returned);
}
public void r101Implementation(OrdersWaitingForPriceChangeModel instance)
{
// This is the placeholder for method implementation.
if (Arguments.CommandArgument == "OrderDtlVw2")
{
//decimal total = (decimal)SqlText.ExecuteScalar("select isnull(Sum(SellingPrice * OrderQty),0) From OrderDtl Where OrderHedID=@OrderHedID ",
// instance.OrderHedID);
//instance.TotalAmount = total;
//int i = SqlText.ExecuteNonQuery("Update OrderHed Set TotalAmount=@total Where OrderHedID=@OrderHedID",
// total, instance.OrderHedID);
decimal total = (decimal)SqlText.ExecuteScalar("select isnull(Sum(SellingPrice * OrderQty),0) From OrderDtl Where OrderHedID=@OrderHedID ",
instance.OrderHedID);
decimal proposedTotal = (decimal)SqlText.ExecuteScalar("select isnull(Sum(IIF(ProposedSellingPrice is null, SellingPrice,ProposedSellingPrice) * OrderQty),0) From OrderDtl Where OrderHedID=@OrderHedID ",
instance.OrderHedID);
instance.TotalAmount = proposedTotal > 0 ? proposedTotal : total;
string totalAmount = instance.TotalAmount.ToString();
int i = SqlText.ExecuteNonQuery("Update OrderHed Set TotalAmount=@totalAmount Where OrderHedID=@OrderHedID",
instance.TotalAmount, instance.OrderHedID);
}
}
public string ShowMatInText(string strCondition)
{
string[] strArr = strCondition.Split(':');
System.Collections.ArrayList mass = new System.Collections.ArrayList();
System.Collections.ArrayList key1 = new System.Collections.ArrayList();
System.Collections.ArrayList key2 = new System.Collections.ArrayList();
System.Collections.ArrayList key3 = new System.Collections.ArrayList();
using (SqlText sql = new SqlText(String.Format("select m.MassPartsIDFlag, m.ExpansionKey1, m.ExpansionKey2, m.ExpansionKey3 from MaterialNumber as m join Customer as c on m.ShiptoParty = c.Code where c.PlantCode = '{1}' and shiptoParty like '{0}%' and m.customerItemNumber = '{2}'", strArr[0], strArr[1], strArr[2])))
{
System.Data.Common.DbDataReader readerSender = sql.ExecuteReader();
while (readerSender.Read())
{
mass.Add(readerSender["MassPartsIDFlag"].ToString());
key1.Add(readerSender["ExpansionKey1"].ToString());
key2.Add(readerSender["ExpansionKey2"].ToString());
key3.Add(readerSender["ExpansionKey3"].ToString());
}
readerSender.Close();
readerSender.Dispose();
}
MN[] l = new MN[mass.Count];
for (int i = 0; i <= mass.Count - 1; i++)
{
l[i] = new MN();
l[i].MassPartsIDFlag = mass[i].ToString();
l[i].ExpansionKey1 = key1[i].ToString();
l[i].ExpansionKey2 = key2[i].ToString();
l[i].ExpansionKey3 = key3[i].ToString();
}
return(new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(l));
}
protected override void BeforeSqlAction(ActionArgs args, ActionResult result)
{
if (args.CommandName == "Insert" && args["Number"].Value == null)
{
String Quote_no = null;
using (SqlText findPrice = new SqlText(
"select dbo.GenerateNewQuotationNumber (@EnqID,1) as enq_no"))
{
findPrice.AddParameter("@EnqID", args["EnquiryID"].Value);
Quote_no = Convert.ToString(findPrice.ExecuteScalar());
}
args["Number"].NewValue = Quote_no;
args["Number"].Modified = true;
// args["CreatedByUserID"].NewValue = WindowsIdentity.GetCurrent().Name;
// args["CreatedByUserID"].Modified = true;
}
// if (args["CreatedByUsername"].Value == null)
if (args.CommandName == "Insert" && args["CreatedByUsername"].Value == null)
{
MembershipUser User = Membership.GetUser();
args["CreatedByUsername"].NewValue = User.UserName;
args["CreatedByUsername"].Modified = true;
// args["CreatedByUserID"].NewValue = WindowsIdentity.GetCurrent().Name;
// args["CreatedByUserID"].Modified = true;
}
}
protected override void ExecuteAction(ActionArgs args, ActionResult result)
{
if (args.CommandName == "Custom" && args.CommandArgument == "SetQuoteStatusClosed")
{
// args["NewStatusID"].NewValue = "OK";
// args["NewStatusID"].Modified = true;
// args["MainEquipment"].NewValue = "TRYME";
// args["MainEquipment"].Modified = true;
// Result.ShowAlert("Quote closed." + " O-" + args["NewStatusID"].OldValue + " N-" + args["NewStatusID"].NewValue + " V-" + args["NewStatusID"].Value + " ID-" + args["ID"].Value);
using (SqlText updatePrice = new SqlText(
"update [Quotations] set StatusID=@StatusID where ID=@ID"))
{
updatePrice.AddParameter("@StatusID", 5);
updatePrice.AddParameter("@ID", args["ID"].Value);
// updatePrice.ExecuteNonQuery();
}
Result.ShowAlert("Quote closed.");
}
if (args.CommandName == "Custom" && args.CommandArgument == "SetQuoteStatusSuccess")
{
Result.ShowAlert("Quote Successful.");
}
if (args.CommandName == "Custom" && args.CommandArgument == "SetQuoteStatusRevision")
{
Result.ShowAlert("Quote Revised.");
}
}
private async void ModelRun()
{
await Task.Run(() =>
{
if (!string.IsNullOrEmpty(DBName))
{
ModelHelper model = new ModelHelper();
SqlSugar.DbType ty = SqlSugar.DbType.SqlServer;
switch (Constraint.value)
{
case 3:
ty = SqlSugar.DbType.MySql;
break;
case 4:
ty = SqlSugar.DbType.Oracle;
break;
}
string json = model.GetTableJson(DBName, ty);
if (IsSugar)
{
SqlText = Common.format(model.ModelCreate(json, "MeiCloud.DataAccess", "Sugar"));
}
else
{
SqlText = Common.format(model.ModelCreate(json, "MeiCloud.DataAccess"));
}
SqlText = SqlText.Replace("\nusing Creative.ODA;", "");
Loading.Framework.HideLoading();
}
}).ConfigureAwait(true);
}
private void AddNotify_Click()
{
if (String.IsNullOrEmpty(SqlText))
{
return;
}
List <string> arrs = new List <string>(SqlText.Split(' '));
string sr = "";
if (arrs.Count == 1)
{
sr += "private string _" + arrs[0] + ";public string " + arrs[0]
+ "{get{return _" + arrs[0] + ";}set{_" + arrs[0] + " = value;NotifyPropertyChanged(\"" + arrs[0] + "\");}";
}
else if (arrs.Count == 2)
{
sr += "private " + arrs[0] + " _" + arrs[1] + ";public " + arrs[0] + " " + arrs[1]
+ "{get{return _" + arrs[1] + ";}set{_" + arrs[1] + " = value;NotifyPropertyChanged(\"" + arrs[1] + "\");}";
}
else if (arrs.Count > 2)
{
sr += "private " + arrs[1] + " _" + arrs[2] + ";"
+ arrs[0] + " " + arrs[1] + " " + arrs[2]
+ "{get{return _" + arrs[2] + ";}set{_" + arrs[2] + " = value;NotifyPropertyChanged(\"" + arrs[2] + "\");}";
}
sr = System.Text.RegularExpressions.Regex.Replace(sr, "[\r\n\t]", "");
SqlText = "/// <summary>\r\n///\r\n/// </summary>\r\n" + Xu.Common.Common.format(sr + '}');
}
public static string GetReflectedFullName(SqlTagContext ctx, SqlText sqlText, string propertyName)
{
if (ctx == null)
throw new ArgumentNullException("ctx");
if (sqlText == null)
throw new ArgumentNullException("sqlText");
if (propertyName == null)
throw new ArgumentNullException("propertyName");
if (sqlText.Parent == null)
return propertyName;
if (sqlText.Parent is Iterate)
return BuildReflectedFullName(ctx, (Iterate)sqlText.Parent, propertyName);
if (sqlText.Parent is BaseTag)
{
var parentIteratorTag = FindParentIteratorTag(ctx, (BaseTag)sqlText.Parent);
// is current node a child of another iterate node?
if (parentIteratorTag != null)
return BuildReflectedFullName(ctx, parentIteratorTag, propertyName);
}
return propertyName;
}
private void Update(DbContext context, bool skipSelect)
{
var returned = PrepareUpdateSql(skipSelect);
var sql = SqlText.ToString();
ExecSqlAndUpdateBack(sql, context, Entity, returned, ParameterValues.ToArray());
}
private async Task UpdateAsync(DbContext context, bool skipSelect)
{
var returned = PrepareUpdateSql(skipSelect);
var sql = SqlText.ToString();
await ExecSqlAndUpdateBackAsync(sql, context, Entity, returned, ParameterValues.ToArray());
}
private IReadOnlyList <ColumnInfo> PrepareUpdateSql(bool skipSelect)
{
var whereSql = PrepareWhereSql();
SqlText.AppendFormat("Update {0} set ", TableName);
Separator = null;
for (var index = 0; index < SqlColumns.Count; index++)
{
var columnInfo = SqlColumns[index];
if (columnInfo.IsInPrimaryKey || columnInfo.IsDatabaseGenerated)
{
continue;
}
AddSeparator(", ");
SqlText.Append(Encode(columnInfo.ColumnName) + "=@p" + ParameterValues.Count);
ParameterValues.Add(columnInfo.ValueReader.ReadPropertyValue(Entity));
}
SqlText.Append(whereSql);
if (skipSelect)
{
return(new ColumnInfo[0]);
}
var returned = SqlColumns.Where(a => a.IsDatabaseGenerated && !a.IsInPrimaryKey).ToList();
if (!returned.Any())
{
return(returned);
}
SqlText.Append("; select " + string.Join(",", returned.Select(q => Encode(q.ColumnName))));
SqlText.Append(" from " + TableName);
SqlText.Append(whereSql);
return(returned);
}
public string getUnitCode(string MatCode, string CustCode)
{
using (SqlText sql = new SqlText(String.Format("select top(1) isnull(UnitCode,'') from MaterialNumber where CustomerItemNumber = '{0}' and SoldtoParty = '{1}'", CustCode, MatCode)))
{
string result = sql.ExecuteScalar().ToString();
return(result);
}
}
public string Customer_Validate(string CustCode)
{
using (SqlText sql = new SqlText(String.Format("select count(1) from Customer where Code = '{0}'", CustCode)))
{
string result = sql.ExecuteScalar().ToString();
return(result);
}
}
public void GetRawValue()
{
SqlType type = new SqlText("Test", ParameterDirection.Input);
Assert.AreEqual("Test", type.GetRawValue());
type = new SqlText(null, ParameterDirection.Input);
Assert.Null(type.GetRawValue());
}
public void GetParameter()
{
SqlType type = new SqlText("Test", ParameterDirection.Input);
TestHelper.AssertSqlParameter(type.GetParameter(), SqlDbType.Text, "Test", size: -1);
type = new SqlText(null, ParameterDirection.Input);
TestHelper.AssertSqlParameter(type.GetParameter(), SqlDbType.Text, DBNull.Value, size: -1);
}
public void GetParameter()
{
SqlType type = new SqlText("Test", ParameterDirection.Input);
TestHelper.AssertSqlParameter(type.GetParameter(), SqlDbType.Text, "Test", size: -1);
type = new SqlText(null, ParameterDirection.Input);
TestHelper.AssertSqlParameter(type.GetParameter(), SqlDbType.Text, DBNull.Value, size: -1);
}
public void GetRawValue()
{
SqlType type = new SqlText("Test", ParameterDirection.Input);
Assert.AreEqual("Test", type.GetRawValue());
type = new SqlText(null, ParameterDirection.Input);
Assert.Null(type.GetRawValue());
}
internal IList <BindingReplacement> BuildTextBindingReplacements(SqlText tag)
{
if (tag == null)
{
throw new ArgumentNullException("tag");
}
return(InlineParameterMapParser.BuildBindingReplacements(_bindings, new StringBuilder(tag.Text)));
}
public void r104Implementation(Contratado_Solicitud_VacacionesModel instance)
{
// This is the placeholder for method implementation.
//string conStr = ConfigurationManager.ConnectionStrings["arhmexdb_DEV"].ToString();
int diasFinalesAutorizados = Convert.ToInt32(instance.Dias_Autorizados);
using (SqlProcedure sql = new SqlProcedure("dbo.sp_Revision_De_Solicitud"))
{
sql.Command.CommandTimeout = 60 * 10;
//Definición parametro especial para recibir el RETURN del SP
sql.AddParameter("RetVal", 0);
sql.Parameters["RetVal"].Direction = ParameterDirection.ReturnValue;
sql.AddParameter("@Tipo_Prestacion_Id", 1); // PRESTACION TIPO VACACION
sql.AddParameter("@Estado_Solicitud_Vacaciones", 4); // 4. Significa AUTORIZADO CON CAMBIOS
sql.AddParameter("@Solicitud_Vacaciones_Key", instance.Solicitud_Vacaciones_Key);
sql.AddParameter("@Dias_Autorizados", diasFinalesAutorizados);
//sql.AddParameter("@Contratante_Id", instance.Contratante_Id);
sql.AddParameter("@Contratado_Id", instance.Contratado_Id);
sql.AddParameter("@Fecha_Solicitud", instance.Fecha_Solicitud);
sql.AddParameter("@Dias_Solicitados", instance.Dias_Solicitados);
sql.AddParameter("@Fecha_Inicio_Vacaciones", instance.Fecha_Inicio_Vacaciones);
sql.AddParameter("@Fecha_Fin_Vacaciones", instance.Fecha_Fin_Vacaciones);
sql.AddParameter("@Notas_Autorizacion_Rechazo", "");
/*Parametros de sistema**/
sql.AddParameter("@Creado_Por_Id", UserId);
sql.AddParameter("@Transaccion_Id", DBNull.Value);
sql.AddParameter("@Fijar_Bitacora", 1);
sql.AddParameter("@Mostrar_Tablas_Sistema", 0);
//cmd.Parameters.Add("@Mensaje_Sistema_Id", 1);//.Direction = ParameterDirection.Output;
sql.AddParameter("@Mensaje_Sistema_Id", 1);
sql.AddParameter("@Simular", 0);
sql.AddParameter("@Trace", ""); //.Direction = ParameterDirection.Output;
sql.AddParameter("@Debug", 0);
sql.Parameters["@Mensaje_Sistema_Id"].Direction = ParameterDirection.Output;
sql.Parameters["@Trace"].Direction = ParameterDirection.Output;
//Definición de tamaños que soporten los tipos de datos de los parametros del salida del SP
sql.Parameters["@Mensaje_Sistema_Id"].Size = 4;
sql.Parameters["@Trace"].Size = 8000;
sql.ExecuteNonQuery();
if (sql.Parameters["RetVal"].Value.ToString() != "1")
{
String ErrorMessage = SqlText.ExecuteScalar("SELECT Mensaje_Amigable_Usuario FROM dbo.Mensaje_Sistema WHERE Mensaje_Sistema_Id=" + sql.Parameters["@Mensaje_Sistema_Id"].Value.ToString()).ToString();
Result.ShowAlert(ErrorMessage);
}
else
{
Result.Continue();
}
} // using (SqlProcedure sql = new SqlProcedure("dbo.sp_Revision_De_Solicitud"))
} //public void r104Implementation(Contratado_Solicitud_VacacionesModel instance)
public void r105Implementation(OrderDtlModel instance)
{
// This is the placeholder for method implementation.
if (instance.OrderQty <= 0 && instance.Focqty <= 0)
{
PreventDefault();
Result.Focus("OrderQty", "OrderQty Or FOCQty must be greater than 0");
}
if (Arguments.CommandName.ToLower() == "insert")
{
}
else if (Arguments.CommandName.ToLower() == "update")
{
if (!(bool)instance.OrderHedBulkOrder)
{
if (instance[OrderDtlDataField.OrderQty].Modified)
{
int i = SqlText.ExecuteNonQuery("UPDATE OrderRel Set OrderRelQty=@OrderQty WHERE OrderDtlID=@OrderDtlID and Seq=1"
, instance.OrderQty, instance.OrderDtlID);
}
if (instance[OrderDtlDataField.Focqty].Modified)
{
int i = SqlText.ExecuteNonQuery("UPDATE OrderRel Set FOCRelQty=@Focqty WHERE OrderDtlID=@OrderDtlID and Seq=1"
, instance.Focqty, instance.OrderDtlID);
}
}
}
else
{
throw new Exception("Command Argument is Wrong!");
}
//string exDtl = string.Empty;
//if (instance.ProposedBasePrice < instance.BasePrice)
//{
// exDtl += string.Format(" #Proposed BasePrice Changed for \"{0}\" ", instance.PartNum);
//}
//if(instance.ProposedSellingPrice < instance.SellingPrice)
//{
// exDtl += string.Format(" #Propsed SellingPrice Changed for \"{0}\" ", instance.PartNum);
//}
//if(!string.IsNullOrEmpty(exDtl))
//{
// int i = SqlText.ExecuteNonQuery("UPDATE OrderHed SET Exception = 1 " +
// ",ExceptionDtl = @exDtl " +
// " Where OrderHedID=@OrderHedID "
// , new { @OrderHedID = instance.OrderHedID, @exDtl = exDtl });
//}
}
public void r105Implementation(ApprovalNormalOrdersModel instance)
{
// This is the placeholder for method implementation.
if (instance.OrderHedID != null)
{
int ordStatus = 7;
//if (UserIsInRole("SalesManager"))
//{
// //6 = Lv2 approval when order is exception
// //7 = Approved when order is normal
// ordStatus = instance.Exception == true ? 6 : 7;
//}
SqlText.ExecuteNonQuery("Update OrderHed Set OrderStatusID=@OrderStatusID Where OrderHedID=@OrderHedID ",
new { @OrderHedID = instance.OrderHedID, @OrderStatusID = ordStatus });
SqlText.ExecuteNonQuery(
"Insert into OrderStatusLog (OrderHedID,UserID,[Comment],[RejectReason],[OtherRemarks],[TranDate]) Values " +
"(@OrderHedID,@UserID,@Comment,@RejectReason,@OtherRemarks,@TranDate) "
, new
{
@OrderHedID = instance.OrderHedID,
@UserID = UserId,
@Comment = "Order Approved",
@RejectReason = instance.RejectedReason,
@OtherRemarks = instance.RejectedRemarks,
@TranDate = DateTime.Now
});
EpiRequest SORequest = new EpiRequest();
EpiResponse ObjEpiRes = SORequest.CreateSO((int)instance.OrderHedID);
SqlText.ExecuteNonQuery("Update OrderHed Set EpiOrderNum=@EpiOrderNum, EpiError=@EpiError Where OrderHedID=@OrderHedID ",
new { @OrderHedID = instance.OrderHedID, @EpiOrderNum = ObjEpiRes.EpiOrderNum, @EpiError = ObjEpiRes.ErrMsg });
if (Arguments.SelectedValues.Count() > 1)
{
var lastValue = Convert.ToInt32(Arguments.SelectedValues.ToList().LastOrDefault());
//if (lastValue.Equals(instance.OrderHedID))
// Result.ShowAlert("Orders Approval Process Done! ");
}
else
{
//Result.ShowAlert("OrderNo : {0} Approved and Created in Epicor EpiOrderNum {1}! "
// , instance.OrderHedID, ObjEpiRes.EpiOrderNum);
}
//Result.ShowAlert("OrderNo : {0} Approved and Created in Epicor EpiOrderNum {1}! "
// , instance.OrderHedID, ObjEpiRes.EpiOrderNum);
}
else
{
Result.ShowAlert("Please Select Row!");
}
}
public void CreateMetaData()
{
Assert.Throws<TypeCannotBeUsedAsAClrTypeException>(() => SqlText.GetTypeHandler().CreateMetaData(null));
SqlTypeHandler col = new SqlText("Test", ParameterDirection.Input);
var meta = col.CreateMetaData("Test");
Assert.AreEqual(SqlDbType.Text, meta.SqlDbType);
Assert.AreEqual(-1, meta.MaxLength);
Assert.AreEqual("Test", meta.Name);
}
public void r107Implementation(Contratado_Solicitud_VacacionesModel instance)
{
using (SqlProcedure sql = new SqlProcedure("dbo.sp_Administrar_Solicitud_Vacaciones"))
{
sql.Command.CommandTimeout = 60 * 10;
//Definición parametro especial para recibir el RETURN del SP
sql.AddParameter("RetVal", 0);
sql.Parameters["RetVal"].Direction = ParameterDirection.ReturnValue;
sql.AddParameter("@Tipo_Operacion_Id", 1); // 1. Significa INSERT/CREACION NUEVO
sql.AddParameter("@Contratado_Solicitud_Vacaciones_Id", 0); /// Este es el ID de la tabla de solicitudes.
sql.AddParameter("@Solicitud_Vacaciones_Key", "");
sql.AddParameter("@Contratado_Id", instance.Contratado_Id);
sql.AddParameter("@Fecha_Solicitud", instance.Fecha_Solicitud);
sql.AddParameter("@Dias_Solicitados", instance.Dias_Solicitados);
sql.AddParameter("@Fecha_Inicio_Vacaciones", instance.Fecha_Inicio_Vacaciones);
sql.AddParameter("@Fecha_Fin_Vacaciones", instance.Fecha_Fin_Vacaciones);
sql.AddParameter("@Estatus_Solicitud_Id", instance.Estatus_Solicitud_Id);
sql.AddParameter("@Fecha_Autorizacion_Rechazo", DateTime.Today);
sql.AddParameter("@Autorizado_Rechazado_Por_Id", UserId);
sql.AddParameter("@Notas_Autorizacion_Rechazo", instance.Notas_Autorizacion_Rechazo);
sql.AddParameter("@Dias_Autorizados", instance.Dias_Autorizados);
sql.AddParameter("@Fecha_Inicio_Vacaciones_Autorizado ", instance.Fecha_Inicio_Vacaciones);
sql.AddParameter("@Fecha_Fin_Vacaciones_Autorizado ", instance.Fecha_Fin_Vacaciones);
sql.AddParameter("@HTML ", "");
/*Parametros de sistema**/
sql.AddParameter("@Creado_Por_Id", UserId);
sql.AddParameter("@Transaccion_Id", DBNull.Value);
sql.AddParameter("@Fijar_Bitacora", 1);
sql.AddParameter("@Mostrar_Tablas_Sistema", 0);
sql.AddParameter("@Mensaje_Sistema_Id", 1);
sql.AddParameter("@Simular", 0);
sql.AddParameter("@Trace", "");
sql.AddParameter("@Debug", 0);
sql.Parameters["@Mensaje_Sistema_Id"].Direction = ParameterDirection.Output;
sql.Parameters["@Trace"].Direction = ParameterDirection.Output;
//Definición de tamaños que soporten los tipos de datos de los parametros del salida del SP
sql.Parameters["@Mensaje_Sistema_Id"].Size = 4;
sql.Parameters["@Trace"].Size = 8000;
sql.ExecuteNonQuery();
if (sql.Parameters["RetVal"].Value.ToString() != "1")
{
String ErrorMessage = SqlText.ExecuteScalar("SELECT Mensaje_Amigable_Usuario FROM dbo.Mensaje_Sistema WHERE Mensaje_Sistema_Id=" + sql.Parameters["@Mensaje_Sistema_Id"].Value.ToString()).ToString();
Result.ShowAlert(ErrorMessage);
}
else
{
Result.Continue();
}
} // using (SqlProcedure sql = new SqlProcedure("dbo.sp_Administrar_Solicitud_Vacaciones"))
} // public void r107Implementation(Contratado_Solicitud_VacacionesModel instance)
private void QueryMultipleTest <T1, T2, T3, T4>(T1 value1, T2 value2, T3 value3 = default(T3), T4 value4 = default(T4))
{
// set-up
ISqlQuery sqlQuery = A.Fake <ISqlQuery>();
SqlText sqlText = A.Fake <SqlText>();
IGridReader gridReader = A.Fake <IGridReader>();
if (value1 != null)
{
A.CallTo(() => gridReader.Read <T1>()).Returns(new[] { value1 });
}
if (value2 != null)
{
A.CallTo(() => gridReader.Read <T2>()).Returns(new[] { value2 });
}
if (value3 != null)
{
A.CallTo(() => gridReader.Read <T3>()).Returns(new[] { value3 });
}
if (value4 != null)
{
A.CallTo(() => gridReader.Read <T4>()).Returns(new[] { value4 });
}
A.CallTo(() => sqlQuery.QueryMultiple(A <string> .Ignored, A <ParameterCollection> .Ignored, CommandType.Text, A <int?> .Ignored, A <Action <IDbConnection> > .Ignored)).Returns(gridReader);
IEnumerable <IEnumerable> result;
// call and assert
if (value4 != null)
{
result = sqlQuery.QueryMultiple <T1, T2, T3, T4>(sqlText);
((IEnumerable <T1>)result.First()).First().MustBe(value1);
((IEnumerable <T2>)result.Skip(1).First()).First().MustBe(value2);
((IEnumerable <T3>)result.Skip(2).First()).First().MustBe(value3);
((IEnumerable <T4>)result.Skip(3).First()).First().MustBe(value4);
}
else if (value3 != null)
{
result = sqlQuery.QueryMultiple <T1, T2, T3>(sqlText);
((IEnumerable <T1>)result.First()).First().MustBe(value1);
((IEnumerable <T2>)result.Skip(1).First()).First().MustBe(value2);
((IEnumerable <T3>)result.Skip(2).First()).First().MustBe(value3);
}
else
{
result = sqlQuery.QueryMultiple <T1, T2>(sqlText);
((IEnumerable <T1>)result.First()).First().MustBe(value1);
((IEnumerable <T2>)result.Skip(1).First()).First().MustBe(value2);
}
}
protected void AddSeparator(string newSeparator)
{
if (Separator == null)
{
Separator = newSeparator;
}
else
{
SqlText.Append(Separator);
}
}
/// <summary>
/// Executes the <see cref="SqlText"/>.
/// </summary>
/// <param name="sqlExecute"></param>
/// <param name="sqlText"></param>
/// <returns></returns>
public static int Execute(this ISqlExecute sqlExecute, SqlText sqlText)
{
string sql = sqlText.Sql();
if (string.IsNullOrEmpty(sql))
{
return(0);
}
return(sqlExecute.Execute(sql, sqlText.Parameters, CommandType.Text));
}
public void CreateMetaData()
{
Assert.Throws <TypeCannotBeUsedAsAClrTypeException>(() => SqlText.GetTypeHandler().CreateMetaData(null));
SqlTypeHandler col = new SqlText("Test", ParameterDirection.Input);
var meta = col.CreateMetaData("Test");
Assert.AreEqual(SqlDbType.Text, meta.SqlDbType);
Assert.AreEqual(-1, meta.MaxLength);
Assert.AreEqual("Test", meta.Name);
}
public override int GetHashCode()
{
var hash = TypeName.GetHashCode();
hash += SqlText.GetHashCode();
if (Arguments.Length > 0)
{
hash += Arguments[0].GetHashCode();
}
return(hash);
}
private static void SaveEnquiryItems(Order order, Int32 jobId, Store store)
{
// Insert each Order Item
using (SqlText insertItem = new SqlText(
"Insert Into [ALL_EnquiryItems] " +
"(JobId, ProductId, ProductCode, ProductLink, ProductSupplierName, ProductSupplierPublicUrl, Quantity ) " +
"Values (@JobId, @ProductId, @ProductCode, @ProductLink, @ProductSupplierName, @ProductSupplierPublicUrl, @Quantity )", crmConnectionStringName))
{
Int16 itemCount = 0;
// Database connection is held open whilst each item is inserted
foreach (OrderItem item in order.Items)
{
string prodCode = "";
if (!string.IsNullOrEmpty(item.Sku))
{
prodCode = item.Sku;
}
else
{
prodCode = item.Product.ModelNumber;
}
string supplierLink = "";
if (item.Product.CustomFields != null && item.Product.CustomFields.Count > 0)
{
foreach (ProductCustomField fld in item.Product.CustomFields)
{
if (fld.FieldName == "SupplierPublicURL")
{
supplierLink = fld.FieldValue;
}
}
}
insertItem.AddParameter("@JobId", jobId);
insertItem.AddParameter("@ProductId", item.ProductId);
insertItem.AddParameter("@ProductCode", prodCode);
insertItem.AddParameter("@ProductLink", store.StoreUrl.Trim() + item.Product.NavigateUrl.Substring(2));
if (item.Product.Manufacturer != null && item.Product.Manufacturer.Name != null)
{
insertItem.AddParameter("@ProductSupplierName", item.Product.Manufacturer.Name);
}
else
{
insertItem.AddParameter("@ProductSupplierName", System.Data.SqlTypes.SqlString.Null);
}
insertItem.AddParameter("@ProductSupplierPublicUrl", supplierLink);
insertItem.AddParameter("@Quantity", item.Quantity);
int x = insertItem.ExecuteNonQuery();
insertItem.ClearParameters();
} // end foreach
}
}
public void r102Implementation(ApprovalExceptionOrdersModel instance)
{
// This is the placeholder for method implementation.
Finsoft.Data.PageRequest page = (Finsoft.Data.PageRequest)Context.Items["PageRequest_Current"];
if (page.View == "editForm1")
{
if (instance.OrderHedID != null)
{
var custInfo = SqlText.Execute("select * from vwCustomer a inner join OrderHed b On a.SysRowID=b.CustSysRowID where b.OrderHedID=@OrderHedID", new { OrderHedID = instance.OrderHedID });
if (custInfo != null)
{
instance.CAddress1 = custInfo[5].ToString();
instance.CAddress2 = custInfo[6].ToString();
instance.CAddress3 = custInfo[7].ToString();
instance.CCity = custInfo[8].ToString();
instance.CState = custInfo[9].ToString();
instance.CZip = custInfo[10].ToString();
instance.CCountry = custInfo[11].ToString();
instance.CreditLimit = Convert.ToDecimal(custInfo[14]);
instance.Balance = Convert.ToDecimal(custInfo[13]);
instance.UnPaidInvoices = Convert.ToDecimal(custInfo[15]);
instance.OutStandingOrders = Convert.ToDecimal(custInfo[16]);
instance.UnPostedInvoices = Convert.ToDecimal(custInfo[17]);
instance.AgeCurr = Convert.ToDecimal(custInfo[18]);
instance.Age30 = Convert.ToDecimal(custInfo[19]);
instance.Age60 = Convert.ToDecimal(custInfo[20]);
instance.Age90 = Convert.ToDecimal(custInfo[21]);
instance.Age120 = Convert.ToDecimal(custInfo[22]);
instance.Age150 = Convert.ToDecimal(custInfo[23]);
instance.TermsExceed = Convert.ToBoolean(custInfo[24]);
instance.PhoneNum = custInfo[26].ToString();
instance.FaxNum = custInfo[27].ToString();
}
}
if (instance.OrderHedID != null)
{
var shipInfo = SqlText.Execute("select * from vwShipTo a inner join OrderHed b On a.SysRowID=b.ShipToSysRowID where b.OrderHedID=@OrderHedID", new { OrderHedID = instance.OrderHedID });
if (shipInfo != null)
{
instance.SAddress1 = shipInfo[6].ToString();
instance.SAddress2 = shipInfo[7].ToString();
instance.SAddress3 = shipInfo[8].ToString();
instance.SCity = shipInfo[9].ToString();
instance.SState = shipInfo[10].ToString();
instance.SZip = shipInfo[11].ToString();
instance.SCountry = shipInfo[12].ToString();
instance.SPhoneNum = shipInfo[14].ToString();
instance.SFaxNum = shipInfo[15].ToString();
}
}
}
}
public DynamicSqlTextTokenHandler(SqlTagContext ctx, SqlText sqlText)
{
if (ctx == null)
throw new ArgumentNullException("ctx");
if (sqlText == null)
throw new ArgumentNullException("sqlText");
_ctx = ctx;
_sqlText = sqlText;
KeepSurroundingToken = true;
}
internal IList<BindingReplacement> BuildTextBindingReplacements(SqlText tag)
{
if (tag == null)
throw new ArgumentNullException("tag");
return InlineParameterMapParser.BuildBindingReplacements(_bindings, new StringBuilder(tag.Text));
}
internal string ReplaceIterateCurrentProperty(SqlText sqlText, string tokenValue)
{
return ReflectionMapper.GetReflectedFullName(this, sqlText, tokenValue);
}
internal string ReplaceIteratePropertiesAndVariables(SqlText sqlText, string sql)
{
if (sqlText == null)
throw new ArgumentNullException("sqlText");
if (sql == null)
throw new ArgumentNullException("sql");
ReplaceParameterIteratePropertiesAndVariables(sqlText);
var sqlStatementBuilder = new StringBuilder(sql);
var replacements = BuildTextBindingReplacements(sqlText);
ReplaceBindingVariables(replacements, sqlStatementBuilder);
return sqlStatementBuilder.ToString();
}
internal void ReplaceParameterIteratePropertiesAndVariables(SqlText sqlText)
{
if (sqlText.Parameters != null)
{
foreach (var parameter in sqlText.Parameters)
{
var parameterBindingReplacements = InlineParameterMapParser.BuildBindingReplacements(_bindings, new StringBuilder(parameter.PropertyName));
foreach (var replacement in parameterBindingReplacements)
parameter.ReplaceBindingName(replacement);
parameter.ApplyIteratePropertyReferenceHandling(this, sqlText);
}
}
}
public void AddParameterMappings(SqlText sqlText)
{
if (sqlText == null)
throw new ArgumentNullException("sqlText");
ParameterProperty[] parameters = sqlText.Parameters;
if (parameters != null)
{
int length = parameters.Length;
for (int i = 0; i < length; i++)
{
var parameter = parameters[i];
parameter.ApplyIteratePropertyReferenceHandling(this, sqlText);
this.AddParameterMapping(parameter);
}
}
}
