public static int SendMT(
string UserId,
string Content,
string ShortCode,
string CommandCode,
int ServiceType,
int ServiceId,
int MessageType,
string RequestId,
int TotalMessage,
int MessageIndex,
int IsMore,
int ContentType
)
{
//------------------
if (UserId.StartsWith("+"))
{
UserId = UserId.Replace("+", string.Empty);
}
if (UserId.StartsWith("0"))
{
UserId = "84" + UserId.Remove(0, 1);
}
Visport_MT_Info mtInfo = new Visport_MT_Info();
mtInfo.User_ID = UserId;
mtInfo.Message = Content;
mtInfo.Short_Code = ShortCode;
mtInfo.Command_Code = CommandCode;
mtInfo.Message_Type = MessageType;
mtInfo.Request_ID = RequestId;
mtInfo.Total_Message = TotalMessage;
mtInfo.Message_Index = MessageIndex;
mtInfo.IsMore = IsMore;
mtInfo.Content_Type = ContentType;
mtInfo.MT_Price = 0;
mtInfo.Service_Type = ServiceType;
mtInfo.Service_ID = ServiceId;
mtInfo.Partner_ID = "VMG";
mtInfo.Operator = "VNM";
int result = Insert(mtInfo);
return(result);
}
public static int Insert(Visport_MT_Info mt_info)
{
SqlConnection dbConn = new SqlConnection(ConnectionString);
SqlCommand dbCmd = new SqlCommand("Visport_MT_Sending_Insert", dbConn);
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.AddWithValue("@User_ID", mt_info.User_ID);
dbCmd.Parameters.AddWithValue("@Message", mt_info.Message);
dbCmd.Parameters.AddWithValue("@Short_Code", mt_info.Short_Code);
dbCmd.Parameters.AddWithValue("@Command_Code", mt_info.Command_Code);
dbCmd.Parameters.AddWithValue("@Message_Type", mt_info.Message_Type);
dbCmd.Parameters.AddWithValue("@Request_ID", mt_info.Request_ID);
dbCmd.Parameters.AddWithValue("@Total_Message", mt_info.Total_Message);
dbCmd.Parameters.AddWithValue("@Message_Index", mt_info.Message_Index);
dbCmd.Parameters.AddWithValue("@IsMore", mt_info.IsMore);
dbCmd.Parameters.AddWithValue("@Content_Type", mt_info.Content_Type);
dbCmd.Parameters.AddWithValue("@MT_Price", mt_info.MT_Price);
dbCmd.Parameters.AddWithValue("@Service_Type", mt_info.Service_Type);
dbCmd.Parameters.AddWithValue("@Service_ID", mt_info.Service_ID);
dbCmd.Parameters.AddWithValue("@Partner_ID", mt_info.Partner_ID);
dbCmd.Parameters.AddWithValue("@Operator", mt_info.Operator);
dbCmd.Parameters.AddWithValue("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
return((int)dbCmd.Parameters["@RETURN_VALUE"].Value);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbConn.Close();
}
}
